ANSWERED - SOP Transaction Entry Error

	SOP Scripts
	eConnect
	taSopDeleteDocumentWrapper
	taSopLineDeleteWrapper
	taSOPLineIvcInsert Wrapper
	taSopLineIvcInsertComponent
	taSOPLotAuto - complete procedure
	Functions
	ddf_Address
	ddf_AllHoldsOnASOPDoc
	General
	Getting Email addresses from Dynamics GP
	Move a SOP transaction from open to history
	Posting Sequences
	SOP40200 'Allow' fields query
	sopGetIDNumber
	sopTrxDeleteWork
	Unvoid a SOP document
	Stored Procedures
	dd_SOP10102_UPD
	dd_SOPGetNextDocNumber/ sopGetIDNumber.
	dd_SOPPayment_INS
	dd_SOPRound - Round a SOP Multicurrency document to two decimal places
	dd_SOPTotal
	dd_SOPTotalTaxes
	dd_taSopVoidDocumentWrapper

dbartley 2/7/2014 9:06:06 AM

SOP Transaction Entry Error

Edit 9/16/15 View the main article for this error here

I have a scenario and am not sure what I am doing wrong here:

Client has PO with markdowns and trade discounts. I am calculating the following:

At the detail level made the line extended amount XTNDPRCE = [Qty* (price-markdown) ] . At the header level made SUBTOTAL node be the sum of the calculated line extended amount and the TRDISAMT is the total discount not including the markdown.

I am then receiving an eConnect error stating:

Error Number = 67 Stored Procedure= taSopHdrIvcInsert Error Description = Subtotal does not match the line item totals Node Identifier Parameters: taSopHdrIvcInsert SOPNUMBE = STORD0017411 SOPTYPE = 2 Related Error Code Parameters for Node : taSopHdrIvcInsert SUBTOTAL = 17219.13 <taSopHdrIvcInsert> <SOPTYPE>2</SOPTYPE> <DOCID>STANDARD</DOCID> <TRDISAMT>692.22</TRDISAMT> <SUBTOTAL>17219.13</SUBTOTAL>

The subtotal matches the sum of the extended price.

I have attached the XML I am trying to pass to eConnect. If you can give me some insight, I would appreciate it.

<?xml version="1.0" encoding="UTF-8"?>

<eConnect xmlns:dt="urn:schemas-microsoft-com:datatypes">

<SOPTransactionType>

<eConnectProcessInfo>

<ConnectionString>Data Source=JSOMAAPP01;Initial Catalog=TEST;Persist Security Info=False;Integrated Security=SSPI</ConnectionString>

<EConnectProcsRunFirst>True</EConnectProcsRunFirst>

</eConnectProcessInfo>

<taSopHdrIvcInsert>

<SOPTYPE>2</SOPTYPE>

<DOCID>STANDARD</DOCID>

<TRDISAMT>692.22</TRDISAMT>

<SUBTOTAL>17219.13</SUBTOTAL>

<SHIPMTHD>COMMON CARRIER</SHIPMTHD>

<SOPNUMBE>STORD0017412</SOPNUMBE>

<LOCNCODE>PLANT1</LOCNCODE>

<DOCDATE>02/06/2014</DOCDATE>

<CUSTNMBR>11860</CUSTNMBR>

<CSTPONBR>83781</CSTPONBR>

<BACHNUMB>EDI-02/06/14-10</BACHNUMB>

<ORDRDATE>10/14/2013</ORDRDATE>

<PRSTADCD>SPRINGFIELD</PRSTADCD>

<COMMENT_1>b/h Mon del Wed</COMMENT_1>

</taSopHdrIvcInsert>

<taSopUserDefined>

<SOPTYPE>2</SOPTYPE>

<SOPNUMBE>STORD0017412</SOPNUMBE>

<USRDAT01>10/28/2013</USRDAT01>

<USERDEF1></USERDEF1>

<USERDEF2></USERDEF2>

<USRDEF03></USRDEF03>

<USRDEF04></USRDEF04>

<USRDEF05>287</USRDEF05>

</taSopUserDefined>

<taSopLineIvcInsert>

<SOPTYPE>2</SOPTYPE>

<SOPNUMBE>STORD0017412</SOPNUMBE>

<CUSTNMBR>11860</CUSTNMBR>

<DOCDATE>02/06/2014</DOCDATE>

<ITEMNMBR>22301</ITEMNMBR>

<LOCNCODE>PLANT1</LOCNCODE>

<UNITPRCE>21.97</UNITPRCE>

<XTNDPRCE>2768.22</XTNDPRCE>

<QUANTITY>126.00</QUANTITY>

<MRKDNAMT>0</MRKDNAMT>

<LNITMSEQ>16384</LNITMSEQ>

<DOCID>STANDARD</DOCID>

<PRSTADCD>SPRINGFIELD</PRSTADCD>

<UpdateIfExists>1</UpdateIfExists>

<UOFM>case</UOFM>

<USRDEFND3>1</USRDEFND3>

</taSopLineIvcInsert>

<taSopLineIvcInsert>

<SOPTYPE>2</SOPTYPE>

<SOPNUMBE>STORD0017412</SOPNUMBE>

<CUSTNMBR>11860</CUSTNMBR>

<DOCDATE>02/06/2014</DOCDATE>

<ITEMNMBR>22300</ITEMNMBR>

<LOCNCODE>PLANT1</LOCNCODE>

<UNITPRCE>21.97</UNITPRCE>

<XTNDPRCE>5536.44</XTNDPRCE>

<QUANTITY>252.00</QUANTITY>

<MRKDNAMT>0</MRKDNAMT>

<LNITMSEQ>32768</LNITMSEQ>

<DOCID>STANDARD</DOCID>

<PRSTADCD>SPRINGFIELD</PRSTADCD>

<UpdateIfExists>1</UpdateIfExists>

<UOFM>case</UOFM>

<USRDEFND3>2</USRDEFND3>

</taSopLineIvcInsert>

<taSopLineIvcInsert>

<SOPTYPE>2</SOPTYPE>

<SOPNUMBE>STORD0017412</SOPNUMBE>

<CUSTNMBR>11860</CUSTNMBR>

<DOCDATE>02/06/2014</DOCDATE>

<ITEMNMBR>22310</ITEMNMBR>

<LOCNCODE>PLANT1</LOCNCODE>

<UNITPRCE>21.97</UNITPRCE>

<XTNDPRCE>2768.22</XTNDPRCE>

<QUANTITY>126.00</QUANTITY>

<MRKDNAMT>0</MRKDNAMT>

<LNITMSEQ>49152</LNITMSEQ>

<DOCID>STANDARD</DOCID>

<PRSTADCD>SPRINGFIELD</PRSTADCD>

<UpdateIfExists>1</UpdateIfExists>

<UOFM>case</UOFM>

<USRDEFND3>3</USRDEFND3>

</taSopLineIvcInsert>

<taSopLineIvcInsert>

<SOPTYPE>2</SOPTYPE>

<SOPNUMBE>STORD0017412</SOPNUMBE>

<CUSTNMBR>11860</CUSTNMBR>

<DOCDATE>02/06/2014</DOCDATE>

<ITEMNMBR>22324</ITEMNMBR>

<LOCNCODE>PLANT1</LOCNCODE>

<UNITPRCE>21.97</UNITPRCE>

<XTNDPRCE>2768.22</XTNDPRCE>

<QUANTITY>126.00</QUANTITY>

<MRKDNAMT>0</MRKDNAMT>

<LNITMSEQ>65536</LNITMSEQ>

<DOCID>STANDARD</DOCID>

<PRSTADCD>SPRINGFIELD</PRSTADCD>

<UpdateIfExists>1</UpdateIfExists>

<UOFM>case</UOFM>

<USRDEFND3>4</USRDEFND3>

</taSopLineIvcInsert>

<taSopLineIvcInsert>

<SOPTYPE>2</SOPTYPE>

<SOPNUMBE>STORD0017412</SOPNUMBE>

<CUSTNMBR>11860</CUSTNMBR>

<DOCDATE>02/06/2014</DOCDATE>

<ITEMNMBR>22307</ITEMNMBR>

<LOCNCODE>PLANT1</LOCNCODE>

<UNITPRCE>21.97</UNITPRCE>

<XTNDPRCE>1384.11</XTNDPRCE>

<QUANTITY>63.00</QUANTITY>

<MRKDNAMT>0</MRKDNAMT>

<LNITMSEQ>81920</LNITMSEQ>

<DOCID>STANDARD</DOCID>

<PRSTADCD>SPRINGFIELD</PRSTADCD>

<UpdateIfExists>1</UpdateIfExists>

<UOFM>case</UOFM>

<USRDEFND3>5</USRDEFND3>

</taSopLineIvcInsert>

<taSopLineIvcInsert>

<SOPTYPE>2</SOPTYPE>

<SOPNUMBE>STORD0017412</SOPNUMBE>

<CUSTNMBR>11860</CUSTNMBR>

<DOCDATE>02/06/2014</DOCDATE>

<ITEMNMBR>22944</ITEMNMBR>

<LOCNCODE>PLANT1</LOCNCODE>

<UNITPRCE>26.44</UNITPRCE>

<XTNDPRCE>1182.72</XTNDPRCE>

<QUANTITY>48.00</QUANTITY>

<MRKDNAMT>1.8</MRKDNAMT>

<LNITMSEQ>98304</LNITMSEQ>

<DOCID>STANDARD</DOCID>

<PRSTADCD>SPRINGFIELD</PRSTADCD>

<UpdateIfExists>1</UpdateIfExists>

<UOFM>case</UOFM>

<USRDEFND3>6</USRDEFND3>

</taSopLineIvcInsert>

<taSopLineIvcInsert>

<SOPTYPE>2</SOPTYPE>

<SOPNUMBE>STORD0017412</SOPNUMBE>

<CUSTNMBR>11860</CUSTNMBR>

<DOCDATE>02/06/2014</DOCDATE>

<ITEMNMBR>22721</ITEMNMBR>

<LOCNCODE>PLANT1</LOCNCODE>

<UNITPRCE>27.04</UNITPRCE>

<XTNDPRCE>778.75</XTNDPRCE>

<QUANTITY>30.00</QUANTITY>

<LNITMSEQ>114688</LNITMSEQ>

<DOCID>STANDARD</DOCID>

<PRSTADCD>SPRINGFIELD</PRSTADCD>

<UpdateIfExists>1</UpdateIfExists>

<UOFM>case</UOFM>

<USRDEFND3>7</USRDEFND3>

</taSopLineIvcInsert>

</SOPTransactionType>

</eConnect>

Version: All

Section: eConnect

DynDeveloper.com

SOP Transaction Entry Error