DynDeveloper.com

DynDeveloper.com

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