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

Announcements

Check out the Community Spotlight Video Series
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / TaxTrans / Taxbookings...
Microsoft Dynamics AX (Archived)

TaxTrans / Taxbookings in AX 2012

(0) ShareShare
ReportReport
Posted on by CU14050944-0

Hi, we struggle a littel with Tax (Vat) crosschecks between ledgerbookings and taxtransbookings.

I was looking to create a Report in SQL something like "Select all taxbookings from taxtrans in relation to a generaljournalentry"

My first attemt failed, coz linking generaljournalentry and SubledgerVoucherGeneralJournalEntry for the voucher and the link on the taxtrans didnt work, coz of multiple ledgerbookings ...

Then i tried to link Generaljournalentry via TaxTransGeneralJournalAccountEntry to taxtrans ..

looked good, but seems not all bookings have an entry in TaxTransGeneralJournalAccountEntry ..

im a littl lost ..

We created a view :

***

select

...

...

..

from

GeneralJournalAccountEntry

join

GeneralJournalEntry  

on

GeneralJournalEntry.RecId = GeneralJournalAccountEntry.GeneralJournalEntry  

join

SubledgerVoucherGeneralJournalEntry

on

SubledgerVoucherGeneralJournalEntry.GeneralJournalEntry = GeneralJournalEntry.RecId

And i want to linkt this somehow to the bookings in taxtrans ..

(as i told voucher does not work )

Any one haveing an idea?

Thanks

Pirmin

*This post is locked for comments

I have the same question (0)
  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 306,846 Super User 2026 Season 2 on at

    Hi Pirmin,

    I'm not able to access my machines due to a vacation. Are you aware of some field definitions in the taxtrans which are set as invisible? Then you don't see the values within ax itself. In the AOT you can see the relations on the table TaxTrans. This might give you some directions.

    I had also looked into this some while ago. It seems that there might be a different storage for e.g. journals and sales invoices. In AX2009 the link was easier...

  • CU14050944-0 Profile Picture
    CU14050944-0 on at

    Hi

    well i directly looked in the database.

    What im looking for is som query that Displays all (VAT) bookings related to a ledgerbooking ( with account)

    realy hard to find ;-)

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 306,846 Super User 2026 Season 2 on at

    Hi Pirmin,

    For a voucher in total it is possible to find all TaxTrans records, but if you have multiple Accounting entries and multiple TaxTrans records within one voucher it is really hard to explain. Then which TaxTrans is related to which Accounting entry?

    I looked into this a while ago. I had a question, but not the requirement to build e.g. a query or report.

    Frm the TaxTrans I had seen a relation to the general journal transactions and a source document header. I think the combination also with the accounting entries should give the exact relstion per line, but cannot remember it fully.

  • Suggested answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 306,846 Super User 2026 Season 2 on at

    HI Pirmin,

    There is a report enhanced in CU7 for AX 2012 R2. General ledger > Reports > Transactions > Groupings > Sales tax specification by ledger transaction. This report should give you options for the reconciliation.

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

Check out the Community Spotlight Video Series

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans