Dynamics Community Forum Thread Details

Getting the following Error when creating Sales Transaction,

Sql procedure error codes returned:

Error Number = 67 Stored Procedure= taSopHdrIvcInsert Error Description = Subtotal does not match the line item totals
Node Identifier Parameters: taSopHdrIvcInsert
SOPNUMBE = 1007647
SOPTYPE = 3
Related Error Code Parameters for Node : taSopHdrIvcInsert
SUBTOTAL = 68.74

<taSopHdrIvcInsert>
<SOPTYPE>3</SOPTYPE>
<DOCID>1007647</DOCID>
<SOPNUMBE>1007647</SOPNUMBE>
<TAXSCHID>ALL DETAILS</TAXSCHID>
<TAXAMNT>10</TAXAMNT>
<DOCDATE>09/03/2020</DOCDATE>
<CUSTNMBR>BEIE</CUSTNMBR>
<SUBTOTAL>68.74</SUBTOTAL>
<BACHNUMB>IASALES25042011124</BACHNUMB>
<USINGHEADERLEVELTAXES>1</USINGHEADERLEVELTAXES>
<CREATECOMM>1</CREATECOMM>
<CURNCYID>Z-US$</CURNCYID>
<INVODATE>09/03/2020</INVODATE>
</taSopHdrIvcInsert>

Here is the XML which is sent..

<?xml version="1.0"?><eConnect xmlns:xsi="">www.w3.org/.../XMLSchema-instance" xmlns:xsd="">www.w3.org/.../XMLSchema">
<SMTransactionBatchType>
<eConnectProcessInfo xsi:nil="true" /><taRequesterTrxDisabler_Items xsi:nil="true" />
<taCreateUpdateBatchHeaderRcd>
<BACHNUMB>IASALES25042011124</BACHNUMB>
<BCHCOMNT>Batch from Integration</BCHCOMNT>
<SERIES>4</SERIES>
<GLPOSTDT>04/25/2020</GLPOSTDT>
<BCHSOURC>Rcvg Trx Entry</BCHSOURC>
<DOCAMT>0</DOCAMT>
<ORIGIN>1</ORIGIN>
<NUMOFTRX>2</NUMOFTRX>
</taCreateUpdateBatchHeaderRcd>
</SMTransactionBatchType>
<SOPTransactionType>
<eConnectProcessInfo xsi:nil="true" />
<taRequesterTrxDisabler_Items xsi:nil="true" />
<taUpdateCreateItemRcd xsi:nil="true" />
<taUpdateCreateCustomerRcd xsi:nil="true" />
<taCreateCustomerAddress_Items xsi:nil="true" />
<taSopSerial_Items xsi:nil="true" />
<taSopLotAuto_Items xsi:nil="true" />
<taSopLineIvcInsert_Items>
<taSopLineIvcInsert>
<SOPTYPE>3</SOPTYPE>
<SOPNUMBE>STDINV2291</SOPNUMBE>
<CUSTNMBR>BEIE</CUSTNMBR>
<DOCDATE>09/03/2020</DOCDATE>
<LOCNCODE>WAREHOUSE</LOCNCODE>
<ITEMNMBR>TRANS-0235</ITEMNMBR>
<UNITPRCE>34.37</UNITPRCE>
<XTNDPRCE>68.74</XTNDPRCE>
<QUANTITY>2</QUANTITY>
<IVITMTXB>3</IVITMTXB>
<INVINDX>000-4110-02</INVINDX>
<CURNCYID>Z-US$</CURNCYID>
<UOFM>Each</UOFM>
</taSopLineIvcInsert>
</taSopLineIvcInsert_Items>
<taSopLineIvcInsertComponent_Items xsi:nil="true" />
<taSopTrackingNum_Items xsi:nil="true" />
<taSopCommissions_Items xsi:nil="true" />
<taSopLineIvcTaxInsert_Items>
<taSopLineIvcTaxInsert>
<SOPTYPE>3</SOPTYPE>
<SOPNUMBE>STDINV2291 </SOPNUMBE>
<CUSTNMBR>BEIE</CUSTNMBR>
<TAXDTLID>CA-GST-I</TAXDTLID>
<STAXAMNT>10</STAXAMNT>
</taSopLineIvcTaxInsert>
</taSopLineIvcTaxInsert_Items>
<taCreateSopPaymentInsertRecord_Items xsi:nil="true" />
<taSopUserDefined xsi:nil="true" />
<taSopDistribution_Items xsi:nil="true" />
<taAnalyticsDistribution_Items xsi:nil="true" />
<taSopMultiBin_Items xsi:nil="true" />
<taSopHdrIvcInsert>
<SOPTYPE>3</SOPTYPE>
<DOCID>1007647</DOCID>
<SOPNUMBE>1007647</SOPNUMBE>
<TAXSCHID>ALL DETAILS</TAXSCHID>
<TAXAMNT>10</TAXAMNT>
<DOCDATE>09/03/2020</DOCDATE>
<CUSTNMBR>BEIE</CUSTNMBR>
<SUBTOTAL>68.74</SUBTOTAL>
<BACHNUMB>IASALES25042011124</BACHNUMB>
<USINGHEADERLEVELTAXES>1</USINGHEADERLEVELTAXES>
<CREATECOMM>1</CREATECOMM><CURNCYID>Z-US$</CURNCYID>
<INVODATE>09/03/2020</INVODATE>
</taSopHdrIvcInsert><taSopToPopLink xsi:nil="true" />
<taSopUpdateCreateProcessHold xsi:nil="true" />
<taCreateSOPTrackingInfo xsi:nil="true" />
<taMdaUpdate_Items xsi:nil="true" />
</SOPTransactionType>
</eConnect>