lcarness 11/20/2019 4:00:34 PM

Appending GL Transactions (Open Year) with Additional Data

We are using GP 2018

I imported GL transactions data from GP 2013 through Smart Connect. It will not let you import certain fields which originate from Purchasing - such as Originating Master ID, Originating Master Name, and Originating Doc Number.

The lack of this information for current year transactions in our new system has made life much more difficult than originally anticipated. 

Has anyone ever appended this type of data to existing GL transactions using SQL?  Are there any unintended consequences for A/P? does it mess up the PM tables? I don't see how since this data is posted to GL20000?

Any advice would be appreciated. 

Thanks

 

Version: Unknown or N/A, All
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
3