Hi,
Using eConnect - how would I create a purchase order that is linked to an existing sales order?
Thanks,
Sas
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
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
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.
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
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
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
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 290,524 Super User 2024 Season 2
Martin Dráb 228,493 Most Valuable Professional
nmaenpaa 101,148