FRx report does not match Sage PFW data

Entry Type: Informational

Product: FRx

Application: FRx Desktop

Version Reported: 6.0, 6.5

Subject:
FRx report does not match Sage PFW data

Possible Resolution:

Note: Support for FRx has changed. Please see the following notice:

FRx Updates Notice By Microsoft

• Verify the correct account is listed in the row format and the correct report date is listed in the catalog.
• In FRx, select  File / Compact FRx Database / Current Spec Set Database.  Click 'OK' at the prompt, "Do you wish to Compact the Database Current Spec Set?"
• Select Admin / Build Local GL Index.  Click 'Yes' at the prompt, "Building the GL index will take time. Do you want to build the GL index for FW now?"
• Regenerate the report.
• If the report is correct, generate the FRx report and select 'Use Posted Balances Only' in the catalog 'Provisional' field. 
• If the out of balance error still appears then perform the following:
1. Select General Ledger / View / Reports / General Ledger Report, and print this report for the account and period with the out of balance for posted only.
2. Select General Ledger / Listings / Period Balance Listing, and print this report for the account with the out of balance.
3. If there is a difference on these reports, contact Sage Software Support.
4. If there is no difference on these reports, select Admin / Build Local GL Index, and build the local GL index in FRx. 
• If the out of balance only occurs on 'Provisional:  Posted and Unposted Activity' level reports then peform the following:
1. Browse to the ..\Platinum\<Company_Key> directory for temporary files.  These files will start off with the two-digit module code, such as AP for Accounts Payable, and be followed by nlxb1 or nlxd1.  An example of the file name will be APNLXB1 or APNLXD1.
2. If these files exist, check the sub-ledger to verify the distribution method.  In Sage PFW open the sub-ledger, such as Accounts Payable, View / System Configuration / General Ledger Interface. Select the 'Post Distribution Method' check box.  If this is set to 'direct', then cut and paste the temporary files from the ..\Platinum\<Company_Key> directory into a temporary directory.  If this is set to 'indirect', then update the transactions to General Ledger.  To do so, in General Ledger, select View / Utilities / Sub System Transaction Import.
3. If any NLNL*.* files exist, such as NLNLXB1or NLNLXD1, cut and paste these files into a temporary directory and re-run the Edit List.  To do so, select General Ledger / View / Reports / Edit list. 
4. Once these steps have been completed, build the local GL index in FRx.  To do so, select Admin / Build Local GL Index.