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:
set SM = ‘True’ where DBVersion=’61A’
Note: For version 6.0A, use DBVersion=’60A’.
For version 5.6A, use DBVersion=’56A’
Ensure you have a backup of the Uni database and the compatible version of Service Manager with Sales Analysis.
If necessary, seek the assistance of Acute Data Systems to help provide assistance with this process.