Site Search:
Sign in | Join | Help

Document amount does not equal (Subtotal+Freight+Misc+TaxAmt+FreightTax+MiscTax-TradeDisc)

Last post 07-03-2009 3:13 PM by Anonymous. 1 replies.
Page 1 of 1 (2 items)
Sort Posts: Previous Next
  • 07-03-2009 3:10 PM

    Document amount does not equal (Subtotal+Freight+Misc+TaxAmt+FreightTax+MiscTax-TradeDisc)

    Server was unable to process request. ---> Sql procedure error codes returned:
    Error Number = 235  Stored Procedure taSopHdrIvcInsert  Error Description = Document amount does not equal (Subtotal+Freight+Misc+TaxAmt+FreightTax+MiscTax-TradeDisc)
    Node Identifier Parameters: taSopHdrIvcInsert                                 
    SOPNUMBE = STD00440275     
    SOPTYPE = 2
    Related Error Code Parameters for Node : taSopHdrIvcInsert                                 
    SUBTOTAL = 1779.75
    FREIGHT =  Note: This parameter was not passed in, no value for the parameter will be returned.
    MISCAMNT =  Note: This parameter was not passed in, no value for the parameter will be returned.
    TAXAMNT =  Note: This parameter was not passed in, no value for the parameter will be returned.
    FRTTXAMT =  Note: This parameter was not passed in, no value for the parameter will be returned.
    MSCTXAMT =  Note: This parameter was not passed in, no value for the parameter will be returned.
    TRDISAMT = 0
    DOCAMNT =  Note: This parameter was not passed in, no value for the parameter will be returned.


    <taSopHdrIvcInsert><SOPTYPE>2</SOPTYPE><DOCID>STDORD         </DOCID><SOPNUMBE>STD00440275      </SOPNUMBE><LOCNCODE>001        </LOCNCODE><DOCDATE>7/3/2009</DOCDATE><TRDISAMT>0</TRDISAMT><CUSTNMBR>13498</CUSTNMBR><SUBTOTAL>1779.75</SUBTOTAL><BACHNUMB>GPI07032009</BACHNUMB><PRBTADCD>PRIMARY        </PRBTADCD><PRSTADCD>134980305112124</PRSTADCD><CREATETAXES>1</CREATETAXES><ReqShipDate>8/1/2009</ReqShipDate></taSopHdrIvcInsert>
    <eConnect xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
      <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>2</SOPTYPE>
            <SOPNUMBE>STD00440275      </SOPNUMBE>
            <CUSTNMBR>13498</CUSTNMBR>
            <DOCDATE>7/3/2009</DOCDATE>
            <ITEMNMBR>GENSH~TESTPROD~MS              </ITEMNMBR>
            <UNITPRCE>177.975</UNITPRCE>
            <XTNDPRCE>1779.75</XTNDPRCE>
            <QUANTITY>10</QUANTITY>
            <MRKDNAMT>0</MRKDNAMT>
            <UOFM>Cube     </UOFM>
          </taSopLineIvcInsert>
        </taSopLineIvcInsert_Items>
        <taSopLineIvcInsertComponent_Items xsi:nil="true" />
        <taSopTrackingNum_Items xsi:nil="true" />
        <taSopCommissions_Items xsi:nil="true" />
        <taSopLineIvcTaxInsert_Items xsi:nil="true" />
        <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>2</SOPTYPE>
          <DOCID>STDORD         </DOCID>
          <SOPNUMBE>STD00440275      </SOPNUMBE>
          <LOCNCODE>001        </LOCNCODE>
          <DOCDATE>7/3/2009</DOCDATE>
          <TRDISAMT>0</TRDISAMT>
          <CUSTNMBR>13498</CUSTNMBR>
          <SUBTOTAL>1779.75</SUBTOTAL>
          <BACHNUMB>GPI07032009</BACHNUMB>
          <PRBTADCD>PRIMARY        </PRBTADCD>
          <PRSTADCD>134980305112124</PRSTADCD>
          <CREATETAXES>1</CREATETAXES>
          <ReqShipDate>8/1/2009</ReqShipDate>
        </taSopHdrIvcInsert>
        <taSopToPopLink xsi:nil="true" />
        <taSopUpdateCreateProcessHold xsi:nil="true" />
        <taCreateSOPTrackingInfo xsi:nil="true" />
        <taMdaUpdate_Items xsi:nil="true" />
      </SOPTransactionType>
    </eConnect>

    • Post Points: 1
  • 07-03-2009 3:13 PM In reply to

    Re: Document amount does not equal (Subtotal+Freight+Misc+TaxAmt+FreightTax+MiscTax-TradeDisc)

    I was trying to figure out how to allow Dynamics to calculate the taxes automatically.

    In order to make this work, I had to do this:

     .SUBTOTAL = dblSubtotal
    .FREIGHT = 0
    .MISCAMNT = 0
    '.TAXAMNT = 0
    '.FRTTXAMT = 0
    '.MSCTXAMT = 0
    '.TRDISAMT = 0
    
    
    'this is '1'
    .CREATETAXES = eConnect9.GP9.SOP.taSOPHdrIvcInsert.CREATETAXESType.dynamicsHandlesTaxes
    .DOCAMNT = dblSubtotal

    Note that SUBTOTAL = DOCAMNT, and that most everything else is commented out

    • Post Points: 1
Page 1 of 1 (2 items)