Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1369
  • Last Modified:

sop to pop link

Hi,

I wanted to add a sop to pop link using econnect.

The econnect schema looks like this:

<taSopToPopLink>
SOPTYPE
SOPNUMBE
VENDORID
DOCDATE
CURNCYID
SHIPMTHD

But the SOP60100 table (the sop to pop link table) has more fields like PONUMBER, LNITMSEQ, and ORD that I need to populate.

Am I missing an XML node that handles the missing fields?

Does anyone have an dotnet example (or even just the xml) of how to implement a soptopop link from econnect?

Thanks,
William
0
WilliamAK
Asked:
WilliamAK
1 Solution
 
Steve EndowMicrosoft MVP - Dynamics GPCommented:
Hi William,

The eConnect SOP to POP link is designed to create a new Purchase Order based on a Sales Order.

From the eConnect help file:

You can use the <taSopToPopLink> XML node to create new purchase orders.

You send in the SOP Type, SOP Number, and Vendor ID, and eConnect creates the new Purchase Order.

taSopToPopLink does not allow you to link an existing SOP Order to an existing Purchase Order, and it does not allow you to link specific SOP Order line items to an existing Purchase order Line.

It also does not allow you to create a PO for only certain lines, and does not allow you to specify whether the PO is Standard or Drop Ship.

If you need more functionality than what taSopToPopLink offers, you can create a new PO using eConnect for the line items that you need to purchase, and then insert records to create your SOP to POP linking.

Just make sure to thoroughly test the linking if you decide to insert the records yourself.


Thanks,

Steve Endow
Dynamics GP Certified Trainer
Dynamics GP Certified IT Professional
0
 
WilliamAKAuthor Commented:
Thanks Steve, that makes sense now.

Actually, that's how I ended up doing it.  I'm using econect to insert the drop ship PO, and then writing the link records myself.  Then setting the sales commitment fields in the sop and pop tables.
0

Featured Post

Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now