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>