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

Community site session details

Session Id :
Microsoft Dynamics AX (Archived)

I found some transaction of tax not posted to TAXTRANS table?

(0) ShareShare
ReportReport
Posted on by 152

Hi All,

I found some data of tax Item is not posted to TAXTRANS Table,  I try to compare with a normal item

but not found anything difference.   Could anyone advise me to find the root cause and how to fix this problem. 

Thank you in advance.
Prasit P.

*This post is locked for comments

I have the same question (0)
  • André Arnaud de Calavon Profile Picture
    299,397 Super User 2025 Season 2 on at
    RE: I found some transaction of tax not posted to TAXTRANS table?

    Hi Prasit,

    Please provide more information. What exactly are you posting? A memo? Purchase order invoice? Sales, Project???

  • Suggested answer
    Pravasti AK Profile Picture
    2,985 on at
    RE: I found some transaction of tax not posted to TAXTRANS table?

    HI Prasit

    Yes the field will be empty for some records in tax trans - because every tax transaction may not include items- example could be a journal.

    InventTransId will be generated for every transaction which includes items. So i believe it will get filled when a sales invoice gets posted...

  • PrasitP. Profile Picture
    152 on at
    RE: I found some transaction of tax not posted to TAXTRANS table?

    Hi All

    I would like to give for more information, For the abnormal above is came from the function Invoice journal in Account Payable.

    InvJournal.jpg

    and input the tax transaction by Account type: Ledger as example below.

    InvDetail.jpg

    I have many data input by same case, but after posted Journal  I found  some Journal not posted to TAXTRANS table.

    Could you please advise me how to check what is the data not complete?

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Microsoft Employee on at
    RE: I found some transaction of tax not posted to TAXTRANS table?

    Hi PrasitP,

    On your screenshot above, there is only a tax group specified but no item sales tax group. You can also identify that the calculated tax fields show an amount of $0. I expect that this is the underlying reason why no tax is posted.

    Can you compare the line that you highlighted with other journal lines that have a tax posted?

    Also double check and verify the required combinations of tax group and item tax group that result in a specific tax code and tax calculation.

    Best regards,

    Ludwig

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

Quick Links

Responsible AI policies

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

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Community Member Profile Picture

Community Member 4

#1
Martin Tocauer Profile Picture

Martin Tocauer 4

#3
Nayyar Siddiqi Profile Picture

Nayyar Siddiqi 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans