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)

GeneralJournalAccountEntry and DimensionFocusBalance for Atlas Report

(0) ShareShare
ReportReport
Posted on by Community Member

Hi All,

I am using Atlas to generate Trial Balance which need to include Journal Number, Credit, Debit, Invoice number, etc. in this report. As the verrsion of Atlas we are using doesn't support two Managed Columns which we can use show Credit and Debit in two separated Columns, I need to use DimensionFocusBalance table to do that. 

Does anyone know if the relations can be set up between GeneralJournalAccountEntry and DimensionFocusBalance? 

Thanks

*This post is locked for comments

I have the same question (0)
  • Verified answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 303,995 Super User 2026 Season 1 on at

    Hi Pin,

    There is no 1:1 relation between the GeneralJournalAccountEntry and DimensionFocusBalance. The DimensionFocusBalance has cumulated amounts per accounting date, main account and dimensions. Per Dimension set there are cumulated balances. This table has no reference to individual vouchers.

    So this table cannot be used.

    I have not used Atlas for years as AX 2012 has an own Excel add-in. Probably you can define some cell options in Excel to show or hide amounts based if it is debit or credit.

  • Community Member Profile Picture
    Community Member on at

    Thanks Andrew. Just wanted to confirm:)

  • Community Member Profile Picture
    Community Member on at

    Hello Pin.

    I suggest you download once of several trail balance examples found in our wiki site   support.globesoftware.com/.../default.asp   This will give you a place to start by reverse engineering the report provided.

    Should you have any questions then please email helpdesk@globesoftware.com.au

    Thank you

    Steve

  • Community Member Profile Picture
    Community Member on at

    HI Steve,

    Thanks for your reply. We have upgraded the Atlas to a new version which fixed the two calculated columns bug.

    there are more requirements than the standard one generated by Atlas. e.g. we group TB by Account,we want to show both Account ID and Account Name in the group header. However, it can only show the account ID if we group by Account ID in Atlas report.

    We have asked our partner to submit an enhancement requirement to Globesoftware and waiting for the feedback. Also, I have been told we need to liaise with our GlobeSoftware partner re any issue we are facing and not to liaise with GlobeSoftware Helpdesk directly.

    Thanks,

    Pin

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Joris dG Profile Picture

Joris dG 5

#2
Andrew Jones a1x Profile Picture

Andrew Jones a1x 2

#3
Basit Profile Picture

Basit 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans