You’re offline. This is a read only version of the page.
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
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.
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.
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 ;-)
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...
#1
Mohamed Amine Mahmoudi
100
Super User 2025 Season 1
#2
Community Member
48
#3
Zain Mehmood
6
Moderator
Share
Report
All responses (
Answers (
