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 6/6/2013 10:57:16 AM

Dynamics GP - GL Posted Batch approval Information

Hi ,

I am looking to get the following fields in my SmartList for Posted GL Transactions

Batch Number

APPROVL   (Approval)  

APPRVLDT  (Approval Date

APRVLUSERID  (Batch Approved By)


I know system stores this information in SY00500 when batch is in unposted status but it is removed a soon as the batch is posted

I will like to know what table(s) this information is stored in after the Batch is posted

Any help is greatly appreciated





Version: GP 2010
Section: Dynamics GP

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