Announcements
No record found.
Hi All,
May I know what is the final table for all AX2012 transactions stored (GL, AR Trans, AP Trans....)?
Thank you.
*This post is locked for comments
For AR Trans table is CustTrans
For AP Trans table is VendTrans
You can also have a look on CustInvoiceJour and CustInvoiceTrans tables for AR.
VendInvoicejour and VendInvoiceTrans tables for AP. Read more about these tables from technet. it will give you more idea as per your requirements.
Hi Faisal,
After posted to CustTrans & VendTrans..., will those record post to GL, right? What is the final table for that?
LedgerJournalTable for header
LedgerJournalTrans for lines
Is this what you were looking for to get use these tables ?
Hi Sanme,
The table where the final ledger transactions are posted to irrespective of module, is GeneralJournalAccountEntry. There are other tables as well like GeneralJournalEntry and SubLedgerVoucherGeneralJournalEntry which are linked with GJAE, so for further details, you can check the relations between these tables in AOT. If you check the voucher transactions, most of the fields are from GeneralJournalAccountEntry table, but some of the fields are from related tables.
Please let me know if you have further queries.
Thanks,
Baber.
Good question.
Can i know what is the link between cust trans/vend trans/item trans/bank trans to GeneralJournalAccountEntry ?
The voucher is the link between all transactional tables and the general journal. Some transaction have more than one voucher, i.e. InventTrans has Voucher and VoucherPhysical, each representing different phases that an InventTrans records can have. Other transactions have a single voucher. Often what occurs in the general journal is a summary to some degree of what happens in transactional tables. For example, a customer invoice journal (CustInvoiceJour and one or more CustInvoiceTrans records) generates a customer transaction (CustTrans), and a single voucher in the general journal (GeneralJournalEntry with multiple GeneralJournalAccountEntry records). But, a single GeneralJournalAccountEntry record will not refer directly back to a single CustInvoiceTrans record exclusively, at least not always (it may happen by coincidence but not by design).
Excellent explanation Brandon.
You can find the voucher field for ledger transactions in SubLedgerVoucherGeneralJournalEntry table, field name Voucher. This voucher matches with the voucher in VendTrans and CustTrans table. There is no direct relationship between customer or vendor transactions and General Journal Account entry table.
Hope it helps.
@Baber Owais : So how can I differentiate if the transaction is a GL transaction or AP/AR transaction. from GJAC or GAE table
Hi Krishnendu,
You need to match voucher with either CustTrans or VendTrans. If it matches with the voucher field in CustTrans, then it is AR transactrions and if it matches with VendTrans, then it is AP transactions. Hope this answers your question.
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.
Congratulations to our 2026 Super Stars!
Thanks to all of our 2025 Community Spotlight stars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Sagar Suman 2 Super User 2026 Season 1
Alexey Lekanov 2
Pratik Bhosle 2
