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) / GeneralJournalAccountE...
Microsoft Dynamics AX (Archived)
Unanswered

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

  • Rustem Galiamov Profile Picture
    Rustem Galiamov 8,072 on at

    Hi Chaidir Ali Assegaf!

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

  • Chaidir Ali Assegaf Profile Picture
    Chaidir Ali Assegaf 202 on at

    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

    "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

    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

  • nmaenpaa Profile Picture
    nmaenpaa 101,172 Moderator on at

    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.

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the August Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans