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.