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
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








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