Hello All,

I have a client running GL 9.0, when they go to print the detail listing they are receiving an error message that say:

Error Internal Error: field number our of range. occurred when attempting to append record to account trans temp.

I was there earlier that day and it was producing the report fine. I have tried all the variables in the report and nothing seems to change it.

Any ideas what this could be about??

Thanks,

Darcy Chretien

Can you get a screen shot of the report options screen to see what they have selected? Also, can they print the report from the sample data?

Hi, Darcy,

Would you also confirm exactly what version and release date of GL9 your client is using? You can obtain this information by selecting Help | About from the GL9 main menu. This information is oftn useful in helping us to troubleshoot an issue.

Thanks!

Hello,

To confirm, it is GL 9.0A(071102)
I will contact them to see if they can print the report using sample data.

Thanks,

Darcy Chretien

Hi, Darcy,

That was the original release of GL9.0A. There have been some service packs for the program since then and we have done additional work on the Detail Listing report specifically.

Is the client on an upgrades plan? They should be running a much newer release date of the program. They would be receiving notices of these via email and the service pack can be downloaded from our website. Extraction passwords are also available in the email they receive or to you as their dealer.

Please ensure they are running a current release and see if this resolves their problem. If not, please post again or you can email or call Support.

Hello Softrak,

Thank you for looking into that for me. It is a unique situation as we have just taken over this client, so I was unaware that they weren't updated, but I certainly will make sure that they will be now.

Thanks again!

Darcy Chretien

Softrak,

I was given incorrect information yesterday regarding their version number, it is actually the current version of GL 9.0(080704). I'm on site now and am still generating that error. I also have Error 120 when trying to produce a Trial Balance.
(Lookup item not found::Formulas.Name:=bReportInactiveAcctTotals.

This same error occurs when I try to print the reports from the sample data.

Thanks in advance,

Darcy Chretien

Hi, Darcy,

It's possible that something is out of sync with the reports being run and the QRT tables or that a core report has been modified.

Questions:

(1) In their x:\Softrak\Ledger folder, is there another folder called ModRP? If so, the report may need to be redone. ModRPs are run instead of the StandardRP of the same name and cannot be automatically updated with a service pack or upgrade.

(2) If there is no ModRP, please check in the StandardRP folder for the following files and their dates:

Allistc_mc_v2 - 3/06/2008
Allistc_v2 - 3/06/2008
Alliste_mc_v2 - 3/07/2008
Alliste_v2 - 3/06/3008
Allists_mc_v2 - 3/07/2008
Allists_v2 - 3/06/2008

and the 3 Trial Balance report files:

Altrial* all dated 4/25/2008.

(3) Please also check these files in their \QRASP folder:

QRTALZ90.qrt 3/06/2008
QRTALW90.qrt 3/19/2008

(4) Or, it might just be easiest to reinstall the module. Please call if you have a question regarding this.

Softrak,


There is no ModRP file.

Thank you for the tip on that one. Sure enough all of the files listed were lasted modified between 18/10/07 and 24/10/07.

The QRASP files are at 19/09/07 and 28/09/07 respectively.

What is the best route to take on this one?? and what could be the cause of this case???

Thanks a bunch,

Darcy Chretien

Hello,

I did a reinstall of the module, the report files look good now, however when I go to print a detail listing now, The report comes up and then automatically closes before it fully shows up. However other reports are printing fine.

Thanks,

Darcy Chretien