Skip to main content

Notifications

Microsoft Dynamics AX (Archived)

Ultimate table for all AX transactions

(1) ShareShare
ReportReport
Posted on by Microsoft Employee

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

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Ultimate table for all AX transactions

    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 

  • RE: Ultimate table for all AX transactions

    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??

        

  • syed baber Profile Picture
    syed baber 11,627 on at
    RE: Ultimate table for all AX transactions

    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.

  • Krishnendu Profile Picture
    Krishnendu 230 on at
    RE: Ultimate table for all AX transactions

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

  • Suggested answer
    syed baber Profile Picture
    syed baber 11,627 on at
    RE: Ultimate table for all AX transactions

    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.

  • Suggested answer
    Brandon Wiese Profile Picture
    Brandon Wiese 17,788 on at
    RE: Ultimate table for all AX transactions

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

  • lally Profile Picture
    lally on at
    RE: Ultimate table for all AX transactions

    Good question.

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

  • Suggested answer
    syed baber Profile Picture
    syed baber 11,627 on at
    RE: Ultimate table for all AX transactions

    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.

  • Faisal Fareed Profile Picture
    Faisal Fareed 10,794 User Group Leader on at
    RE: Ultimate table for all AX transactions

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

  • Suggested answer
    Faisal Fareed Profile Picture
    Faisal Fareed 10,794 User Group Leader on at
    RE: Ultimate table for all AX transactions

    LedgerJournalTable for header

    LedgerJournalTrans for lines

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.

Helpful resources

Quick Links

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,965 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,836 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans