web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / How to map Ledger, Jou...
Microsoft Dynamics AX (Archived)

How to map Ledger, Journal and main account table ?

(0) ShareShare
ReportReport
Posted on by SelvakumarSubramaniam 4

Hi,

I am not an ERP guys, but I have AX 2012 data, now I need to find out what are Journals posted and ledger account where it is get posted?

Please help me with relationship.

I have below tables in hand:-

LEDGERJOURNALTABLE,LEDGERJOURNALTRANS,MAINACCOUNT,GENERALJOURNALACCOUNTENTRY

,GENERALJOURNALENTRY

Please guide me

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Chaitanya Golla Profile Picture
    Chaitanya Golla 17,225 on at

    Hi,

    Please use the below job/code to define relations between tables LedgerJournalTable, LedgerJournalTrans, GeneralJournalEntry and GeneralJournalAccountEntry.

    static void AXC_GeneralJournalEntry(Args _args)
{
    GeneralJournalEntry                 generalJournalEntry;
    GeneralJournalAccountEntry          journalAccountEntry;
    LedgerJournalTable                 ledgerJournalTable;
    LedgerJournalTrans                 ledgerJournalTrans;
    SubledgerVoucherGeneralJournalEntry subledgerVoucherGeneralJournalEntry;
    DataAreaId company;

    company = curext();

    select journalAccountEntry // Can include postingtype to further filter the data
        join generalJournalEntry
            where ((generalJournalEntry.RecId == journalAccountEntry.GeneralJournalEntry)
               && (generalJournalEntry.SubledgerVoucherDataAreaId == company)) // current company
            join Voucher, AccountingDate from subledgerVoucherGeneralJournalEntry
            where (subledgerVoucherGeneralJournalEntry.GeneralJournalEntry == generalJournalEntry.RecId)
                join ledgerJournalTrans
                    where ledgerJournalTrans.Voucher == subledgerVoucherGeneralJournalEntry.Voucher
                    join ledgerJournalTable
                        where ledgerJournalTable.JournalNum == ledgerJournalTrans.JournalNum;


}


     

  • SelvakumarSubramaniam Profile Picture
    SelvakumarSubramaniam 4 on at

    I dont have SubledgerVoucherGeneralJournalEntry table. what shall i do ? Please suggest me any other option ?

  • Suggested answer
    Chaitanya Golla Profile Picture
    Chaitanya Golla 17,225 on at

    Hi,

    I am bit confused when you say you don't have subLedgerVoucherGeneralJournalEntry table as its a standard table. Anyway please try the following code, here we are using table LedgerEntryJournal.

    static void AXC_GeneralJournalEnty1(Args _args)
{
    GeneralJournalEntry                 generalJournalEntry;
    GeneralJournalAccountEntry          journalAccountEntry;
    LedgerJournalTable                 ledgerJournalTable;
    LedgerJournalTrans                 ledgerJournalTrans;
    LedgerEntryJournal ledgerEntryJournal;
    DataAreaId company;

    company = curext();

    select journalAccountEntry // Can include postingtype to further filter the data
        join generalJournalEntry
            where generalJournalEntry.RecId == journalAccountEntry.GeneralJournalEntry
            join ledgerEntryJournal
            where generalJournalEntry.LedgerEntryJournal == ledgerEntryJournal.RecId
            join ledgerJournalTable
            where //ledgerEntryJournal.LedgerJournalTableDataAreaId == LedgerJournalTable.dataAreaId
                ledgerEntryJournal.JournalNumber == LedgerJournalTable.JournalNum
               && ledgerEntryJournal.LedgerJournalTableDataAreaId == company
                join ledgerJournalTrans
                        where ledgerJournalTable.JournalNum == ledgerJournalTrans.JournalNum;
}


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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
CP04-islander Profile Picture

CP04-islander 39

#2
Michel ROY Profile Picture

Michel ROY 14

#3
imran ul haq Profile Picture

imran ul haq 8

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans