DynDeveloper.com

DynDeveloper.com

Sign Up Now!Log In
sendow 6/21/2013 1:56:39 PM

taPMTransactionInsert Error 313: Tax table detail does not equal the tax amount

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

I am having to insert a PM Transaction with sales taxes using eConnect 2010.  This is a modification to an existing AP Invoice import--I just need to add the sales taxes.

I have created a tax detail ID with 0% rate, and am able to manually enter transactions with various sales tax amounts using the tax ID.

When I attempt to import a PM transaction with taPMTransactionTaxInsert, I get:

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

Error Number = 313  Stored Procedure= taPMTransactionInsert  Error Description = Tax table detail does not equal the tax amount

 This error is triggered by the taPMTransactionInsert proc using the following code.  I have traced the taPMTransactionTaxInsert procedure, and far as I can tell, the PM10500 record is being written properly, so when taPMTransactionInsert queries PM10500, the data should match the XML values I'm sending in for the header.

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

Do I have something wrong in the transaction header?

 

 

    select @TAXAMNT = isnull(sum(TAXAMNT), 0.00)
          from   PM10500 (nolock)
          where  DOCTYPE = @I_vDOCTYPE
                 and VCHRNMBR = @I_vVCHNUMWK
                 and BKOUTTAX <> 1
          if ( @TAXAMNT <> @I_vTAXAMNT )
            begin
                select @O_iErrorState = 313
                exec @iStatus = taUpdateString
                  @O_iErrorState,
                  @oErrString,
                  @oErrString output,
                  @O_oErrorState output
            end

 

<eConnect xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xmlns:xsd=\"http://www.w3.org/2001/XMLSchema\">
  <PMTransactionType>
    <eConnectProcessInfo xsi:nil=\"true\" />
    <taRequesterTrxDisabler_Items xsi:nil=\"true\" />
    <taUpdateCreateVendorRcd xsi:nil=\"true\" />
    <taCreateVendorAddress_Items xsi:nil=\"true\" />
    <taPMTransactionTaxInsert_Items>
      <taPMTransactionTaxInsert>
        <VENDORID>GHDIN</VENDORID>
        <VCHRNMBR>11</VCHRNMBR>    <---- My bug!
        <DOCTYPE>1</DOCTYPE>
        <BACHNUMB>MXAP0906-13</BACHNUMB>
        <TAXDTLID>APTAX</TAXDTLID>
        <TAXAMNT>1</TAXAMNT>
        <PCTAXAMT>1</PCTAXAMT>
        <TDTTXPUR>12.22</TDTTXPUR>
        <TXDTTPUR>12.22</TXDTTPUR>
      </taPMTransactionTaxInsert>
    </taPMTransactionTaxInsert_Items>
    <taPMDistribution_Items>
      <taPMDistribution>
        <DOCTYPE>1</DOCTYPE>
        <VCHRNMBR>V0000560</VCHRNMBR>
        <VENDORID>GHDIN</VENDORID>
        <DISTTYPE>6</DISTTYPE>
        <DistRef>test interface modification</DistRef>
        <ACTNUMST>000-2111-00</ACTNUMST>
        <DEBITAMT>12.22</DEBITAMT>
      </taPMDistribution>
      <taPMDistribution>
        <DOCTYPE>1</DOCTYPE>
        <VCHRNMBR>V0000560</VCHRNMBR>
        <VENDORID>GHDIN</VENDORID>
        <DISTTYPE>10</DISTTYPE>
        <DistRef>test interface modification</DistRef>
        <ACTNUMST>000-2111-00</ACTNUMST>
        <DEBITAMT>1</DEBITAMT>
      </taPMDistribution>
      <taPMDistribution>
        <DOCTYPE>1</DOCTYPE>
        <VCHRNMBR>V0000560</VCHRNMBR>
        <VENDORID>GHDIN</VENDORID>
        <DISTTYPE>2</DISTTYPE>
        <DistRef>test interface modification</DistRef>
        <ACTNUMST>000-2100-00</ACTNUMST>
        <CRDTAMNT>13.22</CRDTAMNT>
      </taPMDistribution>
    </taPMDistribution_Items>
    <taAnalyticsDistribution_Items xsi:nil=\"true\" />
    <taPMTransactionInsert>
      <BACHNUMB>MXAP0906-13</BACHNUMB>
      <VCHNUMWK>V0000560</VCHNUMWK>
      <VENDORID>GHDIN</VENDORID>
      <DOCNUMBR>11</DOCNUMBR>
      <DOCTYPE>1</DOCTYPE>
      <DOCAMNT>13.22</DOCAMNT>
      <DOCDATE>2010-09-06</DOCDATE>
      <TAXSCHID>AP</TAXSCHID>
      <PRCHAMNT>12.22</PRCHAMNT>
      <CHRGAMNT>13.22</CHRGAMNT>
      <TRXDSCRN>IN10601: test interface modification</TRXDSCRN>
      <TAXAMNT>1</TAXAMNT>
      <TEN99AMNT>12.22</TEN99AMNT>
      <MDFUSRID>MAXADMIN</MDFUSRID>
      <CREATEDIST>0</CREATEDIST>
    </taPMTransactionInsert>
    <taMdaUpdate_Items xsi:nil=\"true\" />
  </PMTransactionType>
</eConnect>

Version: GP 2010
Section: eConnect