How to recreate Ops Inquiry or Sales Analysis in Sage 300

Description

The Sales Analysis and Ops Inquiry database is not included in backups performed using the DBDump utility. This database needs to be recreated if the company database is moved from one server to another.

Resolution

To recreate the UNI database used by Sales Inquiry or Ops Inquiry please see the steps below.

  1. Backup the existing company databases
  2. Start Microsoft SQL Server Management Studio or Pervasive Control Center
  3. Delete the ‘UNI’ database
  4. Recreate the ‘UNI’ database
  5. Edit the CSAPP table in the company database and remove the UQ entry for Ops Inquiry or the UX entry for Sales Analysis
  6. Start Sage 300 ERP
  7. Select Data Activation under Administrative Services
  8. Re-activate the required module

UNI database has been recreated for the selected company.

Support

If necessary, seek the assistance of Acute Data Systems to help provide assistance with this process.