Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / SOP to POP Link in Mic...
Microsoft Dynamics GP (Archived)

SOP to POP Link in Microsoft Dynamics GP?

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

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.

*This post is locked for comments

  • Tony C- Profile Picture
    Tony C- 5 on at
    RE: SOP to POP Link in Microsoft Dynamics GP?

    I'm piggybacking this thread as I'm experiencing similar error with taSopLineIvcInsert but in a way I wanted to know if there's any way to update other information about the line, in this case, specific to addresses on the Order Line level using eConnect when the line is committed to a PO?

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: SOP to POP Link in Microsoft Dynamics GP?

    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

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: SOP to POP Link in Microsoft Dynamics GP?

    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.

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: SOP to POP Link in Microsoft Dynamics GP?

    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.

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: SOP to POP Link in Microsoft Dynamics GP?

    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>.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: SOP to POP Link in Microsoft Dynamics GP?

    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>

  • Verified answer
    Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: SOP to POP Link in Microsoft Dynamics GP?

    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.

  • Verified answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: SOP to POP Link in Microsoft Dynamics GP?

    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>

  • Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at
    RE: SOP to POP Link in Microsoft Dynamics GP?

    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,  

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans