Account numbers couldn't be displayed completely in the GP reports

(0) Share

Report

Posted on by Yash.V

220

Hi All,

We are facing a critical live issue.

Actually GP reports are incompletely displaying the account numbers for all the users (except sa).

For sa, the Reports.dic is in the local machine. For the users, it is in the shared path. We have tried to configure sa's dic path to this shared folder, and generated the reports. It was working fine. But users are still facing the issue.

Will importing reports as a package help? Or can we try to replace the Reports.dic in shared folder with the latest file from local machine (sa's)?

Any advice on this would be highly appreciated. Many thanks in advance.

Categories:

Microsoft Dynamics GP

I have the same question (0)

All responses (6)

Answers (2)

Sort by

Richard Wheeler 75,852 Moderator on at

Like (1)

Report
Copy link

Link copied!

Under Alternate Forms and Reports make sure everyone is using the same version of the report.

Tools->Setup->System->Alternate Forms and Reports

Was this reply helpful? Yes No
Verified answer

Cheryl Waswick Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi,

Richard makes a good point if you pointed sa to the same dictionary as the users are pointing to.

Typically, recreating both the forms.dic and reports.dic resolves this.

• Below is a link to KB Article 850465 How to re-create the Reports.dic file in Microsoft Dynamics GP:

support.microsoft.com/.../850465

• Here is a link to KB “How to re-create the Forms.dic file in Microsoft Dynamics GP”:

support.microsoft.com/.../951767

Thanks

Cheryl W.

Microsoft GP Support

Was this reply helpful? Yes No
Beat Bucher GP Gee... 28,061 Moderator on at

Like (0)

Report
Copy link

Link copied!

By any chances, could you check if Account Level Security is enabled in GP ?

Administration >> Setup >> Company >> Company

verify if the checkbox next to Account Security is enabled.

Was this reply helpful? Yes No
Yash.V 220 on at

Like (0)

Report
Copy link

Link copied!

Thanks for all the suggestions.

I've checked that all the users including sa use the same version of reports.

And the checkbox next to Account Security is unchecked. Only the checkbox Security is checked. Will that be an issue here?

I shall try to re-create the Reports.Dic and Forms.Dic now.

Was this reply helpful? Yes No
Verified answer

Richard Wheeler 75,852 Moderator on at

Like (0)

Report
Copy link

Link copied!

Don't forgot the most basic check of all. Now that you are sure all computers and users are using the same dictionary files, go to your DEX.INI file and change SYNCHRONIZE=FALSE to SYNCHRONIZE=TRUE. This will synchronize your DYNAMICS.DIC file with the account structure in the database. When you launch GP it will force you to run GP Utilities. As it does that pay close attention to the screen. You must see a splash screen flicker by saying synchronizing to account framework.

Was this reply helpful? Yes No
Suggested answer

Beat Bucher GP Gee... 28,061 Moderator on at

Like (0)

Report
Copy link

Link copied!

good point Richard..

if ALS is not enabled, you should be all good.. The 'Use security' is OK, and you want this checked, as otherwise you would operate GP without any security access to the various forms & reports.

My best guess would be that the 'sa' user has access to a modified version of the report, whereas regular users don't have.

Compare in the User Security form what 'Alternate Forms & Reports' Role the 'sa' is assigned to and check if other users are assigned the same.. You can have as many alternate roles as you want, the important thing is to be consistent and make sure the users have access to the proper custom forms & reports.

Was this reply helpful? Yes No