The SedonaOffice Modules setup table contains a list of the modules customers can have active or inactive in the program. Checking the box for a module adds the modules assigned letter to the In_Process column of the SS_Setup_Modules table on the backend. Modules whose letters appear in this table will be active in SedonaOffice. Some modules have no front end checkbox, and must have their letter added through an SQL script.
To view which modules a company has active run the following select statement and review the In_Process column in the results - Select * from SS_Setup_modules
The following script can be run to add a new module. Before running the script, copy the letters that already exist in the company’s In_Process column. Then replace the ‘sqip’ in the script with all the letters they already had in their In_Process column, plus the letters for the new module you are trying to activate.
Update SS_Setup_modules set In_process = ‘sqip’ where Setup_id = 1
What each letter in SS_Setup_Modules.In_Process stands for:
YskgvCqnlwbjp
- a - ADP
- b - Barcoding
- C - ...?
- g - Inspection Groups (SS_SetupModules_Class.UseGroupTickets and Sedona.ModulesIncludeTicketGroups)
- h - Shipments
- j - Job Planner
- k - Activates message box displayed when posting a cycle batch; whether to re-age the customers in the customers in the batch.
- l - Point of Sale (lowercase L)
- n - Onboarding
- o - OmniAudit
- p - OPT Web Services
- q - Sagequest
- s - Service
- v - Vancouver
- w - WeSuite
- Y - ...?
