Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Trial Balance data iss...
Microsoft Dynamics GP (Archived)

Trial Balance data issue when restricting accounts

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

Hello -

When the Trial Balance is printed using account restrictions, the upper account in the range is excluded. For example, if the report is run for 1000 - 1100, then no transactions for account 1100 are included in the output.

I've tested the Trial Balance in other company databases on the same server, and the Trial Balance will return transaction data for accounts in the upper account.

Is there a company preference or other report option that I can check that will resolve this issue?

We're on Dynamics GP 2010.

Thanks

 

*This post is locked for comments

  • Suggested answer
    Bill Campbell Profile Picture
    Bill Campbell 22,647 on at
    Re: Trial Balance data issue when restricting accounts

    After spending about an hour doing research I came across the suggestion to Rebuild the GL00105 table and do a complete Financial series check links.

    After following the instruction on how to 'Recreate the GL00105 Table' from Maintenance and droping the table and recreating the table as well as all the Stored Procs.  I then did the SQL Checklinks on ALL financial series tables.

    After this process was complete I then attempted to run the reports and to our great satisfaction the reports, with no changes, were generating the expected data.

    Hope this helps.

  • Bill Campbell Profile Picture
    Bill Campbell 22,647 on at
    Re: Trial Balance data issue when restricting accounts

    We are encountering the same issue - we have determined that we can 'fake' it for the system - if we want only to print 00-1000 then we do a range 00-1000 to 00-1001 where the 00-1001 account does not exist - at this time the Trial Balance Detail Multicurrency report then prints without issues.

    As soon as we then change this to 00-1000 as the first and last account, the report does not generate any data.

    If we switch from MLOGC to MINC the same report works without error, with any condition we enter in the layout.

    We have tested this with MODIFIED report on and OFF - we have tested as restricted user and as SA - we removed the REPORTS.DIC and created a new version - All with the same report results.

    What we can not figure out is how is it different from company 1 to company 2.  We have 16 different companies and it fails ONLY for this one company - not one other has the same issues.

    In this senario I read this as a DATA issue - but what or how is it so?  

    We need help.

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