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 / Finance forum / Purpose and working of...
Finance forum

Purpose and working of tables GeneralJournalEntry and GeneralJournalAccountEntry

(0) ShareShare
ReportReport
Posted on by Pete Alberts 3,542

Hi all

I am working on cash flow. I have spent a lifetime trying to understand the existing code (I don't like extending things I don't fully understand).

The beginning balances as of today for the cash flow forecasting is generated by a sum from data retrieved from GeneralJournalEntry and GeneralJournalAccountEntry (class LedgerCovTotal line 446). What type of data are stored in these tables? The Developer Documentation is not very helpful.

I asked a consultant (who is CA) and he didn't even know they exist. (Then again he hasn't been working in the financial sector for quite a while).

Thanks for your attention

Categories:
Cash flow
Financial Management
Development / Customization / SDK
  • Pete Alberts Profile Picture
    Pete Alberts 3,542 on at
    RE: Purpose and working of tables GeneralJournalEntry and GeneralJournalAccountEntry

    Thanks!

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 293,278 Super User 2025 Season 1 on at
    RE: Purpose and working of tables GeneralJournalEntry and GeneralJournalAccountEntry

    Hi Pete,

    There are some whitepapers available on the financial framework: docs.microsoft.com/.../code-upgrade-white-papers

    Some code patterns are implemented different in Dynamics 365, but still you can learn a lot by reading them.

  • Pete Alberts Profile Picture
    Pete Alberts 3,542 on at
    RE: Purpose and working of tables GeneralJournalEntry and GeneralJournalAccountEntry

    Thanks Satish, Ajit and André. Much appreciated. 

    I realise I am in dire need of some financial table structure knowledge. Till now I have been working on ISV solutions like HR, OHS, GRC and other modules that generally don't have anything to do with AX financials.

    Any more material (on financial table structure basics) will be appreciated.

    And then if you might take a look at another post of mine: https://community.dynamics.com/365/financeandoperations/f/dynamics-365-for-finance-and-operations-forum/365590/cash-flow-tables-ledgercov-and-ledgercovdocument I guess these tables aren't so general - hence I didn't get any response. But if I could ask some more of your time - please take a quick look. Some insight in that area will be invaluable 

  • Verified answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 293,278 Super User 2025 Season 1 on at
    RE: Purpose and working of tables GeneralJournalEntry and GeneralJournalAccountEntry

    Hi Pete,

    Like mentioned above, these tables are the ledger transactions. The Journal entry has general information about the voucher the journal account entry has details about the main account, dimensions and the amount.

    Note that these tables are global. The field Ledger holds a record ID of the Ledger record which is the identification for the legal entity.

  • Verified answer
    Ajit Profile Picture
    Ajit 8,755 on at
    RE: Purpose and working of tables GeneralJournalEntry and GeneralJournalAccountEntry

    Every single ledger posting goes to GeneralJournalAccountEntry table. And to get voucher details, you can joun GeneralJournalEntry table. There is an standard entity 'GeneralJournalAccountyEntryEntity', you can refer for joins and all.

  • Verified answer
    Satish Panwar Profile Picture
    Satish Panwar 14,651 Moderator on at
    RE: Purpose and working of tables GeneralJournalEntry and GeneralJournalAccountEntry

    Hi Pete,

    Take a look at detailed example below that provides good explanation. You can further clarify understanding by posting similar entry in the system.

    community.dynamics.com/.../ledgerentryjournal-generaljournalentry-and-generaljournalaccountentry-in-dynamics-ax-2012

    Thanks,

    Satish Panwar

    Please take time to click yes against the answer that help guide you in right direction.

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

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 293,278 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,983 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans