lcarness 6/5/2019 4:36:49 PM

Last Date a GL Account Was Used?

Does anyone has a script to pull the last date a GL account had activity? 

I have one I found on another site, but for some reason there are hundreds of accounts it does not pull a date for? Yet, if I go into GP I find transactions for those accounts, so it is not because they never had any activity.

This would be very helpful. 

Thanks

 

Version: GP 2013
Section: Dynamics GP, SQL Scripts


Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables
3