Integration - Add line item to existing SOP Invoice

(0) Share

Report

Posted on by JGarcia123

466

I have a need for a SOP integration where I add a line item to an existing invoice. The invoice is sitting unposted in a batch. Is this something I can do through e-connect? Actually we use SmartConnect with relies on the e-connect objects. I am open to any suggestions/recommendations and look forward to a response.

Categories:

Microsoft Dynamics GP

All responses (3)

Answers (0)

Richard Wheeler 75,788 Moderator on at

Like (0)

Report

RE: Integration - Add line item to existing SOP Invoice

There are flags on line you can set to indicate update or insert. It took me quite a while to get it working. A lot of trial and error. The documentation was quite useless when it came to this.
JGarcia123 466 on at

Like (0)

Report

RE: Integration - Add line item to existing SOP Invoice

Thank you, Richard,

That is very close to our scenario. In our case we have a line item with a quantity of 1 and $0 for the price. The integration will calculate the sales price and then either update or replace the line.

Appreciate the insights and thought.

JG
Richard Wheeler 75,788 Moderator on at

Like (1)

Report

RE: Integration - Add line item to existing SOP Invoice

Yes, eConnect can do this. You actually need treat this as deleting the lines an re-entering them. We have such an integration that imports from a warehouse management system. The orders go out to the WMS, and when the WMS does the shipping, what was actually shipped comes back as a csv file. This file is then imported updating the existing olders changing all the B/O quantities to quantities allocated and fulfilled.