Data is incorrect in FRx reports

Entry type: Informational

Product: FRx

Application: FRx Desktop

Version reported: All

Subject:

Data is incorrect in FRx reports.

Possible resolution:

If changes have been made to the General Ledger (new accounts added, etc.) run 'Build Local GL Indexes' in FRx.

FRx for Sage MAS 90, 200, and 500:

Rebuild the GL Index:

1. From within FRx, select the Admin menu.
2. Select 'Build Local GL Index'. Click 'Yes' at the message, "Building the GL index will take time.  Do you want to build the GL index for FW now?"

Notes:

• Building the local GL index may take time. Having all users exit GL for the company code to speed up the process.
• If selecting Build Local GL Index does not reflect the GL account changes, exit FRx and delete the .G32 files. 

Delete the G32 file from the SysData folder and let the system rebuild it on the next login to FRx.

1. Have all users exit FRx.
2. In Windows Explorer locate the ..\SysData folder.
   Note: Default path for the SysData is ..\Program Files\FRx Reporting\SysData on the local drive.
3. Open the folder and delete any file with the .G32 extension.  This file is recreated on the next FRx logon.

FRx for Sage PFW:

1. From within FRx, select the Admin menu.
2. Select 'Build Local GL Index'. Select 'Yes' at the message "Building the GL index will take time.  Do you want to build the GL index for FW now?"
   Note: Building the local GL index may take time. Having all users exit GL for the company code may speed up the process.

Note: If selecting Build Local GL Index does not reflect the GL account changes, exit FRx and delete the .G32 files. 

1. Log on to Sage PFW as the Admin user.

2. Select View / System Configuration / General Ledger Interface in all of the Sub modules that interface with General Ledger and verify that Sage PFW is using the Direct method under the Post Distribution Method.

3. From Windows Explorer, browse to the ..\Platinum\"Company_Key" folder (where "Company_Key" is the name of the company folder)
4. Search for and rename any xxNLX*.* files.
5. Re-run the Print and Post Distribution to GL.
6. Have all users exit FRx.
7. In Windows Explorer locate the ..\SysData folder.
8. Delete any file with the extension .G32.  This file is recreated on the next FRx logon.

If the issue still occurs, generate the FRx report to the Financial and Account level. Compare account balances from the FRx report to the Trial Balance report in the accounting software to determine which account is incorrect, and contact Customer Support for assistance.