DynDeveloper.com

DynDeveloper.com

Sign Up Now!Log In
kv 12/14/2015 6:08:55 AM

Tax Header not matching with Line Items

 Hi, so I am trying to instert some test records into the receivings Transaction module, but cannot seem to get past the tax.  Now, I think the issue might be what I am using for Tax Schedule and Tax detail, as I've just grabbed a couple of the sample db's items.  I have applied 20% tax to the tax amounts, and don't know whether this has an impact on the tax schedule/details that are used in order to calculate the right amount of tax

 

Error Message:

Microsoft.Dynamics.GP.eConnect.eConnectException: Sql procedure error codes returned:
Error Number = 843  Stored Procedure= taPopRcptHdrInsert  Error Description = Tax detail amount (TAXAMNT + FRTTXAMT + MSCTXAMT) does not match the header taxamount

 

<?xml version="1.0" encoding="UTF-8"?>
<eConnect xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<POPReceivingsType>
<eConnectProcessInfo xsi:nil="true"/>
<taRequesterTrxDisabler_Items xsi:nil="true"/>
<taUpdateCreateItemRcd xsi:nil="true"/>
<taUpdateCreateVendorRcd xsi:nil="true"/>
<taCreateVendorAddress_Items xsi:nil="true"/>
<taPopRcptLotInsert_Items xsi:nil="true"/>
<taPopRcptSerialInsert_Items xsi:nil="true"/>
<taPopRcptLineInsert_Items>
<taPopRcptLineInsert>
<POPTYPE>3</POPTYPE>
<POPRCTNM>R000094</POPRCTNM>
<ITEMNMBR>LANYARDS x 30</ITEMNMBR>
<ITEMDESC>LANYARDS x 30</ITEMDESC>
<VENDORID>LEAFRIVE0001</VENDORID>
<RCPTLNNM>1</RCPTLNNM>
<UOFM>Each</UOFM>
<UNITCOST>43.20</UNITCOST>
<NONINVEN>1</NONINVEN>
<QTYSHPPD>1</QTYSHPPD>
<QTYINVCD>1</QTYINVCD>
<Purchase_Item_Tax_Schedu>AUSSTE-PS20N0</Purchase_Item_Tax_Schedu>
<TAXAMNT>8.64</TAXAMNT>
<LOCNCODE>01-N</LOCNCODE>
<CURNCYID>Z-US$</CURNCYID>
</taPopRcptLineInsert>

<taPopRcptLineInsert>
<POPTYPE>3</POPTYPE>
<POPRCTNM>R000094</POPRCTNM>
<ITEMNMBR>A5 MEET THE TEAM INVITES</ITEMNMBR>
<ITEMDESC>A5 MEET THE TEAM INVITES</ITEMDESC>
<VENDORID>LEAFRIVE0001</VENDORID>
<RCPTLNNM>2</RCPTLNNM>
<UOFM>Each</UOFM>
<UNITCOST>80.00</UNITCOST>
<NONINVEN>1</NONINVEN>
<QTYSHPPD>1</QTYSHPPD>
<QTYINVCD>1</QTYINVCD>
<Purchase_Item_Tax_Schedu>AUSSTE-PS20N0</Purchase_Item_Tax_Schedu>
<TAXAMNT>16.00</TAXAMNT>
<LOCNCODE>01-N</LOCNCODE>
<CURNCYID>Z-US$</CURNCYID>
</taPopRcptLineInsert>
</taPopRcptLineInsert_Items>

<taPopRcptMultiBin_Items xsi:nil="true"/>
<taPopRcptLineTaxInsert_Items xsi:nil="true"/>
<taPopRctUserDefined xsi:nil="true"/>
<taPopDistribution_Items xsi:nil="true"/>
<taAnalyticsDistribution_Items xsi:nil="true"/>
<taPopRcptHdrInsert>
<POPRCTNM>R000094</POPRCTNM>
<POPTYPE>3</POPTYPE>
<VNDDOCNM>8751</VNDDOCNM>
<receiptdate>14/12/2015</receiptdate>
<BACHNUMB>12345</BACHNUMB>
<VENDORID>LEAFRIVE0001</VENDORID>
<VENDNAME>Leaf River Paging Systems</VENDNAME>
<SUBTOTAL>123.20</SUBTOTAL>
<TAXAMNT>24.64</TAXAMNT>
<PYMTRMID>Cash</PYMTRMID>
<TAXSCHID>ALL DETAILS</TAXSCHID>
<CURNCYID>Z-US$</CURNCYID>
<DUEDATE>14/12/2015</DUEDATE>
<DISCDATE>14/12/2015</DISCDATE>
</taPopRcptHdrInsert>

<taMdaUpdate_Items xsi:nil="true"/>
</POPReceivingsType>

</eConnect>

Version: GP 2010
Section: eConnect