Purpose and working of tables GeneralJournalEntry and GeneralJournalAccountEntry

(0) Share

Report

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

I have the same question (0)

All responses (6)

Answers (3)

Verified answer

Satish Panwar 14,671 Moderator on at

Like (1)

Report

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.

Was this reply helpful? Yes No
Verified answer

Ajit 8,755 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Verified answer

André Arnaud de Cal... 301,075 Super User 2025 Season 2 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Pete Alberts 3,542 on at

Like (0)

Report

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

Was this reply helpful? Yes No
André Arnaud de Cal... 301,075 Super User 2025 Season 2 on at

Like (1)

Report

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.

Was this reply helpful? Yes No
Pete Alberts 3,542 on at

Like (0)

Report

Thanks!

Was this reply helpful? Yes No