Is there a report/smartlist to show the last date that a general ledger account number was used? I want to get rid of accounts no longer be utilized. Thanks.
*This post is locked for comments
What do you plan to do with the account history Tracy? Merge with another account?
I plan to leave the account history on the account. I want to inactivate/disallow account entry on accounts no longer valid. My thought is that having less active accounts will help the system be more efficient.
Tracy,
A quick group by query on GL30000 with the max. transaction date by acct index should get you started. I have not totally fleshed this out for you. Please let us know if you the actual sql syntax.
Warren
Warren's idea sounds like a good plan. There is no OOB SmartList that will provide this, although you could create one using SmartList Builder.
If you can do this in SQL, you can use the code here http://victoriayudin.com/2011/04/27/sql-view-for-all-gl-transactions-in-dynamics-gp/ to create a view of all GL transactions, then run the following query:
select Account_Number, Account_Description, max(Trx_Date) Last_Used
from view_GL_Trx
group by Account_Number, Account_Description
order by max(Trx_Date)
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
