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


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.


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


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.