Add new SOP line to already existing invoice via eConnect

(0) Share

Report

Posted on by Community Member

Hi guys, i'm creating some pretty basic SOP invoices in GP via econnect (no taxes or commissions) and everything is working fine.

I just need to add some new code to add a new sop line to some of these invoices (non posted), but cant really find any documentation on how to do this properly and most important easily :) The econnect documentation just really talks about modifying current lines, or deleting lines, but are kind of vague about adding new lines after the fact. So was just wondering if anyone has done this before. By the looks of the documentation, I am guessing I need to resend in all of the header info again, and switch "Update If Exists" on the header to true, and maybe pass in all of the lines again (with Update If Exists on the lines) with the new line included as well ? This just seems like a little bit of effort.

Would it be easier just to add a new sop line directly in the db to the SOP10200 details table, and just update the totals accordingly ? I'm guessing this is probably bad practice though.

Any and all comments will be much appreciated.

*This post is locked for comments

All responses (2)

Answers (2)

Verified answer

Community Member on at

Like (0)

Report

RE: Add new SOP line to already existing invoice via eConnect

Thank you for your reply Soma.
Verified answer

soma 24,410 on at

Like (0)

Report

RE: Add new SOP line to already existing invoice via eConnect

If you want to append a new SOP line data to the existing saved transactions, you need to pass "Update If Exists" to 1 on header section and also pass the existing line data with "Update If Exists" to 1 then additionally pass a value for new SOP line.

For example, you have a SOP order with 2 lines. So, you need to use "Update If Exists" to 1 in header section and pass the 2 lines value already saved in SOP order with "Update If Exists" to 1 in line section and additionally pass the new line value. So, your need code comes with 1 SOP header with 3 lines.

I think this is the better approach for your requirement.

Hope this helps!!!