Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

Historical detailed trial balance missing reference

Posted on by Microsoft Employee

In Financial, Reports, Trial Balance option, the detailed trial balance has a reference field when the report is run for the current year but this same report drops this reference field when a historal/closed year is run.  How can we get the reference to stay on the report, no matter what time frame?

*This post is locked for comments

  • Suggested answer
    sueconrod Profile Picture
    sueconrod 335 on at
    Re: Historical detailed trial balance missing reference

    When you run the two reports you will note that they are not the same report.  There are actually two different reports being run.  You need to modify the second report and add the reference field.  The first report in your current year is the Detailed Trial Balance, and the 2nd report is the Historical Detailed Trial Balance.  You will need to drag reference onto the report fromt the Account Transaction Detail History table and then you will get what you are looking for.

    The reason there are two reports is the fact that the underlying detail is kept in two tables.  The GL20000 which contains your open year transacitons and the GL30000 which is all your history transactions.  Therefore, two different reports pointing at two different tables.

    Once you modify the report you are then going to have to go to the Alternate Modified Reports and give access to the users for the modified report (unless this is already a modified report).  If you are having issues with Report Writer, there is a manual in the printable manuals section under reporting>>Report writer that explains how to make changes.  If this is a shared dictionary for your reports do not make changes while everyone is in the system, as this could corrupt your report dictionary that is shared.  To check for this:  To to Tools>>Setup>>System and Edit Launch File,   Highlight Great Plains and see if you are looking at C:\Program Files\Microsoft Dynamic....\report.dic or if everyone is sharing a report.dic.

    If you are sharing, talk to your consulting company so they can help you make the changes.  If you don't check and corrupt the dicitonary you will be talking to them sooner that you planned.

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans