Search the GP Tables
Search by TABLE NAME
Search by FIELD NAME
These are our SOP scripts. All of our scripts for Dynamics GP can be found here

Table Edits Forum Articles
Table Edits 0 Table Edits 0 Table Edits 0
Sign Up Now!Log In
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. 



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