315
Does anyone know what tables need to be populated if I want to copy AP history for this year and last year from one GP company to another? The vendors in both companies are identical including the vendor ids
*This post is locked for comments
The Payables Transactions SmartList to Excel is probably best to get the data. However, you will not see the apply information that way. If you need the apply information, you can use the code here: victoriayudin.com/.../sql-view-for-payables-payment-apply-detail-in-dynamics-gp
I am sorry, but you cannot just copy a few tables and have it work. There are a LOT of related tables and records in summary tables that need to be considered. The best approach is to import transactions using a tool designed for this, for example Integration Manager.
Hi,
you need to refer each company PM30200 table for Historical AP transactions
by creating custom script, you can achieve the above scenario
Share
Report
All responses (
Answers (
