sop to pop link

Posted on 2012-09-14
Last Modified: 2012-09-18

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

The econnect schema looks like this:


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?

Question by:WilliamAK
    LVL 18

    Accepted Solution

    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.


    Steve Endow
    Dynamics GP Certified Trainer
    Dynamics GP Certified IT Professional

    Author Closing Comment

    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.

    Featured Post

    What Security Threats Are You Missing?

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    Join & Write a Comment

    Automatically creating a Trello card using data from a Microsoft Dynamics CRM record turned out to be an easy project that yielded great results.  Here's how I did this for an internal team at General Code.
    Deploying a Microsoft Access application in a Citrix environment is not difficult but takes a few steps. However, Citrix system people are often of little help, as they typically know next to nothing about Access. The script provided here will take …
    The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
    The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…

    754 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    23 Experts available now in Live!

    Get 1:1 Help Now