Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP forum
Unanswered

Integration - Add line item to existing SOP Invoice

Posted on by 1,353

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.

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    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 Profile Picture
    JGarcia123 1,353 on at
    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 Profile Picture
    Richard Wheeler 75,730 on at
    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.

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 287,696 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,490 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans