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>