Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX forum
Suggested answer

TaxTrans / Taxbookings in AX 2012

Posted on by 2,721

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

  • Suggested answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 288,459 Super User on at
    RE: TaxTrans / Taxbookings in AX 2012

    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.

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 288,459 Super User on at
    RE: TaxTrans / Taxbookings in AX 2012

    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.

  • CU14050944-0 Profile Picture
    CU14050944-0 2,721 on at
    RE: TaxTrans / Taxbookings in AX 2012

    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... 288,459 Super User on at
    RE: TaxTrans / Taxbookings in AX 2012

    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...

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 288,459 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,783 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans