Hi,
I would like to bringing historical data of payable manual payments into Dynamics GP using Integration Manager; however I don't know which template in the Integration manager should I use? Below is the screen shot of the form in the Purchasing module that I would like to bring the data in. Any helps is greatly appreciated! Thanks!
*This post is locked for comments
I only know how to use eConnect through Integration Manager and Purchasing only has Purchase Order Entry, Receivings Transaction Entry, and Vendor. None of those would help me import paid transactions. I want to upload invoices with payment details that will go into the bank rec. I just don't know what my upload doc needs to look like. If someone can send me an example of theirs, that would help tremendously.
You may also want to consider straight eConnect to import payable manual payments into Dynamics GP.
You may also use VKonnact tool for importing data into GP. VKonnact uses eConnect for the backend but shields the user from all of the eConnect complexities.
Apart from the standard econnect integration node VKonnact supports "Dynamics GP - Apply Payables documents" integration too.
-Thanks
Vinod Agrawal
www.flovianit.com
Also the problem with bringing them in as payments is that they would also then post into your bank reconciliation and you would have to clear them out.
I concur with the suggestion of bringing them in as a Credit document.
Matt,
Do you have a sample spreadsheet to use for this?
I agree with Richard Wheeler
you can upload payment as Credit memo unapplied Documents and then use the window for apply the document or make auto apply by macro as eng Richard mention to the URL or make it manually
Another suggestion is to import the payments as unapplied credit memos. Then you can run the AP macro as per our good friend Mohammad Daoud found in this link.
mohdaoud.blogspot.com/.../mass-auto-apply-for-payables-management_4277.html
So you import your payables invoices and import the credit memos and then the macro will apply the credit memos to the invoices and your history will be correct.
Integration Manager doesn't have a destination for manual payments.
One thing you could do if you really want to get historical data in there with the payments applied is when you import the invoices, you can pay them off at the same time.
This will create the payment record and pay off the invoice at the same time. The only issue you'd have is applying one payment to multiple records. If the check number was 1000 for example, you could do 1000-1, 1000-2, 1000-3, 1000-4, etc against each of the single invoices when you import them. Or even set the checkbook to allow duplicate check numbers but you'd have multiple payments with the same number then.
Importing historical payments is always a tricky subject due to the applying part.
#1
André Arnaud de Cal...
291,759
Super User 2024 Season 2
#2
Martin Dráb
230,468
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
