Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Suggested answer

Relation between TaxTransGeneralJournalAccountEntry and TaxTrans

(0) ShareShare
ReportReport
Posted on by 130

Good morning, what is the difference between those two tables? What are possible reasons for some differences between them?

  • Community Member Profile Picture
    on at
    RE: Relation between TaxTransGeneralJournalAccountEntry and TaxTrans

    Hi,

    what are the keys that connects TaxTrans to TaxTransGeneralJournalAccountEntry and TaxTransGeneralJournalAccountEntry to GeneralJournalAccoutEntry?

  • nuttka Profile Picture
    130 on at
    RE: Relation between TaxTransGeneralJournalAccountEntry and TaxTrans

    Thank you all, I need to analyze and come back to you tomorrow!

  • Blue Wang Profile Picture
    on at
    RE: Relation between TaxTransGeneralJournalAccountEntry and TaxTrans

    Hi Nuttka,

    The TaxTransGeneralJournalAccountEntry link table was introduced because in MicrosoftDynamics AX 2012 there is a many to many relationship between TaxTrans andGeneralJournalAccountEntry.

    This link table tracks multiple relationships between TaxTransand and GeneralJournalAccountEntry.

    TaxTransGeneralJournalAccountEntry.TaxTransRelationship is used to identify therelationship. The relationships correspond to each of the accounts previously stored inTaxTrans.

    113.PNG

  • Ludwig Reinhard Profile Picture
    Microsoft Employee on at
    RE: Relation between TaxTransGeneralJournalAccountEntry and TaxTrans

    Hello nuttka,

    What do you mean when you say that there are differences between those tables?

    Have you tried reconciling your GL balances for your tax accounts with the taxtrans data?

    How did you identify that there is a difference? What report/form/inquiry did you run?

    Best regards,

    Ludwig

  • Suggested answer
    Gunjan Bhattachayya Profile Picture
    35,421 on at
    RE: Relation between TaxTransGeneralJournalAccountEntry and TaxTrans

    Hi,

    TaxTrans table contains all the posted sales tax transactions. It contains links to the subledger tables like CustInvoiceJour (customer invoices), VendInvoiceJour (vendor invoices) and so on.

    TaxTransGeneralJournalAccountEntry table links the TaxTrans table records to the GeneralJournalAccoutEntry table where we can find the corresponding vouchers posted. This table has links to both TaxTrans and GeneralJournalAccoutEntry table.

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

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Adis Hodzic – Community Spotlight

We are honored to recognize Adis Hodzic as our May 2025 Community…

Kudos to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Abhilash Warrier Profile Picture

Abhilash Warrier 254

#2
Martin Dráb Profile Picture

Martin Dráb 230 Most Valuable Professional

#3
Adis Profile Picture

Adis 169 Super User 2025 Season 1

Overall leaderboard

Product updates

Dynamics 365 release plans