web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Sign Up for Ask a Community Pro Today!
Introducing our New Video Series: Community Spotlight
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / GP10 eConnect taPMTran...
Microsoft Dynamics GP (Archived)

GP10 eConnect taPMTransaction Insert error

(0) ShareShare
ReportReport
Posted on by David Carver 45

I have a strange problem with taPMTransactionInsert called from SQL.  It will only accept a voucher number that is the same as the invoice number.  It will not accept even the next voucher number from PM004100.  Trying any other number generates the bizarre error 313 Tax table detail does not equal the tax Amount !!  Does anyone have any bright ideas?

*This post is locked for comments

I have the same question (0)
  • steveendow Profile Picture
    steveendow 2,281 on at

    The above post is over 2 years old, but I thought I would chime in and share that I am experiencing the exact same problem with eConnect 2010.  

    I was getting the 313 Tax table detail error.  I checked and double checked everything, and even traced the eConnect stored procedures to confirm the tax info was being saved properly, but everything looked fine.

    I tried the above suggestion of setting the document number the same as the voucher number, and amazingly, the transaction imported okay.

    So it would appear that this is a bug somewhere in taPMTransactionInsert or taPMTransactionTaxInsert.

  • Verified answer
    steveendow Profile Picture
    steveendow 2,281 on at

    After further review, I found that I had a bug in my .NET code that was causing the problem.

    I had incorrectly assigned the invoice document number to the VCHRNMBR node in taPMTransactionTaxInsert.

    So the tax node was serialized (and saved to PM10500 in the database) with an incorrect voucher number, preventing taPMTransactionInsert from locating the tax record in PM10500.  Hence the error.

    So it looks like eConnect 2010 is working just fine.  Just make sure to double check the values assigned to taPMTransactionTaxInsert.

  • MarkStep Profile Picture
    MarkStep 5 on at

    Hi Steve,

    I'm running into an similar issue that is producing the same error. Based on the error do you also think there is a bug in the .NET code. I am able to manually create the transaction in GP but I get an error when running the connector. Is there a value I can change to test if this is the same bug?

    Thanks

    07/11/2019 16:35:31.51: Failed to import AP invoice 101 for vendor ACETRAVE0001: Sql procedure error codes returned:

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

    Node Identifier Parameters: taPMTransactionInsert

    BACHNUMB = AP1906121727

    VCHNUMWK = 00000000000001262

    VENDORID = ACETRAVE0001

    DOCNUMBR = 101

    DOCTYPE = 1

    DOCDATE = 6/12/2019 12:00:00 AM

    Related Error Code Parameters for Node : taPMTransactionInsert

    TAXAMNT = 10

    <taPMTransactionInsert>

     <BACHNUMB>AP1906121727</BACHNUMB>

     <VCHNUMWK>00000000000001262</VCHNUMWK>

     <VENDORID>ACETRAVE0001</VENDORID>

     <DOCNUMBR>101</DOCNUMBR>

     <DOCTYPE>1</DOCTYPE>

     <DOCAMNT>110</DOCAMNT>

     <DOCDATE>6/12/2019 12:00:00 AM</DOCDATE>

     <PRCHAMNT>100</PRCHAMNT>

     <CHRGAMNT>110</CHRGAMNT>

     <TRXDSCRN>TEST</TRXDSCRN>

     <TAXAMNT>10</TAXAMNT>

     <PORDNMBR>PO2080</PORDNMBR>

     <CREATEDIST>0</CREATEDIST>

    </taPMTransactionInsert>

    07/11/2019 16:35:31.51: Failed to import AP Invoice file: AP_Invoice_101_123.xml

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Sign Up for Ask a Community Pro Today!
Introducing our New Video Series: Community Spotlight

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the December Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans