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

Notifications

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#1
Priya_K Profile Picture

Priya_K 4

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans