Skip to main content

Notifications

Announcements

Check out the New Agent Creator Community
Announcing new navigation menus and the Engage with the Community forum!
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / GeneralJournalAccountE...
Microsoft Dynamics AX (Archived)

GeneralJournalAccountEntry Table Relation With Other Trans Table

(0) ShareShare
ReportReport
Posted on by Chaidir Ali Assegaf 202

Dear Experts,

I'm a junior developer of Dynamics AX 2012 R3 CU 9.

I want to ask something related to GeneralJournalAccountEntry Table. as far as I know, GeneralJournalAccountEntry is the table that store posted transaction into it. it's purpose is to calculate trial balance based on the posted transaction that stored in it.

GeneralJournalAccountEntry only store information that related to the trial balance only. it doesn't store any details related to the original transaction. to find it's original transaction, i have to find the relation between GeneralJournalAccountEntry table with another table (usually tables with postfix -Trans). And the problem is, it's hard to find all the tables that related to GeneralJournalAccountEntry. because there's no direct relationship on it. as an example, GeneralJournalAccountEntry and CustTrans is related, CustTrans Table store transactions about customer invoice. and GeneralJournalAccountEntry stores it's nominal value and to be calculated later in trial balance. To join those two tables, i have to join them using field GeneralJournalEntry.SubLedgerVoucher (GeneralJournalAccountEntry Header Table) with CustTrans.Voucher.

The final thing is, because it's hard to find all tables that related to GeneralJournalAccountEntry.
And the question is, is there exists another way to make it easier to find all of it?

The tables that i found that related to GJAE is :

  1. VendTrans
  2. TaxTrans
  3. BankAccountTrans
  4. LedgerJournalTrans
  5. AssetTrans

Thanks for your attention,

Best Regards,
Chaidir Ali Assegaf

*This post is locked for comments

  • nmaenpaa Profile Picture
    nmaenpaa 101,158 Moderator on at
    RE: GeneralJournalAccountEntry Table Relation With Other Trans Table

    You should definetely not change the posted transactions. First of all it's very easy to corrupt your data, and second you should not change the historical financial records.

    Please check with your finance, audit and legal experts what kind of regulations you have in your company and country.

  • Chaidir Ali Assegaf Profile Picture
    Chaidir Ali Assegaf 202 on at
    RE: GeneralJournalAccountEntry Table Relation With Other Trans Table

    Hi Crispin John Augustine,

    Thanks for your reply, I want to explain this issue further down to the root of the problem.

    this issue comes down when we want to change the account structure that used by system in the middle of the year. because we're changing it, we had to update all financial dimension (LedgerDimension Field) of those transaction inside GeneralJournalAccountEntry too and make sure that new transaction is have the same financial dimension with the old one. if we didn't do that, the report from management reporter would be a mess, because the report is generated with parameter based on the financial dimension, e.g. Department, BusinessType, LegalEntity, etc.

    updating the financial dimension in GeneralJournalAccountEntry alone is enough to make the Management Reporter works properly. but, what about the original transaction that related to it? we don't know the side effect if we don't update the original transaction. so we don't want to take that risk.

    I tried to track down all the transaction with old dimension, let's say that i have found 800 transaction that still using old dimension inside GeneralJournalEntry. 100 from CustTrans, 200 from VendTrans 200 from BankAccountTrans, and 100 from AssetTrans, there's 200 transaction left to find. i don't know how to find those transaction left if i don't know the table. so, is there a way to know it? thanks for your kindness.

    Best Regards,

    Chaidir Ali Assegaf

  • Rustem Galiamov Profile Picture
    Rustem Galiamov 8,072 on at
    RE: GeneralJournalAccountEntry Table Relation With Other Trans Table

    "I think, the post shared by Rustem gives you the Basic rule with Relations with GeneralJournalAccountEntry." - exactly.

  • Chaidir Ali Assegaf Profile Picture
    Chaidir Ali Assegaf 202 on at
    RE: GeneralJournalAccountEntry Table Relation With Other Trans Table

    Hi Rustem Galiamov,

    Thanks for your answer, I have read the post inside the link, in that post, it only covers relationship between LedgerJournalTrans and GeneralJournalAccountEntry.

    what I want to do is, i want to find the original transaction for all those transaction inside GeneralJournalAccountEntry, which is split into different tables (LedgerJournalTrans is one of those tables).

  • Rustem Galiamov Profile Picture
    Rustem Galiamov 8,072 on at
    RE: GeneralJournalAccountEntry Table Relation With Other Trans Table

    Hi Chaidir Ali Assegaf!

    Check this link as example community.dynamics.com/.../207784

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

News and Announcements

Check out the New Agent Creator Community
Announcing new navigation menus and the Engage with the Community forum!

Quick Links

Jainam Kothari – Community Spotlight

We are honored to recognize Jainam Kothari as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Mohamed Amine Mahmoudi Profile Picture

Mohamed Amine Mahmoudi 100 Super User 2025 Season 1

#2
Community Member Profile Picture

Community Member 50

#3
shanawaz davood basha Profile Picture

shanawaz davood basha 6

Last month Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans