Question Status

Verified
Denny999 asked a question on 25 Mar 2015 4:42 AM

Hi Experts,

i am facing a problem. when I use eConnect to update the sale order. it show an error "Error Number = 8297 Stored Procedure= taSopLineIvcInsert Error Description = You can not change quantities because the line item is committed to a purchase order"?

Does anybody know what kind of scenario will cause this error?

Besides, from the error msg, i guess there are must be a link between sales order and purchase order.

If have, Does eConnect support add or remove the link?

 

thanks.

Reply
Mahmoud M. AlSaadi responded on 25 Mar 2015 5:04 AM

To follow the same logic, you may try to do so on the application level, I mean to update the sales order quantity. I would assume you will be facing the same error message which states that these quantities are simply committed

To break the line item quantity commitment, click on the icon "clip" which will open another window, click delete to break this commitment.

Is this valid in any way ?

Your feedback is highly appreciated,  

Best Regards,

Mahmoud M. AlSaadi

Dynamics GP Essentials |   mahmoudsaadi.blogspot.com

Reply
Verified Answer
Shan M responded on 25 Mar 2015 6:04 AM

Hi Denny,

It seems that particular Sales Order is linked with the Purchase order and its quantity were committed. As suggested by Mahmoud, it is better to check the Sales Order in GP and whether it is linked with the Purchase order.  Are you really trying to change the quantity with the update using econnect?  If the answer is no, then check the econnect parameters.

If the answer is yes. The answer for this is already provided in the  above post.

What is the purpose of updating the quantity?

Econnect nodes for linking and unlinking:

You can use the <taSopToPopLink> XML node to create new purchase orders with the link of the Sales Order.

In order to remove the link between the Purchase Order and the Sales Order use this node<taPopRemoveSopLink>

Hope it helps.

**To save someone's time, if this answers your question, mark it as 'Answered' so others experiencing the same will know the answer.

Thanks,

Shan

Reply
Verified Answer
Richard Wheeler responded on 25 Mar 2015 6:41 AM

Since you say you are using eConnect to update already existing sales orders if you go into GP and pull up one of these sales orders do you see a paper clip on each line? The paper clip means there is a SOP to POP commitment in place so quantities cannot be changed without the commitment being broken.  The SOP10200.QTYONPO will hold the value of the quantity on the PO and you will find the SOP-POP link table SOP60100 will contain the link to the PO.

Richard E. Wheeler 2013 and 2014 MVP

Member Microsoft Academic Alliance

www.rbsolutions.com Revered Business Solutions Ballston Lake, NY  518-877-0763 x10

Reply
Denny999 responded on 26 Mar 2015 4:24 AM

Hi Richard,

I still have another problem, when I use eConnect to update the sales order, it comes out an error "Error Number = 2699  Stored Procedure= taSopLineIvcInsert  Error Description = IN Parameter QUOTEQTYTOINV can only be used with quotes". Do you know something about that ?below is the xml:

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

<SOPTransactionType>

<taSopLineIvcInsert_Items>

<taSopLineIvcInsert>

<SOPTYPE>2</SOPTYPE>

<DOCID>STDORD         </DOCID>

<SOPNUMBE>ORD0003997</SOPNUMBE>

<CUSTNMBR>19004          </CUSTNMBR>

<DOCDATE>03/19/2015</DOCDATE>

<QUANTITY>0</QUANTITY>

<QTYFULFI>0</QTYFULFI>

<TOTALQTY>1.00000</TOTALQTY>

<ITEMNMBR>08596</ITEMNMBR>

<LNITMSEQ>32768</LNITMSEQ>

<UpdateIfExists>1</UpdateIfExists>

<AUTOALLOCATELOT>0</AUTOALLOCATELOT>

<USRDEFND5>TC_Lot</USRDEFND5>

</taSopLineIvcInsert>

<taSopLineIvcInsert>

<SOPTYPE>2</SOPTYPE>

<DOCID>STDORD         </DOCID>

<SOPNUMBE>ORD0003997</SOPNUMBE>

<CUSTNMBR>19004          </CUSTNMBR>

<DOCDATE>03/19/2015</DOCDATE>

<QUANTITY>0</QUANTITY>

<QTYFULFI>0</QTYFULFI>

<TOTALQTY>2.00000</TOTALQTY>

<ITEMNMBR>00303</ITEMNMBR>

<LNITMSEQ>16384</LNITMSEQ>

<UpdateIfExists>1</UpdateIfExists>

<AUTOALLOCATELOT>0</AUTOALLOCATELOT>

<USRDEFND5>TC_Lot</USRDEFND5>

</taSopLineIvcInsert>

</taSopLineIvcInsert_Items>

<taSopHdrIvcInsert>

<SOPNUMBE>ORD0003997</SOPNUMBE>

<BACHNUMB>TEST</BACHNUMB>

<DOCDATE>03/19/2015</DOCDATE>

<DOCID>STDORD         </DOCID>

<SOPTYPE>2</SOPTYPE>

<UpdateExisting>1</UpdateExisting>

<CUSTNMBR>19004          </CUSTNMBR>

<USRDEFND5>TC_Lot</USRDEFND5>

</taSopHdrIvcInsert>

</SOPTransactionType>

</eConnect>

Reply
Suggested Answer
Shan M responded on 26 Mar 2015 4:38 AM

Hi Denny,

What field are you trying to update in the existing Sales Order using the above XML Note? Are you trying to update the Sales Order Quantity ?

Why the <QUANTITY>0</QUANTITY> is Zero for both the Items and <TOTALQTY>XXXXX</TOTALQTY> node you are passing the values for both the items? Instead of passing the <TOTALQTY> try passing it to <QUANTITY>.

Hope it helps.

**To save someone's time, if this answers your question, mark it as 'Answered' so others experiencing the same will know the answer.

Thanks,

Shan

Reply
Richard Wheeler responded on 26 Mar 2015 6:36 AM

I think what is happening is eConnect is confused because your TOTALQTY field has a value but the other quantities are zero. I would try setting QUANTITY, ATYALLOC and QTYFULFI all to the same value as TOTALQTY.

Richard E. Wheeler 2013 and 2014 MVP

Member Microsoft Academic Alliance

www.rbsolutions.com Revered Business Solutions Ballston Lake, NY  518-877-0763 x10

Reply
Denny999 responded on 27 Mar 2015 2:32 AM

because node<QUANTITY> refer to Qty to Invoice in the sales order.

here we need to clear the Qty to Invoice and Qty fulfilled for the sales order,

so we set <QUANTITY> to 0.  from the error message, is it possible this sales order is link to the quotes?

thanks.

Reply
Suggested Answer
Shan M responded on 27 Mar 2015 5:20 AM

It says based on the type of SOP Type transaction that you are going to create.

e.g If you say you are creating order, then it means what is the quantity that is going to be Invoiced.It applies the Quantity to Invoice field with the ordered quantity.

Why do you need to clear the Qty to Invoice and Qty fulfilled for the sales order? If you could share the screenshot of your original sales oder and requirement in what you are updating with that sales order will help us to understand and provide a solution.

In order, to clear the Qty to Invoice and Qty fulfilled for the sales order. You need to provied the value to the <QUANTITY> field and Qty to Invoice and Qty fulfilled as zero.

I suggest you to try the scenario with your test company to get a better understanding of how the system behaves.

You can check whether the sales order is linked to Quote by clicking the Document No expansion button on the Sales Trx Entry by selecting the sales order.

QUANTITY:

Quote=Quantity to order;

Order and Bkorder=Quantity to invoice;

Invoice=Billed quantity;

Return=Total quantity

Hope it helps.

**To save someone's time, if this answers your question, mark it as 'Answered' so others experiencing the same will know the answer.

Thanks,

Shan

Reply
Verified Answer
Shan M responded on 25 Mar 2015 6:04 AM

Hi Denny,

It seems that particular Sales Order is linked with the Purchase order and its quantity were committed. As suggested by Mahmoud, it is better to check the Sales Order in GP and whether it is linked with the Purchase order.  Are you really trying to change the quantity with the update using econnect?  If the answer is no, then check the econnect parameters.

If the answer is yes. The answer for this is already provided in the  above post.

What is the purpose of updating the quantity?

Econnect nodes for linking and unlinking:

You can use the <taSopToPopLink> XML node to create new purchase orders with the link of the Sales Order.

In order to remove the link between the Purchase Order and the Sales Order use this node<taPopRemoveSopLink>

Hope it helps.

**To save someone's time, if this answers your question, mark it as 'Answered' so others experiencing the same will know the answer.

Thanks,

Shan

Reply
Verified Answer
Richard Wheeler responded on 25 Mar 2015 6:41 AM

Since you say you are using eConnect to update already existing sales orders if you go into GP and pull up one of these sales orders do you see a paper clip on each line? The paper clip means there is a SOP to POP commitment in place so quantities cannot be changed without the commitment being broken.  The SOP10200.QTYONPO will hold the value of the quantity on the PO and you will find the SOP-POP link table SOP60100 will contain the link to the PO.

Richard E. Wheeler 2013 and 2014 MVP

Member Microsoft Academic Alliance

www.rbsolutions.com Revered Business Solutions Ballston Lake, NY  518-877-0763 x10

Reply
Suggested Answer
Shan M responded on 26 Mar 2015 4:38 AM

Hi Denny,

What field are you trying to update in the existing Sales Order using the above XML Note? Are you trying to update the Sales Order Quantity ?

Why the <QUANTITY>0</QUANTITY> is Zero for both the Items and <TOTALQTY>XXXXX</TOTALQTY> node you are passing the values for both the items? Instead of passing the <TOTALQTY> try passing it to <QUANTITY>.

Hope it helps.

**To save someone's time, if this answers your question, mark it as 'Answered' so others experiencing the same will know the answer.

Thanks,

Shan

Reply
Suggested Answer
Shan M responded on 27 Mar 2015 5:20 AM

It says based on the type of SOP Type transaction that you are going to create.

e.g If you say you are creating order, then it means what is the quantity that is going to be Invoiced.It applies the Quantity to Invoice field with the ordered quantity.

Why do you need to clear the Qty to Invoice and Qty fulfilled for the sales order? If you could share the screenshot of your original sales oder and requirement in what you are updating with that sales order will help us to understand and provide a solution.

In order, to clear the Qty to Invoice and Qty fulfilled for the sales order. You need to provied the value to the <QUANTITY> field and Qty to Invoice and Qty fulfilled as zero.

I suggest you to try the scenario with your test company to get a better understanding of how the system behaves.

You can check whether the sales order is linked to Quote by clicking the Document No expansion button on the Sales Trx Entry by selecting the sales order.

QUANTITY:

Quote=Quantity to order;

Order and Bkorder=Quantity to invoice;

Invoice=Billed quantity;

Return=Total quantity

Hope it helps.

**To save someone's time, if this answers your question, mark it as 'Answered' so others experiencing the same will know the answer.

Thanks,

Shan

Reply