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

Sign Up Now!Log In
melkovace 6/20/2019 10:01:03 AM

SQL script to create JE from the sub-ledgers(RM, AP, AR etc)

We had the post through GL unchecked for about a week and now need to process thousands and thousands of transactions.  Going through and checking each batch would take a huge amount of time.  We have been asked to create a script that would look at the sub-ledgers and create one JE for the GL.  Does anyone have a script that would help create these?
Version: GP 2015
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