AP History

(0) Share

Report

Posted on by lciolfi

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

All responses (5)

Answers (0)

Suggested answer

Victoria Yudin 22,766 on at

Like (0)

Report

RE: AP History

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
lciolfi 315 on at

Like (0)

Report

RE: AP History

Yes, I know that is the preferred method but how do I extract the historical transactions? A Smartlist to Excel?
Suggested answer

Victoria Yudin 22,766 on at

Like (0)

Report

RE: AP History

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.
lciolfi 315 on at

Like (0)

Report

RE: AP History

I've done that and a few other tables. The issue I'm having is when I void one of the historical transactions I copied over it doesn't reopen the voucher in the open transaction window
Suggested answer

Community Member Microsoft Employee on at

Like (0)

Report

RE: AP History

Hi,

you need to refer each company PM30200 table for Historical AP transactions

by creating custom script, you can achieve the above scenario