Service Manager options are greyed out in Sales Analysis in Sage 300

Description

When going into Sales Analysis, which is compatible with Technisoft Service Manager, we do not have the option to select Service Manager. It is displayed, but unavailable for selection.

Cause

In the Uni database, the UXOPT table contains an incorrect value for the SM field.

Resolution

For 300 ERP 2012, you can run the following SQL statement to update the SM field:
Update UXOPT
set SM = ‘True’ where DBVersion=’61A’

Note: For version 6.0A, use DBVersion=’60A’.
For version 5.6A, use DBVersion=’56A’

Additional Information

Ensure you have a backup of the Uni database and the compatible version of Service Manager with Sales Analysis.