DynDeveloper.com

DynDeveloper.com

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