Historical Aged trial balance report error

[bawa63]

I have a terminal server running a client version of GP 8.0. I also have another standalone machine running GP8.0. Whenever a user tried to print the Historical Aged trial balance report, it gives an error " General Network Error. Chek your network documentation". When we click ok it gives another message saying " the stored procedure pmHistoricalAgedTrialBalance returned the following results: DBMS: 11, Great Plains: 0"

It prints fine from the stanalone workstation with the same user login.
I tried recreating the reports dictionary on terminal server and importing modified reports from the workstation. That didn't work. Please help. Thanks

 

[VictoriaYudin]

Is it just this one report not working on the Terminal Server or all reports? Also, have you tried it when logged into the Terminal Server as a domain admin and into GP as 'sa' to rule out permissions/security issues?

 

[bawa63]

Yes it is only this report. I have tried logging in as domain admin and as sa in GP. Still the same errors

 

[VictoriaYudin]

Is this a modified report? It sounds like it may be corrupted. Are you sure you're printing the same exact one as the one on the standalone machine?

 

[bawa63]

It is not a modified report. Yes i'm printing the exact same one as the standalone system

 

[VictoriaYudin]

If it's not a modified report, what happens if you just point the GP install on the TS to a local reports.dic in the same location where the GP install is?

 

[bawa63]

I did not understand that post of yours. Please be more specific. Thanks for the help.

 

[VictoriaYudin]

One other question - what printer is set as your default printer in GP on the TS? Maybe that's what is causing the error? It's not a typical GP error....

Here is what I meant by the prior post:

Make sure to back up your reports.dic (just in case). Make sure no other users are in GP on the Terminal Server. In GP on the Terminal Server go to Tools > Setup > System > Edit Launch File. Click on Great Plains under Product Name and change the path for the Reports entry at the bottom of the screen under Dictionary Locations to a local path on the TS. Log out of GP and log back in. Try running the report.

 

[bawa63]

How do you check default printer in GP. i think the default printer in GP is the user's (on TS) default printer. correct me if I'm wrong.

I will try editing the launch file once the users go out of the system at the end of the day and keep you posted

 

[VictoriaYudin]

Yes, it should use the default Windows printer from the user's profile. However, if there is a problem with that printer or the TS doesn't have that printer driver, it might error out when it tried to use a printer driver and doesn't find one....just throwing anything that comes to mind out there.....

 

[bawa63]

The printers are working and drivers are available for all printers installed there as it prints from other applications like word and excel. It gives the same error even when trying to print to screen.

 

[VictoriaYudin]

I believe that it may use the printer driver even though it's not printing to the printer....not 100% sure, but pretty sure....

By the way, did this report ever work on the TS?

 

[bawa63]

Not since we upgraded from V6.0 to V8.0 some time back