I am working with our GL team and they would like to pull a report of accounts and when they were used last.
In preparation to the V11 move we want to clean up our chart of accounts and I am unsure how to pull this history.
Thank you,
I would use Crystal to pull data from GLTRANS table including AU, Account and Dates (R_Date, Posting Date, Update Date, etc.). Group data by AU then Account and add a Max of Date formula in the Account group. Suppress the detail section and you end up with something like this...
Export to Excel and sort by the max date to see which accounts haven't been used in a while. You can bump this against your full chart of accounts by using a VLOOKUP formula to see which accounts have had no activity. Keep in mind that some accounts my have been added recently.
TY - I was able to create a query from your information. Have a great day!
