Search the GP Tables
Search by TABLE NAME
Search by FIELD NAME
These are our SOP scripts. All of our scripts for Dynamics GP can be found here
DynDeveloper.com

DynDeveloper.com

Table Edits Forum Articles
Table Edits 0 Table Edits 0 Table Edits 0
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








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