web

You’re offline. This is a read only version of the page.

Dynamics 365 CommunityForums Microsoft Dynamics GP (Archived) How to create a Purcha...

Microsoft Dynamics GP (Archived)

How to create a Purchase order from Sales order using eConnect XML

(0) Share

Report

Report

Posted on by Rajeev Gupta

65

We are trying to create a process to automate the creation of PO from a Sales Order.

We are trying to use taSopToPopLink but unsuccessful so far.

The follow eConnect call comes back with no error, any guidance will be helpful.

<eConnect xmlns:dt="urn:schemas-microsoft-com:datatypes">
<taSopToPopLink>
<SOPTYPE>2</SOPTYPE>
<SOPNUMBE>000002</SOPNUMBE>
</taSopToPopLink>
</eConnect>

Thanks

RG

*This post is locked for comments

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Community Member on at

Like (0)

Report

Re: How to create a Purchase order from Sales order using eConnect XML

The Schema you are using creats a link between an existing POP document and an existing SOP document. It creates a commitment whereby a POP document is committed to a SOP document.

For this schema to run properly, both documents have to exist already.

This schema will not auto create a POP document from a SOP document.

As far as I know there is no Schema to achieve this. You could however just run the POP create schema off the same data that you use to create the SOP document, and then use the schema above to link them.

(note that the schema to remove this link is situated in the POP schemas).

Ian.

Was this reply helpful? Yes No
Verified answer

Rajeev Gupta 65 on at

Like (0)

Report

Re: How to create a Purchase order from Sales order using eConnect XML

Finally found the issue, one step forward

taSOPtoPOPLink actually does create the PO documents. The issue that I found was that it was expecting <SOPtoPOPTransactionType> element in it. The following did work and I can see the PO created and POP10100 and POP10110 tables.

It should be as -

<eConnect xmlns:dt="urn:schemas-microsoft-com:datatypes">

<SOPtoPOPTransactionType>

<taSopToPopLink>

<SOPTYPE>2</SOPTYPE>

<SOPNUMBE>000002</SOPNUMBE>

</taSopToPopLink>

</SOPtoPOPTransactionType>

</eConnect>

Thanks all for looking at it.

Rajeev Gupta

www.mydbsync.com

Was this reply helpful? Yes No

Helpful resources

Quick Links

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1

Community Member 4

#2

Victoria Yudin 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans