web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / eConnect PO with Non I...
Microsoft Dynamics GP (Archived)

eConnect PO with Non Inventoried Items

(0) ShareShare
ReportReport
Posted on by devinmcm1 582

I am trying to finish a very simple integration regarding POs on GP 2015.  We keep trying to send in POP PO XML that will contain ALL non-inventoried items.  The PO is a message only from another system.  Inventory is not involved at all

We try to send a line in with Qty = 1 and Price = 1 Subtotal = 1

The PO XML looks absolutely correct

Each time we try to send the PO in, we are met with an eConnect error:

Error Number = 370 Stored Procedure= taPoHdr Error Description = Subtotal (SUBTOTAL) does not match the line item totals

Node Identifier Parameters: taPoHdr

POTYPE = 1

PONUMBER = E000019

VENDORID = MOTIO

Related Error Code Parameters for Node : taPoHdr

SUBTOTAL = 1.00

This seems completely odd to me given the simplicity of the calculations.  Can someone please help me understand why this is happening?

  A serialized XML is also included:

<eConnect xmlns:dt="urn:schemas-microsoft-com:datatypes"><POPTransactionType><eConnectProcessInfo><ConnectionString>data source=sql123;initial catalog=ESC;integrated security=SSPI;persist security info=False;packet size=4096;Connect Timeout=10</ConnectionString></eConnectProcessInfo>  <taPoHdr>
   <PONUMBER>E000019</PONUMBER>
   <POSTATUS>1</POSTATUS>
   <STATGRP>1</STATGRP>
   <POTYPE>1</POTYPE>
   <USER2ENT>-</USER2ENT>
   <CONFIRM1/>
   <DOCDATE>2018-07-27T00:00:00</DOCDATE>
   <PRMDATE>2018-07-27T00:00:00</PRMDATE>
   <PRMSHPDTE>2018-07-27T00:00:00</PRMSHPDTE>
   <REQDATE>2018-07-27T00:00:00</REQDATE>
   <REQTNDT>2018-07-20T00:00:00</REQTNDT>
   <TXRGNNUM/>
   <SUBTOTAL>1.00</SUBTOTAL>
   <TRDISAMT>0</TRDISAMT>
   <FRTAMNT>0.00</FRTAMNT>
   <MSCCHAMT>0.00</MSCCHAMT>
   <TAXAMNT>0.00</TAXAMNT>
   <VENDORID>MOTIO</VENDORID>
   <VENDNAME>MOTION INDUSTRIES</VENDNAME>
   <MINORDER>0.00</MINORDER>
   <CMPANYID>1</CMPANYID>
   <CMPNYNAM>ELLIOTT SAWMILLING CO. INC</CMPNYNAM>
   <CONTACT>-</CONTACT>
   <ADDRESS1>P.O. BOX 638</ADDRESS1>
   <CITY>ESTILL</CITY>
   <STATE>SC</STATE>
   <COUNTRY>USA</COUNTRY>
   <PHONE1>803.625.1947</PHONE1>
   <PHONE2/>
   <PHONE3/>
   <BUYERID/>
   <HOLD>0</HOLD>
   <ALLOWSOCMTS>0</ALLOWSOCMTS>
   <taPoLine_Items>
    <taPoLine>
     <LPONUMBER>E000019</LPONUMBER>
     <LORD>1</LORD>
     <LPOLNESTA>1</LPOLNESTA>
     <LPOTYPE>1</LPOTYPE>
     <LITEMNMBR>ACC0004</LITEMNMBR>
     <LITEMDESC>47000-100-S1400</LITEMDESC>
     <LVENDORID>MOTIO</LVENDORID>
     <LVNDITNUM>BK 30-10N</LVNDITNUM>
     <LVNDITDSC>ACCUM, KIT, BLADDER, 5GAL, 3000PSI</LVNDITDSC>
     <LNONINVEN>1</LNONINVEN>
     <LLOCNCODE>STOREROOM</LLOCNCODE>
     <LUOFM>TEST</LUOFM>
     <LQTYORDER>1</LQTYORDER>
     <LQTYCANCE>0</LQTYCANCE>
     <LUNITCOST>1.00</LUNITCOST>
     <LREQDATE>2018-07-20T00:00:00</LREQDATE>
     <LPRMDATE>2018-07-20T00:00:00</LPRMDATE>
     <LPRMSHPDTE>2018-07-20T00:00:00</LPRMSHPDTE>
     <LREQSTDBY>SUPERUSER</LREQSTDBY>
     <LCOMMNTID/>
     <LFREEONBOARD>1</LFREEONBOARD>
     <LBSIVCTTL>0</LBSIVCTTL>
     <LBCKTXAMT>0</LBCKTXAMT>
     <LBackoutTradeDiscTax>0</LBackoutTradeDiscTax>
    </taPoLine>
   </taPoLine_Items>
  </taPoHdr>

</POPTransactionType></eConnect>

*This post is locked for comments

I have the same question (0)
  • sandipdjadhav Profile Picture
    sandipdjadhav 18,306 on at

    Hello,

    You need to pass  =1 for Non-Inventory Item.

    NONINVEN

    i4

    2

    N

    0

    0=Inventory item;

    1=Non-inventory item

    Let me know how it goes.

    Thanks much

    Sandip

  • devinmcm1 Profile Picture
    devinmcm1 582 on at

    Yes it is there.  I have done some digging on the XML that we were using and found a lot of little problems, however after correcting we are still getting the error.  Please see updated serialized XML and not that the NONINVEN tag is there.  Please ALSO note that If I set SUBTOTAL = 0 in POHdr, this goes in successfully with 0 Purchase Qty and 0 Unit Price

    <POPTransactionType>

    <taPoLine_Items>

    <taPoLine>

    <PONUMBER>E777777</PONUMBER>

    <POLNESTA>1</POLNESTA>

    <POTYPE>1</POTYPE>

    <ITEMNMBR>ACC0004</ITEMNMBR>

    <ITEMDESC>47000-100-S1400</ITEMDESC>

    <VENDORID>MOTIO</VENDORID>

    <VNDITNUM>BK 30-10N</VNDITNUM>

    <VNDITDSC>ACCUM, KIT, BLADDER, 5GAL, 3000PSI</VNDITDSC>

    <NONINVEN>1</NONINVEN>

    <LOCNCODE>100</LOCNCODE>

    <UOFM>EACH</UOFM>

    <QTYORDER>1.0000</QTYORDER>

    <QTYCANCE>0</QTYCANCE>

    <UNITCOST>1.00</UNITCOST>

    <REQDATE>2018-07-20T00:00:00</REQDATE>

    <PRMDATE>2018-07-20T00:00:00</PRMDATE>

    <PRMSHPDTE>2018-07-20T00:00:00</PRMSHPDTE>

    <REQSTDBY>SUPERUSER</REQSTDBY>

    <COMMNTID/>

    <FREEONBOARD>1</FREEONBOARD>

    <BSIVCTTL>0</BSIVCTTL>

    <BCKTXAMT>0</BCKTXAMT>

    <BackoutTradeDiscTax>0</BackoutTradeDiscTax>

    </taPoLine>

    </taPoLine_Items>

    <taPoHdr>

    <PONUMBER>E777777</PONUMBER>

    <POSTATUS>1</POSTATUS>

    <STATGRP>1</STATGRP>

    <POTYPE>1</POTYPE>

    <USER2ENT>-</USER2ENT>

    <CONFIRM1/>

    <DOCDATE>2018-07-27T00:00:00</DOCDATE>

    <PRMDATE>2018-07-27T00:00:00</PRMDATE>

    <PRMSHPDTE>2018-07-27T00:00:00</PRMSHPDTE>

    <REQDATE>2018-07-27T00:00:00</REQDATE>

    <REQTNDT>2018-07-20T00:00:00</REQTNDT>

    <TXRGNNUM/>

    <SUBTOTAL>1.00</SUBTOTAL>

    <TRDISAMT>0</TRDISAMT>

    <FRTAMNT>0.00</FRTAMNT>

    <MSCCHAMT>0.00</MSCCHAMT>

    <TAXAMNT>0.00</TAXAMNT>

    <VENDORID>MOTIO</VENDORID>

    <VENDNAME>MOTION INDUSTRIES</VENDNAME>

    <MINORDER>0.00</MINORDER>

    <CMPANYID>1</CMPANYID>

    <CMPNYNAM>TEST CMPNY</CMPNYNAM>

    <CONTACT>-</CONTACT>

    <ADDRESS1>P.O. BOX 638</ADDRESS1>

    <CITY>ESTILL</CITY>

    <STATE>SC</STATE>

    <COUNTRY>USA</COUNTRY>

    <PHONE1>803.625.1947</PHONE1>

    <PHONE2/>

    <PHONE3/>

    <BUYERID/>

    <HOLD>0</HOLD>

    <ALLOWSOCMTS>0</ALLOWSOCMTS>

    </taPoHdr>

    </POPTransactionType>

  • sandipdjadhav Profile Picture
    sandipdjadhav 18,306 on at

    you need to pass specified for SubTotal = True on header and   objtaPoLine_ItemsTaPoLine[i].UNITCOSTSpecified = true; for line?.  

  • devinmcm1 Profile Picture
    devinmcm1 582 on at

    I don't see how to pass Subtotal = TRUE in POHdr in XML Schema... only how to pass the actual Subtotal

  • Suggested answer
    sandipdjadhav Profile Picture
    sandipdjadhav 18,306 on at

    Hello,

    Thats problem in XML Schema you won't see "Specifed".    On header and line level you need to make sure all required paramter specified.  Below is code for header-

    objtaPoHdr.SUBTOTALSpecified = true;

    Line.

    objtaPoLine_ItemsTaPoLine[i].UNITCOSTSpecified = true;

    Thanks much

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans