140Hi Expects,
We have requirement to create sales invoice with Tax on Header Level. I did some investigation, It seems we need to use <taSopLineIvcTaxInsert>.
But now I always encounter below error :
Sql procedure error codes returned:
Error Number = 799 Stored Procedure= taSopHdrIvcInsert Error Description = Tax table detail does not equal the tax amount
Node Identifier Parameters: taSopHdrIvcInsert
SOPNUMBE = STDINV2281
SOPTYPE = 3
Related Error Code Parameters for Node : taSopHdrIvcInsert
TAXAMNT = 89.6
FRTTXAMT = 0
MSCTXAMT = 0
Below is the xml I used for eConnect, can someone shed me some lights on how to solve this issue? And Do we need to calculate all these amount fields under <taSopHdrIvcInsert>?
For example, <SUBTOTAL>,<DOCAMNT>,<TAXAMNT>,<MSCTXAMT>
<eConnect xmlns:dt="urn:schemas-microsoft-com:datatypes">
<SOPTransactionType>
<taSopLineIvcInsert_Items>
<taSopLineIvcInsert>
<SOPNUMBE>STDINV2281</SOPNUMBE>
<SOPTYPE>3</SOPTYPE>
<CUSTNMBR>ADVANCED0001</CUSTNMBR>
<DOCDATE>2022-10-12</DOCDATE>
<ITEMNMBR>128 SDRAM</ITEMNMBR>
<UNITPRCE>448</UNITPRCE>
<XTNDPRCE>448</XTNDPRCE>
<QUANTITY>1</QUANTITY>
<ITEMDESC>128 meg SDRAM</ITEMDESC>
<DROPSHIP>0</DROPSHIP>
<QtyShrtOpt>2</QtyShrtOpt>
<NONINVEN>0</NONINVEN>
<PRSTADCD>PRIMARY</PRSTADCD>
<CURNCYID>Z-US$</CURNCYID>
</taSopLineIvcInsert>
</taSopLineIvcInsert_Items>
<taSopLineIvcTaxInsert_Items>
<taSopLineIvcTaxInsert>
<CUSTNMBR>ADVANCED0001</CUSTNMBR>
<LNITMSEQ>1</LNITMSEQ>
<SOPNUMBE>STDINV2281</SOPNUMBE>
<SOPTYPE>3</SOPTYPE>
<SALESAMT>448</SALESAMT>
<TDTTXSLS>448</TDTTXSLS>
<STAXAMNT>537</STAXAMNT>
<TAXDTLID>AUSSTE-PS20N0</TAXDTLID>
<TAXTYPE>0</TAXTYPE>
</taSopLineIvcTaxInsert>
</taSopLineIvcTaxInsert_Items>
<taSopHdrIvcInsert>
<SOPNUMBE>STDINV2281</SOPNUMBE>
<SOPTYPE>3</SOPTYPE>
<DOCID>STDINV</DOCID>
<TAXSCHID>ALL DETAILS</TAXSCHID>
<SHIPMTHD>UPS Ground</SHIPMTHD>
<DOCDATE>2022-10-12</DOCDATE>
<CUSTNMBR>ADVANCED0001</CUSTNMBR>
<CSTPONBR>pabeauty|102311</CSTPONBR>
<ShipToName>Advanced Paper Co.</ShipToName>
<ADDRESS1>456 19th Street S.</ADDRESS1>
<CITY>Chicago</CITY>
<STATE>IL</STATE>
<ZIPCODE>60603-911</ZIPCODE>
<COUNTRY>US</COUNTRY>
<BACHNUMB>EDI10/25/2022</BACHNUMB>
<PRSTADCD>PRIMARY</PRSTADCD>
<ORDRDATE>2022-10-12</ORDRDATE>
<CURNCYID>Z-US$</CURNCYID>
<COMMENT_1>Free B3e with this intro</COMMENT_1>
<SUBTOTAL>448</SUBTOTAL>
<DOCAMNT>537.6</DOCAMNT>
<TAXAMNT>89.6</TAXAMNT>
<FRTTXAMT>0</FRTTXAMT>
<MSCTXAMT>0</MSCTXAMT>
<CREATETAXES>0</CREATETAXES>
<DEFTAXSCHDS>1</DEFTAXSCHDS>
<USINGHEADERLEVELTAXES>1</USINGHEADERLEVELTAXES>
</taSopHdrIvcInsert>
<taSopUserDefined>
<SOPNUMBE>STDINV2281</SOPNUMBE>
<SOPTYPE>3</SOPTYPE>
</taSopUserDefined>
<TCEDI>
<StoreNumber>TCEDI</StoreNumber>
<DCCode>TCEDI</DCCode>
<MarkForCode>785</MarkForCode>
<DepartmentNumber>TCEDI</DepartmentNumber>
<User1>TCEDI</User1>
<User2>TCEDI</User2>
</TCEDI>
<taCreateCustomerItems_Items/>
</SOPTransactionType>
</eConnect>
If I need to create tax like below, how to generate the xml for <taSopLineIvcTaxInsert>.
Thanks
