web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / GP 2018 Trial Balance ...
Finance | Project Operations, Human Resources, ...
Suggested Answer

GP 2018 Trial Balance report not showing any data

(2) ShareShare
ReportReport
Posted on by CU15051155-0 262
Hi
 
I upgraded for one of my client from GP 2015 to GP 18.7 (Latest version). After the upgrade, when I ran the trial balance report, report is not showing any data. Data is available in the tables and in Inquiry of GL i can see the data in GP.
 
I am not sure what is wrong here, Can anyone help me in this issue? 
 
Regards,
Durai Murugan R
Categories:
Microsoft Dynamics GP
I have the same question (0)
  • Suggested answer
    Terry R Heley Profile Picture
    Terry R Heley Microsoft Employee on at

    Hello Durai, that is a big upgrade / jump in versions, congratulations to you on getting upgraded to a recent version.

    If it is only the report that seems to be the problem, I would start with a damaged forms or report.dic with that large of an upgrade and change in product, we should recreate them or try to print original and rule that out.

    Here is a KB on how to do this if you are unfamiliar with the process.
    850465 How to re-create the Reports.dic file in Microsoft Dynamics GP
    https://support.microsoft.com/en-US/help/850465

    951767 How to re-create the Forms.dic file in Microsoft Dynamics GP
    https://support.microsoft.com/en-US/help/951767

    Terry Heley | Sr. Escalation Engineer | Microsoft Dynamics
    701-492-6376 (o) | 701-412-5619 (m) | theley@microsoft.com 
     

  • CU15051155-0 Profile Picture
    CU15051155-0 262 on at
    Hi Terry
     
    I tried recreating the Forms.dic and reports.dic but it didnt solve the issue.
     
    I would like to know whether I am missing anything.
     
    Regards,
    Durai Murugan R
  • BJ-09051414-0 Profile Picture
    BJ-09051414-0 346 on at
    Hello,
     
    I would like to get a little more information from you on this:
     
    1. Are you running the Detailed Version or the Summary version of the report?
    2. When you say you can see the data is available in the tables and in the inquiry window, what tables are you looking at and what inquiry windows?
      1. There are two type of reports and inquiry window, Detail and Summary.
      2. Detail shows the actual transactions and is looking at the GL20000 and GL30000 tables.
      3. Summary is a running total of the detail values and is looking at the GL10110 and GL10110 table.
      4. Summary can exist if no detail.
    3. Next, I would ask, was there any problems during the upgrade?
      1. If yes, did you restore, correct the errors and then reclose?
    4. Report Options can get corrupted at time, have you tried a new Report Option?
    5. What report Restrictions are you using?
      1. Could possibly be an option selection that is causing it to not return any data?
    6. If you post a new Transaction, does it show on the Report?
    7. Can you see the data if you look at the modules Smartlist that you are running the report for?
    8. Is the report version you are printing modified?
      1. If yes, does the same thing happen with the core report?
    9. Is the Trial Balance report the only one having a problem?
    10. Did you do the Jumps correctly to 18.7 or did you go from 2015 to 18.5 directly?
    I hope this helps!
     
    Brandon!
     
    Enavate
     
  • CU15051155-0 Profile Picture
    CU15051155-0 262 on at
    Hi Brandon
     
    Below are my responses.
     
    1. Are you running the Detailed Version or the Summary version of the report? - Both
    2. When you say you can see the data is available in the tables and in the inquiry window, what tables are you looking at and what inquiry windows?
      1. There are two type of reports and inquiry window, Detail and Summary. - Detail and summary window
      2. Detail shows the actual transactions and is looking at the GL20000 and GL30000 tables.
      3. Summary is a running total of the detail values and is looking at the GL10110 and GL10110 table.
      4. Summary can exist if no detail.
    3. Next, I would ask, was there any problems during the upgrade? - No
      1. If yes, did you restore, correct the errors and then reclose?
    4. Report Options can get corrupted at time, have you tried a new Report Option? - I created a new report option
    5. What report Restrictions are you using? - I only use to include posting account and the year.
      1. Could possibly be an option selection that is causing it to not return any data?
    6. If you post a new Transaction, does it show on the Report? - Not done.
    7. Can you see the data if you look at the modules Smartlist that you are running the report for? - I can see value in the smartlist.
    8. Is the report version you are printing modified? - standard report
      1. If yes, does the same thing happen with the core report?
    9. Is the Trial Balance report the only one having a problem? - GL, AR and AP
    10. Did you do the Jumps correctly to 18.7 or did you go from 2015 to 18.5 directly? - GP 2015 ->GP 2018 RTM - > 18.3 -> 18.5 -> 18.7
     
    I hope this helps.
     
    Regards,
    Durai Murugan R
  • BJ-09051414-0 Profile Picture
    BJ-09051414-0 346 on at
    Hello,
     
    I would suggest the below. It might look like the same steps provided but the order can matter for issues with dictionaries.
     
    1. Export all Forms and Reports Customizations.
      1. Dynamics GP | Tools | Customization Maintenance.
      2. Select all Items.
      3. Click Export.
      4. Choose a name and locations.
      5. Click Save.
    2. Close GP and have everyone log out of all GP instances if these dictionaries are shared between users.
    3. Rename the forms and reports.dic to be .old.
    4. Go through the steps below to synchronize dynamics.dic to the GP Client.
      1. Synchronize the modified forms and reports by using Great Plains Utilities. To do it, follow these steps:
        1. Open the Dex.ini file.
          1. This is located in the data folder in the GP Code Folder.
        2. Located the SYNCHRONIZATION line in the dex.ini.
          1. Set this to TRUE and save the changes.
            1. You might need to save it as a new file to desktop depending on your permissions to change files in the current location. Then you can copy and paste to the location and overwrite the current file.
        3. Start Great Plains Utilities. To do it, follow the appropriate step:
        4. In Microsoft Dynamics GP 10.0 and higher versions, select Start, point to All Programs, point to Microsoft Dynamics, point to GP 10.0 (or appropriate version), and then select Utilities.
        5. In Microsoft Dynamics GP 9.0, select Start, point to All Programs, point to Microsoft Dynamics, point to GP 9.0, and then select Utilities.
        6. In Microsoft Business Solutions - Great Plains 8.0, select Start, point to All Programs, point to Microsoft Business Solutions, point to Great Plains, and then select Great Plains Utilities.
        7. In the Additional Tasks window, select Synchronize forms and reports dictionaries, and then select Process.
        8. Locate the Dynamics.set file on the client computer, and then select Next.
    5. Start GP.
      1. Test if the reports now product data.
        1. If using modified versions of the report, you will need to set security back to the core reports for testing as the modified reports do not exist as we have not imported the package file. 
      2. If data now prints, import the Package File we created in step one.
      3. If any changes to security were made to set to use the core report, change the security back to the modified version of the report is used.
      4. Test if the modified version of the report prints data.
        1. If this does not print but the original version prints, there is something wrong with the modified reports. Perhaps they never got upgraded?
    I hope this helps!
     
    Thank you!

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Martin Dráb Profile Picture

Martin Dráb 565 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 450 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 250 User Group Leader

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans