Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / eConnect error makes n...
Microsoft Dynamics GP (Archived)

eConnect error makes no sense

(0) ShareShare
ReportReport
Posted on by Bill Campbell 22,647

So we are getting an error with our developing partner when they are trying to pass an update to a Purchase Order.

***

We are able to Create a Purchase Order, modifiy a purchase order, Update a Purchase Order and Cancel a Purchase Order.

These tasks all work as expected and without errors until such time as any line on the PO attains the status of CLOSED.

Qty Ordered = Qty Received = Qty Invoiced - as we know makes that line CLOSED but the rest of the PO may remain open.

After this, if we attempt to run any one of the updates or modify statements thru eConnect we generate an error that "Can't update a closed line" even though that is not the line is being updated by the eConnect statement.

If they attempt to leave that line item off the eConnect statement they get an unbalanced transaction and of course this fails as well.

****

Can someone enlighten me and tell me if this is expected behavior or if there is something that they are missing in the eConnect process?

*This post is locked for comments

  • Galina Profile Picture
    Galina 1,075 on at
    RE: eConnect error makes no sense

    So, he IS referencing closed lines.

    I'm really confused by this xml, what are they trying to do, change tax on the closed line?

  • Bill Campbell Profile Picture
    Bill Campbell 22,647 on at
    RE: eConnect error makes no sense

    Sorry for the delay in getting back to you but here is a copy of the code that my developer sent to me - he tells me that

    <?xml version="1.0"?>

    <eConnect xmlns:xsd="www.w3.org/.../XMLSchema&quot; xmlns:xsi="www.w3.org/.../XMLSchema-instance&quot;>

       <POPTransactionType>

           <eConnectProcessInfo xsi:nil="true" />

           <taRequesterTrxDisabler_Items xsi:nil="true" />

           <taUpdateCreateItemRcd xsi:nil="true" />

           <taUpdateCreateVendorRcd xsi:nil="true" />

           <taCreateVendorAddress_Items xsi:nil="true" />

           <taUpdateCreateCustomerRcd xsi:nil="true" />

           <taCreateCustomerAddress_Items xsi:nil="true" />

           <taPopIvcTaxInsert_Items>

               <taPopIvcTaxInsert>

                   <PONUMBER>0000101</PONUMBER>

                   <ORD>1</ORD>

                   <TAXDTLID>CANGST-P5</TAXDTLID>

                   <TAXAMNT>181.61</TAXAMNT>

                   <TAXPURCH>7832.1600000000</TAXPURCH>

                   <TOTPURCH>7832.1600000000</TOTPURCH>

                   <VENDORID>WIPAL0001</VENDORID>

               </taPopIvcTaxInsert>

               <taPopIvcTaxInsert>

                   <PONUMBER>0000101</PONUMBER>

                   <ORD>2</ORD>

                   <TAXDTLID>CANGST-P5</TAXDTLID>

                   <TAXAMNT>126.72000</TAXAMNT>

                   <TAXPURCH>2534.4000000000</TAXPURCH>

                   <TOTPURCH>2534.4000000000</TOTPURCH>

                   <VENDORID>WIPAL0001</VENDORID>

               </taPopIvcTaxInsert>

               <taPopIvcTaxInsert>

                   <PONUMBER>0000101</PONUMBER>

                   <ORD>3</ORD>

                   <TAXDTLID>CANGST-P5</TAXDTLID>

                   <TAXAMNT>215.28000</TAXAMNT>

                   <TAXPURCH>4305.6000000000</TAXPURCH>

                   <TOTPURCH>4305.6000000000</TOTPURCH>

                   <VENDORID>WIPAL0001</VENDORID>

               </taPopIvcTaxInsert>

           </taPopIvcTaxInsert_Items>

           <taPopDistribution_Items xsi:nil="true" />

           <taAnalyticsDistribution_Items xsi:nil="true" />

           <taPoLine_Items>

               <taPoLine>

                   <PONUMBER>0000101</PONUMBER>

                   <VENDORID>WIPAL0001</VENDORID>

                   <LOCNCODE>WAREHOUSE</LOCNCODE>

                   <VNDITNUM>ABPFC15ZZZZ</VNDITNUM>

                   <ITEMNMBR>*1082</ITEMNMBR>

                   <QUANTITY>18648.00000</QUANTITY>

                   <QTYCANCE>10000</QTYCANCE>

                   <REQDATE>2016-01-13</REQDATE>

                   <RELEASEBYDATE>2016-01-13</RELEASEBYDATE>

                   <PRMDATE>2016-01-13</PRMDATE>

                   <PRMSHPDTE>2016-01-13</PRMSHPDTE>

                   <ITEMDESC>ABS</ITEMDESC>

                   <UNITCOST>0.42000</UNITCOST>

                   <UOFM>Foot</UOFM>

                   <Purchase_IV_Item_Taxable>1</Purchase_IV_Item_Taxable>

                   <Purchase_Item_Tax_Schedu>SCANGST-P5</Purchase_Item_Tax_Schedu>

                   <Purchase_Site_Tax_Schedu>SCANGST-P5</Purchase_Site_Tax_Schedu>

                   <TAXAMNT>181.61</TAXAMNT>

                   <BCKTXAMT>0</BCKTXAMT>

                   <POLNESTA>3</POLNESTA>

                   <ORD>1</ORD>

                   <UpdateIfExists>1</UpdateIfExists>

               </taPoLine>

               <taPoLine>

                   <PONUMBER>0000101</PONUMBER>

                   <VENDORID>WIPAL0001</VENDORID>

                   <LOCNCODE>WAREHOUSE</LOCNCODE>

                   <VNDITNUM>ABPFC20ZZZZ</VNDITNUM>

                   <ITEMNMBR>*1083</ITEMNMBR>

                   <QUANTITY>4224.00000</QUANTITY>

                   <QTYCANCE>0</QTYCANCE>

                   <REQDATE>2016-01-13</REQDATE>

                   <RELEASEBYDATE>2016-01-13</RELEASEBYDATE>

                   <PRMDATE>2016-01-13</PRMDATE>

                   <PRMSHPDTE>2016-01-13</PRMSHPDTE>

                   <ITEMDESC>ABS</ITEMDESC>

                   <UNITCOST>0.60000</UNITCOST>

                   <UOFM>Foot</UOFM>

                   <Purchase_IV_Item_Taxable>1</Purchase_IV_Item_Taxable>

                   <Purchase_Item_Tax_Schedu>SCANGST-P5</Purchase_Item_Tax_Schedu>

                   <Purchase_Site_Tax_Schedu>SCANGST-P5</Purchase_Site_Tax_Schedu>

                   <TAXAMNT>126.72000</TAXAMNT>

                   <BCKTXAMT>0</BCKTXAMT>

                   <POLNESTA>5</POLNESTA>

                   <ORD>2</ORD>

                   <UpdateIfExists>1</UpdateIfExists>

               </taPoLine>

               <taPoLine>

                   <PONUMBER>0000101</PONUMBER>

                   <VENDORID>WIPAL0001</VENDORID>

                   <LOCNCODE>WAREHOUSE</LOCNCODE>

                   <VNDITNUM>ABPIC30ZZZZ</VNDITNUM>

                   <ITEMNMBR>*1084</ITEMNMBR>

                   <QUANTITY>3744.00000</QUANTITY>

                   <QTYCANCE>0</QTYCANCE>

                   <REQDATE>2016-01-13</REQDATE>

                   <RELEASEBYDATE>2016-01-13</RELEASEBYDATE>

                   <PRMDATE>2016-01-13</PRMDATE>

                   <PRMSHPDTE>2016-01-13</PRMSHPDTE>

                   <ITEMDESC>ABS</ITEMDESC>

                   <UNITCOST>1.15000</UNITCOST>

                   <UOFM>Foot</UOFM>

                   <Purchase_IV_Item_Taxable>1</Purchase_IV_Item_Taxable>

                   <Purchase_Item_Tax_Schedu>SCANGST-P5</Purchase_Item_Tax_Schedu>

                   <Purchase_Site_Tax_Schedu>SCANGST-P5</Purchase_Site_Tax_Schedu>

                   <TAXAMNT>215.28000</TAXAMNT>

                   <BCKTXAMT>0</BCKTXAMT>

                   <POLNESTA>5</POLNESTA>

                   <ORD>3</ORD>

                   <UpdateIfExists>1</UpdateIfExists>

               </taPoLine>

           </taPoLine_Items>

           <taPoHdr>

               <POTYPE>1</POTYPE>

               <PONUMBER>0000101</PONUMBER>

               <VENDORID>WIPAL0001</VENDORID>

               <VENDNAME>WIPAL</VENDNAME>

               <DOCDATE>2016-01-13</DOCDATE>

               <ALLOWSOCMTS>1</ALLOWSOCMTS>

               <TRDISAMT>0</TRDISAMT>

               <FRTAMNT>0</FRTAMNT>

               <MSCCHAMT>0</MSCCHAMT>

               <TAXAMNT>523.61</TAXAMNT>

               <SUBTOTAL>10472.16</SUBTOTAL>

               <PRSTADCD>PRIMARY        </PRSTADCD>

               <ADDRESS1>3185 - 114 Avenue SE</ADDRESS1>

               <CITY>Calgary</CITY>

               <STATE>AB</STATE>

               <ZIPCODE>T2Z 3X2</ZIPCODE>

               <COUNTRY>Canada</COUNTRY>

               <PHONE1>40325815050000</PHONE1>

               <PHONE2>87725815050000</PHONE2>

               <FAX>40325805260000</FAX>

               <VADCDPAD>PRIMARY</VADCDPAD>

               <DSCPCTAM>0</DSCPCTAM>

               <DSCDLRAM>0</DSCDLRAM>

               <DUEDATE>1900-01-01</DUEDATE>

               <DISCDATE>1900-01-01</DISCDATE>

               <TAXSCHID>SCANGST-P5</TAXSCHID>

               <Purchase_Freight_Taxable>1</Purchase_Freight_Taxable>

               <Purchase_Misc_Taxable>1</Purchase_Misc_Taxable>

               <FRTSCHID>SCANGST-P5</FRTSCHID>

               <MSCSCHID>SCANGST-P5</MSCSCHID>

               <FRTTXAMT>0</FRTTXAMT>

               <MSCTXAMT>0</MSCTXAMT>

               <BCKTXAMT>0</BCKTXAMT>

               <BackoutFreightTaxAmt>0</BackoutFreightTaxAmt>

               <BackoutMiscTaxAmt>0</BackoutMiscTaxAmt>

               <BackoutTradeDiscTax>0</BackoutTradeDiscTax>

               <CURNCYID>Z-C$</CURNCYID>

               <EXCHDATE>1900-01-01</EXCHDATE>

               <POSTATUS>2</POSTATUS>

               <PRMDATE>2016-01-13</PRMDATE>

               <PRMSHPDTE>2016-01-13</PRMSHPDTE>

               <REQDATE>2016-01-13</REQDATE>

               <CONTENDDTE>1900-01-01</CONTENDDTE>

               <REQTNDT>1900-01-01</REQTNDT>

               <UpdateIfExists>1</UpdateIfExists>

           </taPoHdr>

       </POPTransactionType>

    </eConnect>

  • Galina Profile Picture
    Galina 1,075 on at
    RE: eConnect error makes no sense

    Hi, Bill,

    You definitely can make changes to PO with closed lines through eConnect.

    Here is the example that worked for such order for us. One of the lines on the order was closed. The example changes the quantity and the unit cost for one of the remaining open lines:

    <eConnect>

    <POPTransactionType>

    <taPoLine_Items>

    <taPoLine>

    <PONUMBER>PO2079</PONUMBER>

    <VENDORID>INTERNET</VENDORID>

    <ITEMNMBR>305224</ITEMNMBR>

    <LOCNCODE>SITE</LOCNCODE>

    <ADRSCODE>SITE</ADRSCODE>

    <NONINVEN>0</NONINVEN>

    <QUANTITY>220</QUANTITY>

    <UNITCOST>9.90</UNITCOST>

    <ORD>32768</ORD>

    <UpdateIfExists>1</UpdateIfExists>

    </taPoLine>

    </taPoLine_Items>

    <taPoHdr>

    <PONUMBER>PO2079</PONUMBER>

    <VENDORID>INTERNET</VENDORID>

    <UpdateIfExists>1</UpdateIfExists>

    </taPoHdr>

    </POPTransactionType>

    </eConnect>

  • Bill Campbell Profile Picture
    Bill Campbell 22,647 on at
    RE: eConnect error makes no sense

    Thanks Heather - I know this is a bit of a weird one.

  • Bill Campbell Profile Picture
    Bill Campbell 22,647 on at
    RE: eConnect error makes no sense

    Praveen, I will suggest to the developer the addition of the LineSeqNum and see what assistance this might provide.

  • Praveen Kumar RR Profile Picture
    Praveen Kumar RR 1,550 on at
    RE: eConnect error makes no sense

    Bill,

    Is it possible for you to try updating the same PO with same values manually?

    If it is not helping, then i suggest to add an additional parameter in eConnect SQL Statement that is including LineSeqNum which will differentiate between each line items.

    Sorry, if my point is not helping you.

    Thanks,

    Praveen

  • Heather Roggeveen Profile Picture
    Heather Roggeveen 9,142 on at
    RE: eConnect error makes no sense

    Can't help with this one Bill, but interested in the responses.

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