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
How do we then find a single General Journal Account Entry record when referring directly back to CustTrans ??
Also, what are possible reasons of fetching Nulls after below joins
Select t1.*, t2.*
GeneralJournalAccountEntry t1, CustTrans t2
Where t1.voucher = t2.voucher
Hi syed baber ,
Related to Purchase, if we made a purchase through Purchase Order so the Invoice Amount will be saved in VendInvoiceTrans.
But what if we made a purchase through Vendor Invoice Journal(for non P.O Items) where does it will get saved in -->data dictionary--> tables??
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.
Thanks,
Baber.
@Baber Owais : So how can I differentiate if the transaction is a GL transaction or AP/AR transaction. from GJAC or GAE table
Excellent explanation Brandon.
Hi Sanme,
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.
Thanks,
Baber.
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).
Good question.
Can i know what is the link between cust trans/vend trans/item trans/bank trans to GeneralJournalAccountEntry ?
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.
Is this what you were looking for to get use these tables ?
LedgerJournalTable for header
LedgerJournalTrans for lines
André Arnaud de Cal...
291,965
Super User 2025 Season 1
Martin Dráb
230,836
Most Valuable Professional
nmaenpaa
101,156