Finance | Project Operations, Human Resources, ...

eConnect Purchase Orders

(0) Share

Report

Posted on by sasjamal

Hi,

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

Thanks,

Sas

Categories:

Microsoft Dynamics GP

All responses (5)

Answers (0)

Suggested answer

Isaac Olson on at

Like (0)

Report

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 10 on at

Like (0)

Report

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

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 10 on at

Like (0)

Report

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 on at

Like (1)

Report

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