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
mark4yesu 8/20/2018 2:29:42 PM

ADVICE NEEDED: GP Company rebuild?


I have a client that setup a new Company DB, put in some opening transactions as of 12/31/2017.  Changed their mind.  Wanted to put in opening Transactions of 7/1/2018 instead.  They have posted GL transactions prior to that for sure.

they have vendors and GL accounts setup just the way they want them.

What's the best approach?

1. Remove all prior transactions and update Summary balances?  If so how?

2.  Setup a new company DB and bring over COA, vendors and all other setup items ? If so, how?


Version: GP 2015, GP 2013
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