euta226 2/17/2017 10:08:43 AM

PopTransactionType eConnect error - Tax detail amount does not match the header tax amount

We recently started trying to include item-level tax details on our purchase orders but we are receiving the  Error Number = 887 Stored Procedure= taPoHdr Error Description = Tax detail amount does not match the header tax amount. 

The change we made was adding the taPopIvcTaxInsert object along with the taPoHdr and taPoLine objects in the POPTransactionType.  We are also specifying the taPoHdr.TAXAMNT in our code but that doesn't appear in the XML that gets generated (see below) and passed to CreateEntity().  Is there a "TAXAMNTSpecified = true" property that I could be missing?  What else can we be doing to get the TAXAMNT to appear in the taPoHdr block on the XML (if that's even the problem)?

Thank you,

James

POPTransactionType XML:

<?xml version="1.0"?>
    <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>PO1700102</PONUMBER>
                <ORD>16384</ORD>
                <TAXDTLID>VATTAXAP-COM </TAXDTLID>
                <TAXAMNT>11.04</TAXAMNT>
                <TAXPURCH>55.2</TAXPURCH>
                <TOTPURCH>55.2</TOTPURCH>
                <VENDORID>ELA001-COM </VENDORID>
            </taPopIvcTaxInsert>
        </taPopIvcTaxInsert_Items>
        <taPopDistribution_Items xsi:nil="true"/>
        <taAnalyticsDistribution_Items xsi:nil="true"/>
        <taPoLine_Items>
            <taPoLine>
                <POTYPE>1</POTYPE>
                <PONUMBER>PO1700102</PONUMBER>
                <VENDORID>ELA001-COM </VENDORID>
                <LOCNCODE>COMM </LOCNCODE>
                <VNDITNUM>10011 </VNDITNUM>
                <ITEMNMBR>10011 </ITEMNMBR>
                <QUANTITY>1</QUANTITY>
                <QTYCANCE>0</QTYCANCE>
                <FREEONBOARD>3</FREEONBOARD>
                <REQDATE>02/23/2017 00:00:00.000</REQDATE>
                <RELEASEBYDATE>01/01/1900 00:00:00.000</RELEASEBYDATE>
                <PRMDATE>02/23/2017 00:00:00.000</PRMDATE>
                <PRMSHPDTE>01/01/1900 00:00:00.000</PRMSHPDTE>
                <ITEMDESC>16mm Tri-rated Grey</ITEMDESC>
                <UNITCOST>55.2000</UNITCOST>
                <VNDITDSC>16mm Tri-rated Grey </VNDITDSC>
                <UOFM>EA</UOFM>
                <Purchase_IV_Item_Taxable>1</Purchase_IV_Item_Taxable>
                <Purchase_Item_Tax_Schedu>ALL </Purchase_Item_Tax_Schedu>
                <Purchase_Site_Tax_Schedu>VATAP-COM </Purchase_Site_Tax_Schedu>
                <BSIVCTTL>0</BSIVCTTL>
                <TAXAMNT>11.04</TAXAMNT>
                <BCKTXAMT>0</BCKTXAMT>
                <PLNNDSPPLID>0</PLNNDSPPLID>
                <BackoutTradeDiscTax>0</BackoutTradeDiscTax>
                <POLNESTA>2</POLNESTA>
                <ORD>16384</ORD>
                <LineNumber>1</LineNumber>
                <UpdateIfExists>1</UpdateIfExists>
            </taPoLine>
        </taPoLine_Items>
        <taPoHdr>
            <PONUMBER>PO1700102</PONUMBER>
            <VENDORID>ELA001-COM </VENDORID>
            <VENDNAME>ELAND CABLES LTD </VENDNAME>
            <DOCDATE>02/17/2017 00:00:00.000</DOCDATE>
            <BUYERID> </BUYERID>
            <PRSTADCD>UKTCC </PRSTADCD>
            <CMPNYNAM>AFL Services Europe Ltd </CMPNYNAM>
            <CONTACT>eur.accounts@aflgloal.com </CONTACT>
            <ADDRESS1>3 The Western Centre </ADDRESS1>
            <ADDRESS2>Western Road </ADDRESS2>
            <ADDRESS3> </ADDRESS3>
            <CITY>Bracknell </CITY>
            <STATE>Berkshire </STATE>
            <ZIPCODE>RG12 1RW </ZIPCODE>
            <COUNTRY>ALAF160001</COUNTRY>
            <PHONE1>13444078000000 </PHONE1>
            <PHONE2>00000000000000 </PHONE2>
            <PHONE3> </PHONE3>
            <FAX>13444078010000 </FAX>
            <VADCDPAD>REMIT TO </VADCDPAD>
            <PURCHCMPNYNAM>ELAND CABLES LTD </PURCHCMPNYNAM>
            <PURCHCONTACT> </PURCHCONTACT>
            <PURCHADDRESS1>120 HIGHGATE STUDIOS </PURCHADDRESS1>
            <PURCHADDRESS2>53-79 HIGHGATE RD </PURCHADDRESS2>
            <PURCHADDRESS3> </PURCHADDRESS3>
            <PURCHCITY>LONDON </PURCHCITY>
            <PURCHSTATE> </PURCHSTATE>
            <PURCHZIPCODE>NW5 1TL </PURCHZIPCODE>
            <PURCHCOUNTRY>United Kingdom </PURCHCOUNTRY>
            <PURCHPHONE1>02072418787 </PURCHPHONE1>
            <PURCHPHONE2> </PURCHPHONE2>
            <PURCHPHONE3> </PURCHPHONE3>
            <PURCHFAX>02072418701 </PURCHFAX>
            <PRBTADCD>UKTCC </PRBTADCD>
            <SHIPMTHD>DELIVERY </SHIPMTHD>
            <PYMTRMID>NET 30 </PYMTRMID>
            <DUEDATE>01/01/1900 00:00:00.000</DUEDATE>
            <DISCDATE>01/01/1900 00:00:00.000</DISCDATE>
            <TXRGNNUM> </TXRGNNUM>
            <XCHGRATE>0</XCHGRATE>
            <EXCHDATE>01/01/1900 00:00:00.000</EXCHDATE>
            <EXTBLSRC>0</EXTBLSRC>
            <TIME1>01/01/1900 00:00:00.000</TIME1>
            <POSTATUS>2</POSTATUS>
            <PRMDATE>02/23/2017 00:00:00.000</PRMDATE>
            <PRMSHPDTE>01/01/1900 00:00:00.000</PRMSHPDTE>
            <REQDATE>02/23/2017 00:00:00.000</REQDATE>
            <CONTENDDTE>01/01/1900 00:00:00.000</CONTENDDTE>
            <REQTNDT>01/01/1900 00:00:00.000</REQTNDT>
            <UpdateIfExists>1</UpdateIfExists>
        </taPoHdr>
    </POPTransactionType>
</eConnect>
Version: GP 2013
Section: .NET Development, Dynamics GP, eConnect


Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables
3