Account number prints incorrecly on all GL reports

(0) Share

Report

Posted on by Joanne Seymour

235

The GL account number string has started printing incorrectly on all GL reports, those that are modied and those that aren't. This has happened on two separate installations. In one case the account number is truncated and a box prints in one segment. In the other the segments are just truncated. There are several KB articles that sound similar, as well as at least one post in this forum, but none have helped. This is happening on a version 10 installation. The following have been tried so far without success:

Rename reports.dic and run standard reports with no modified reports available
Export all modified reports, create new reports dictionary by importing report packages
Resynchronize dynamics.dic and reports and forms
Verify that the Dynamics ODBC is set up with "Use regional settings when outputting currency, numbers, dates and times" unchecked.
Verify that the number of decimal places for all posting accounts is set to zero in GL00100
Delete GL00105 and run check links on Account Master
Reboot SQL server

The only thing that has worked is modifying reports and changing them to use Account Number String field instead of Account Number field. The field is coming from the General Ledger Trial Balance Temporary table, which is a true temporary table and so not accessible. Rebooting the SQL server did not resolve the issue. Needless to say, modifying every single GL report is not a viable solution. Account numbers printing on Payables reports print correctly.

This is happening on a terminal server as well as on individual workstations and happens in all companies. Last week a new printer driver was installed for a network printer. There were problems logging in, which were finally tracked down to a setup problem with Named Printers. That has been resolved, and as mentioned above, the reports dictionary has been recreated.

I'm running out of ideas. Any suggestions will be appreciated. Thanks!

*This post is locked for comments

I have the same question (0)

All responses (15)

Answers (3)

Richard Wheeler 75,848 Moderator on at

Like (0)

Report

Re: Account number prints incorrecly on all GL reports

If you print to the screen or to an Adobe print driver are the accounts correct? Has this report been modified? If so, if you revert back to the original version do they print correctly? Have you tried printing to a different printer with a different print driver?

Was this reply helpful? Yes No
Joanne Seymour 235 on at

Like (0)

Report

Re: Account number prints incorrecly on all GL reports

I have been printing to the screen. I have very limited printer access as I am doing a Webex connection and then to a remote connection. I've tried both of the available printers. I have the problem with both modified and non-modified reports. Reverting the reports does not fix them, unfortunately.

Thanks for your suggestions.

Was this reply helpful? Yes No
Richard Wheeler 75,848 Moderator on at

Like (0)

Report

Re: Account number prints incorrecly on all GL reports

If you go to Tools->Setup->Company->Account Format try adjusting the Display Width for the columns. YOu probably have them all at Standard right now.

Was this reply helpful? Yes No
Joanne Seymour 235 on at

Like (0)

Report

Re: Account number prints incorrecly on all GL reports

A new wrinkle was added to this. It appears that a new form with vba code was imported into the forms dictionary in the same time frame. When that is removed the account number prints correctly on reports.

Was this reply helpful? Yes No
Richard Wheeler 75,848 Moderator on at

Like (0)

Report

Re: Account number prints incorrecly on all GL reports

Do I dare ask what this VBA code does? Is it related to the GL reports?

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

Re: Account number prints incorrecly on all GL reports

I agree with Richard, do you know what that VBA code does?, but I will go 1 step further, you have GP Database Maintenance, it wouldn't hurt if you recreate the views, stored procs and triggers using it, it might be that by refreshing the internal stored procs could lead you to a solution.

Give it a try, just remember to run the GRANT.SQL script after just in case

Was this reply helpful? Yes No
Joanne Seymour 235 on at

Like (0)

Report

Re: Account number prints incorrecly on all GL reports

Yes, the vba code calls a separate document imaging product that they use. I'm not certain which windows they've attached it to. We're holding off doing anything until next week as month end close is in process. My thought is to create a new forms dictionary without the vba code and see if that fixes the problem and if so, try reimporting the forms. If that doesn't work I will take your suggestion of recreating views, stored procs, etc.

Thanks Richard and Francisco for your suggestions. I'll let you know how it goes next week.

Was this reply helpful? Yes No
Verified answer

Josh Parker 30 on at

Like (2)

Report

Re: Account number prints incorrecly on all GL reports

Hi,

I am very confident it is your forms dictionary. Recreate it and you should be fine. Go to Customization Maintenance export all the modified forms to a package. Rename the forms.dic (no one can be in). Import back in your package of modificaitons. I have had the exact same situation and that was it.

Josh

Was this reply helpful? Yes No
Michael Howard 10 on at

Like (0)

Report

Re: Account number prints incorrecly on all GL reports

I had the same problem and this solution worked for me.

Was this reply helpful? Yes No
Linda Brock 18 on at

Like (0)

Report

RE: Account number prints incorrecly on all GL reports

This solution also worked for me.

Was this reply helpful? Yes No