Microsoft Dynamics AX (Archived)

Ultimate table for all AX transactions

(1) Share

Report

Posted on by Community Member

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

I have the same question (0)

All responses (12)

Answers (0)

Suggested answer

Faisal Fareed 10,796 User Group Leader on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Faisal,

After posted to CustTrans & VendTrans..., will those record post to GL, right? What is the final table for that?

Thank you.

Was this reply helpful? Yes No
Suggested answer

Faisal Fareed 10,796 User Group Leader on at

Like (0)

Report

LedgerJournalTable for header

LedgerJournalTrans for lines

Was this reply helpful? Yes No
Faisal Fareed 10,796 User Group Leader on at

Like (0)

Report

Is this what you were looking for to get use these tables ?

Was this reply helpful? Yes No
Suggested answer

syed baber 11,633 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
lally 8 on at

Like (0)

Report

Good question.

Can i know what is the link between cust trans/vend trans/item trans/bank trans to GeneralJournalAccountEntry ?

Was this reply helpful? Yes No
Suggested answer

Brandon Wiese 17,788 on at

Like (3)

Report

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

Was this reply helpful? Yes No
Suggested answer

syed baber 11,633 on at

Like (2)

Report

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.

Was this reply helpful? Yes No
Krishnendu 230 on at

Like (0)

Report

@Baber Owais : So how can I differentiate if the transaction is a GL transaction or AP/AR transaction. from GJAC or GAE table

Was this reply helpful? Yes No
syed baber 11,633 on at

Like (1)

Report

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.

Was this reply helpful? Yes No