Hi,
For reporting purposes (outside AX) I need to find the right sql tables and fields on posting layers. The report must have a filter based on the reporting layer so the user can select what layer to report on.
Any suggestions?
Kind regards,
Johan
Hello SCoPeS,
Where and how do you use the different posting layers; in the fixed asset module? If you use it there be careful because the fixed asset module is usually not setup in a way to record delta postings, which can result in a double counting of the numbers you add.
Best regards,
Ludwig
Thanks. LedgerTrans does not hold that field. I found it in the related journalname table
Hi SCoPeS,
If you have an AX4 database, please check table LedgerTrans. If you are looking for Operations layer, you should query by value 2 only.
Could you please elaborate on what your exact requirementis?
Thanks for your reply.
I think it's an AX4 database, don't have access to the application itself.
I did find CURRENTOPERATIONSTAX in the LEDGERJOURNALTABLE table and it seems to be the integer defining which posting layer it is.
Would you happen to know if you need to accumulate the layers? That is, that if you want layer 2 (operations) you actually need layer 1+2?
Hello Johan,
Can you provide more information on your requirement because not all transactions can make use of posting layers.
What kind of report do you need to create based on which data and where?
Best regards,
Ludwig
HI SCoPeS,
You can use the tables - GeneralJournalEntry and GeneralJournalAccountEntry. The field "PostingLayer" is present in GeneralJournalEntry table.
SELECT * FROM GENERALJOURNALACCOUNTENTRY AS GJE JOIN GENERALJOURNALENTRY AS GJ ON GJ.RECID = GJE.GeneralJournalEntry
André Arnaud de Cal...
291,979
Super User 2025 Season 1
Martin Dráb
230,848
Most Valuable Professional
nmaenpaa
101,156