"Error 94 - Invalid Use of Null." when launching FRx or Financial Reports

Entry Type:  Program Issue

Product: FRx

Application: FRx

Version Reported:  6.74

Subject:
"Error 94 - Invalid Use of Null." when launching FRx or Financial Reports.

Steps to Duplicate:

FRx for Sage MAS 500

1. Open General Ledger / Reports / Financial Reports  or Launch the FRx system.
   Note that the user receives the error above.

Expected Behavior:
The user expects to start the described tasks above without error.

Possible Workaround:
In at least one instance, this error occurred due to the fact that multiple fiscal years/periods had been created for years far into the future - in this instance there were several years set up in the "2100's" (up through 2134), with NULL values for both the period-end date for February and period-start date for March.

The following query reveals the problem rows that are causing the error.

---

SELECT  FiscYear, FiscPer FROM tglFiscalPeriod WHERE CompanyID = "XXX" and (StartDate IS NULL OR EndDate IS NULL)

To correct the issue in MAS 500:

1. Expand General Ledger, Maintenance, GL Setup, Set Up Fiscal Calendar.
2. Select the Fiscal Year that has a missing 'End Date'.
3. Update the 'End Date' for the selected Period Date. Save and Finish. User will be prompted to recalculate the General Ledger balances which is ok.