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