If you decide to use a long weekend for Sage 500 ERP database maintenance...

1 minute read time.

If you decide to use a long weekend for some Sage 500 ERP database maintenance here are a few tips:

Planning for Sage 500 ERP product updates:

Product updates are cumulative
Product updates are in two parts
Review the release notes for details about the update
Product updates cannot be rolled back
Can’t go to add remove programs and un-install, requires a restore (server) or client re-install
Product updates should be installed against a test system first.
Thoroughly test 500 ERP, and all customizations.
How to determine on which version the client and the server are:

– SQL – Execute SELECT VersionNo from tsmmodule

– Client – Locate EnterpriseRes.dll and look at the properties

How to create / recreate a SQL server maintenance job using Sage 500 ERP interface

Use the line command: createdb.exe /m located under Sage Software\Sage MAS 500 Database Utilities\DBInstall folder
Use the Sage 500 ERP Synchronization utility to create / recreate:

Registration sql job - a sql job that attempts to re-register Sage 500 ERP a couple of weeks before the expiry date
–QtyOn job – updates PO/SO and pending quantity discrepancies

Since the tech support is closed over the long weekend here are some helpful tips on how to find answers easier:

Knowledgebase tips

• Place Exact string values in quotes – “How to”

• Use Boolean – “How to” AND register

• Use partial words with wild cards – quant* to find quantity and quantities

• Re-order the words – quantity pending or pending quantity

Happy Thanksgiving!

Zenon

Sage 500