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
sendow 6/23/2009 3:21:53 PM

eConnect 9 SOP Invoice Error 67: Subtotal does not match the line item totals

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

I am importing SOP invoices from XML files prepared by a client.  The file appears to be correct, but when I attempt to import it, I get the error

"Subtotal does not match the line item totals".

I have asked them to include the Subtotal node in their XML because the transactions are coming from an eCommerce web site, and I want to ensure that the data and subtotals being imported from the XML files matches what GP calculates.  In theory, this shouldn't be a problem, as there should be no issue including the Subtotal node (and I've done other eConnect imports that have the Subtotal node that work fine).

To try and rule out any issues with tax and freight and do a basic test, I have even tried modifying the file so that it only has one line line item with no tax or freight, but the same error occurs.  Entering the transaction directly into GP doesn't give any errors or other clues.

I'm hoping it's something simple, like a missing node or a simple mistake, but I'm not seeing it...

Any help would be appreciated...

 

 eConnect error: Microsoft.GreatPlains.eConnect.eConnectException: Error Number = 67  Stored Procedure taSopHdrIvcInsert  Error Description = Subtotal does not match the line item totals

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 = 940843-123557
SOPTYPE = 3
Related Error Code Parameters for Node : taSopHdrIvcInsert                                  
SUBTOTAL = 30.00

<taSopHdrIvcInsert><SOPTYPE>3</SOPTYPE><DOCID>INV CONSOLE</DOCID><SOPNUMBE>940843-123557</SOPNUMBE><ORIGNUMB>940843</ORIGNUMB><LOCNCODE>INNO-BB</LOCNCODE><DOCDATE>08/01/2006</DOCDATE><FREIGHT>0</FREIGHT><TAXAMNT>0</TAXAMNT>

<MISCAMNT>0</MISCAMNT><TRDISAMT>0</TRDISAMT><CUSTNMBR>0029</CUSTNMBR><CUSTNAME>SOAPnet Store</CUSTNAME><SUBTOTAL>30.00</SUBTOTAL><DOCAMNT>30.00</DOCAMNT>

<BACHNUMB>CONSOLE01</BACHNUMB><USER2ENT>sa</USER2ENT><FRTTXAMT>0</FRTTXAMT>

<MSCTXAMT>0</MSCTXAMT><ORDRDATE>01/03/2006</ORDRDATE><INVODATE>01/03/2006</INVODATE>

<CMMTTEXT>9611804625277200128060</CMMTTEXT></taSopHdrIvcInsert>
Processing complete: 6/23/2009 12:15:14 PM

 

 <?xml version="1.0" encoding="utf-8"?>
<eConnect xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
  <SOPTransactionType>
    <taSopHdrIvcInsert>
      <SOPTYPE>3</SOPTYPE>
      <DOCID>INV CONSOLE</DOCID>
      <SOPNUMBE>940843-123557</SOPNUMBE>
      <ORIGNUMB>940843</ORIGNUMB>
      <LOCNCODE>INNO-BB</LOCNCODE>
      <DOCDATE>08/01/2006</DOCDATE>
      <CUSTNMBR>0029</CUSTNMBR>
      <CUSTNAME>SOAPnet Store</CUSTNAME>
      <SUBTOTAL>30.00</SUBTOTAL>
      <DOCAMNT>30.00</DOCAMNT>
      <BACHNUMB>CONSOLE01</BACHNUMB>
      <USER2ENT>sa</USER2ENT>
      <ORDRDATE>01/03/2006</ORDRDATE>
      <INVODATE>01/03/2006</INVODATE>
      <CMMTTEXT>9611804625277200128060</CMMTTEXT>
    </taSopHdrIvcInsert>
    <taSopLineIvcInsert_Items>
      <taSopLineIvcInsert>
        <SOPTYPE>3</SOPTYPE>
        <SOPNUMBE>940843-123557</SOPNUMBE>
        <CUSTNMBR>0029</CUSTNMBR>
        <DOCDATE>08/01/2006</DOCDATE>
        <LOCNCODE>INNO-BB</LOCNCODE>
        <ITEMNMBR>406-3598</ITEMNMBR>
        <UNITPRCE>30.00</UNITPRCE>
        <XTNDPRCE>30.00</XTNDPRCE>

        <QUANTITY>1</QUANTITY>
      </taSopLineIvcInsert>
    </taSopLineIvcInsert_Items>
  </SOPTransactionType>
</eConnect>

Version: Unknown or N/A
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