Import payable manual payments into Dynamics GP 2015 using Integration Manager

(0) Share

Report

Posted on by Community Member

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!

8400.Capture.JPG

*This post is locked for comments

I have the same question (0)

All responses (8)

Answers (0)

Community Member on at

Like (0)

Report

RE: Import payable manual payments into Dynamics GP 2015 using Integration Manager

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.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Import payable manual payments into Dynamics GP 2015 using Integration Manager

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

Was this reply helpful? Yes No
Heather Roggeveen 9,146 on at

Like (0)

Report

RE: Import payable manual payments into Dynamics GP 2015 using Integration Manager

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.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Import payable manual payments into Dynamics GP 2015 using Integration Manager

Matt,

Do you have a sample spreadsheet to use for this?

Was this reply helpful? Yes No
Gerbear on at

Like (0)

Report

RE: Import payable manual payments into Dynamics GP 2015 using Integration Manager

I would refer to the SDK as it lays out table info and required fields in detail.

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

RE: Import payable manual payments into Dynamics GP 2015 using Integration Manager

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

Was this reply helpful? Yes No
Richard Wheeler 75,848 Moderator on at

Like (0)

Report

RE: Import payable manual payments into Dynamics GP 2015 using Integration Manager

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.

Was this reply helpful? Yes No
Suggested answer

MattPaulen 6,912 on at

Like (0)

Report

RE: Import payable manual payments into Dynamics GP 2015 using Integration Manager

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.

Was this reply helpful? Yes No