INFORMATIONAL ** THIS INFORMATION HAS NOT BEEN VERIFIED **

Fiscal Years are grouped multiple times in SMI Reports

Entry Type: Informational

Product: SMI Report Manager

Application: SMI Report Manager 

Version Reported: 7.30.4 

Subject:

Fiscal Years are grouped multiple times in SMI Reports.

Possible Resolution:

When adding a Field Value 'FiscalYear' to a SMI Report the user may experience multiple groupings for the same Year.

This issue was caused by having a space after the Year in the database table tglFiscalYear.

Resolved with the following product updates:

• Sage ERP MAS 500 7.30 Product Update for December 2010 (7.30.5)

Contact Support for Generic Data Fix spDF_CleanupFiscalYearField.sql