Skip to main content

Notifications

Microsoft Dynamics GP forum
Suggested answer

eConnect Purchase Orders

Posted on by 10

Hi,

Using eConnect - how would I create a purchase order that is linked to an existing sales order?

Thanks,

Sas

  • Suggested answer
    Isaac Olson Profile Picture
    Isaac Olson on at
    RE: eConnect Purchase Orders

    Hi Sas, 

    That is great to hear!  When you create the item with eConnect and you assign it to sites in GP, you would use the taItemSite stored procedure and that is where you would list the primary vendor for that item/site combination.  

    <taItemSite>*

    Element name

    Data type

    Length

    Required

    Default

    Description

    ITEMNMBR

    string

    30

    Y

    Not applicable

    Item number

    LOCNCODE

    string

    10

    Y

    Not applicable

    Location code/site

    BINNMBR

    string

    20

    N

    Default is from setup

    Bin

    PRIMVNDR

    string

    15

    N

    Default is from setup

    Primary vendor ID

    Landed_Cost_Group_ID

    string

    15

    N

    Default is from setup

    Landed cost group ID

    QTYRQSTN

    number

    21

    N

    Default is from setup

    Requisition quantity

    UpdateIfExists

    i4

    1

    N

    1

    Flag to allow the item location data to be updated if it exists:

    0=No;

    1=Yes

    USRDEFND1

    string

    50

    N

    <blank>

    User-defined field—developer use only

    USRDEFND2

    string

    50

    N

    <blank>

    User-defined field—developer use only

    USRDEFND3

    string

    50

    N

    <blank>

    User-defined field—developer use only

    USRDEFND4

    string

    8000

    N

    <blank>

    User-defined field—developer use only

    USRDEFND5

    string

    8000

    N

    <blank>

    User-defined field—developer use only

    I hope this helps!  Also just as a general practice, while this question was similar in topic, I would recommend opening a separate thread for additional questions as someone else may benefit from the answer to your question, but may not find this thread because it is not the same issue as the title.  You can always paste a link to your original thread when you create the new thread if they are somewhat related. 

    Thanks!

    Isaac Olson

    Microsoft Suppor

  • sasjamal Profile Picture
    sasjamal 10 on at
    RE: eConnect Purchase Orders

    Hello,

    Thanks for sending that link. We have been looking at it (and using it to!).

    I do have a more specific question however.

    We are also using eConnect to create sales orders.

    Sometimes the items do not exist in GP and we have to create them at that point in time.

    There does not seem to be a way to specify the vendor.

    When we try to create a purchase order from that sales order it says we do not have a vendor associated with the item.

    Is there a way to specify the primary vendor when creating items?

    Thanks!

    Sas

  • Suggested answer
    Isaac Olson Profile Picture
    Isaac Olson on at
    RE: eConnect Purchase Orders

    Hi Sas, 

    What I can provide is what we have documented in the eConnect folder when you install eConnect. (C:\Program Files (x86)\Microsoft Dynamics\eConnect 18.0\Help\eConnectProgrammersGuide.chm)

    If you go to the Index tab and look at the SOPtoPOPTransactionType, there is a sample XML which uses the parameters below, to create a Purchase Order based on the Sales Order or Back Order that you choose.  

    SOPtoPOPTransactionType

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

    Element name

    Data type

    Length

    Required

    Default

    Description

    SOPTYPE

    i4

    2

    Y

    Not applicable

    2=Order;

    5=Back order

    SOPNUMBE

    string

    21

    Y

    Not applicable

    SOP number

    VENDORID

    string

    15

    N

    <blank>

    ID of vendor purchasing from for non-inventory items; required if non-inventory items are used (the vendor ID for inventory items uses Primary Vendor for the Item/Location combination as the default and does not use this parameter)

    DOCDATE

    datetime

    8 bytes

    (19 to 23 chars)

    N

    <blank>

    Date of the POs; default is current system state

    CURNCYID

    string

    15

    N

    <blank>

    Currency ID to use for all POs; default is from vendor or MC setup

    SHIPMTHD

    string

    15

    N

    Default from setup

    Shipping method to use for all POs; default is from vendor

    USRDEFND1

    string

    50

    N

    <blank>

    User-defined field—developer use only

    USRDEFND2

    string

    50

    N

    <blank>

    User-defined field—developer use only

    USRDEFND3

    string

    50

    N

    <blank>

    User-defined field—developer use only

    USRDEFND4

    string

    8000

    N

    <blank>

    User-defined field—developer use only

    USRDEFND5

    string

    8000

    N

    <blank>

    User-defined field—developer use only

    This node uses document exchange for updates. All existing values are overwritten with the value specified by the update document. If a field in the update is blank, the existing value is changed to be blank.

    I hope you find this information helpful.  Otherwise maybe another perspective from the community can chime in. 

    Thanks!

    Isaac Olson

    Microsoft Support

  • sasjamal Profile Picture
    sasjamal 10 on at
    RE: eConnect Purchase Orders

    Thank you, actually I did find that link but I was unable to fully understand it. Are there any other links so that I may see the answer from a different perspective?

    Thanks!

    Sas

  • Suggested answer
    agaber Profile Picture
    agaber on at
    RE: eConnect Purchase Orders

    Hi Sas-

    There was a good Forum post on this a while back that is hopefully helpful.  Basically the link is stored in the SOP60100 table.

    community.dynamics.com/.../using-econnect-to-create-purchase-orders-with-a-sop-to-pop-link

    I hope this information is helpful.  Have a great day!

    Best Regards,

    Adam Gaber

    Microsoft Dynamics GP

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,524 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,493 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Product updates

Dynamics 365 release plans