Tech Tips

Mainsaver Housekeeping for the New Year


Mainsaver Housekeeping for the New Year


There are many ways to keep your Mainsaver database clean and tidy. The beginning of a new year is good time to do this.

  • 1. Check for all open work orders. Query on ‘WO Open Like Y’. Combine this query statement with a date qualifier and then use the mass close function (Work order module, File pulldown menu) to close many work orders at once.

  • 2. Check for all open purchase orders. Query on ‘Status Not Like C’. Close purchase orders as appropriate by either receiving or using the close purchase order button.

  • 3. Check for purchase orders open but received in full. A nested query such as ‘status like FO and purchase order not in (select pono from pupod where clo_flag = 'N')’ works.

  • 4. Check for assets not in service that really should be in service. In the Asset module run the Assets out of Service report or perform a query for Asset Status like OS.

  • 5. Are there items in ‘special order items awaiting release’ that should be issued out to a work order, asset or cost center. Run the ‘Special order items awaiting release’ report in the Parts Master.

  • 6. Make sure employee charge rates are correct and employee status codes are up to date in the Personnel module.

  • 7. In the PM module, check for PM master records where the default status of the PM work order will be set to CLO or CNX. If a PM is no longer needed, delete the master record or set the PM status to ‘DEA’. Also, if the asset is deactivated, the PM records can be deleted.

  • 8. Check that all of your Mainsaver clients are on the most recent release.

  • 9. Have Mainsaver Professional Services come in for a site review and refresher training.

  • 10. Has the ‘msadmin’ password been changed lately?

  • 11. Check the available disk space on the server. It is a rare occurrence these days but it doesn’t hurt to check.

  • 12. Set up budgets for new year if budgets are used.

  • 13. Review the database backups and perform a test restore. (Disaster Recovery Drill) How many backups are stored on the server?

  • 14. Make sure all timecard records and misc. material records are posted.

  • 15. Set goals for improved utilization of Mainsaver in the New Year.

  • 16. In system administration, review the master lists under the references pulldown menu. Deactivate obsolete records where the ‘deactivate’ feature is available.

  • 17. Delete irrelevant global queries.

  • 18. Set Suppliers to DEA if you no longer will purchase from them.

  • 19. Identify the materials that cost the most in the current year (ytd_usage) or previous year (Last Year Usage) by performing a query such as;

  • 20. Run the asset cost summary report to identify high cost assets. (Management Reports, Reports Pulldown Menu)

  • 21. Use the copy command to create future year budget period calendars. (System Administration, Settings menu)

  • 22. Perform monthly closing to close out last year and advance the budget periods to the current year. (System Administration, Maintenance menu)

Mainsaver offered a variety of CMMS solutions that matched the way our business works. They provided customizable solutions and integration options that effectively manage our maintenance requirements and save us quite a bit of money in the process.