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?
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,
Mahmoud M. AlSaadi
Dynamics GP Essentials | mahmoudsaadi.blogspot.com
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.
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
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">
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>.
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.
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?
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.
Quote=Quantity to order;
Order and Bkorder=Quantity to invoice;