Periodic tasks & utilities -and important suggestions for when to perform them...
In Acme Point of Sale
>Transaction >Reconcile Cash Trays
Once for each tray at the end of each day.
Skipping a day is OK, but if you do then make sure when you come back you reconcile each day in order so end of day balances get carried forward appropriately.
On a related note, doing this daily ensures that Ticket Entry window gets closed at the end of each day and a new Cash Tray session is automatically started when Ticket Entry is opened the next day.
>Maintenance >Reindex
As needed. Backup data first. After power outage or other machine or network malfunction causes data corruption. The indexes are normally self maintaining but if you are experiencing any type of odd behavior or errors backup your data and tune-up. The process can also recreate missing tables and validate table structures.
Database indexes are somewhat like indexes in a book in the sense that both are used to help locate something. While Acme automatically updates its indexes during normal use, this utility allows you to re-index manually and it also permanently removes deleted records from the database tables.
You must be the only user logged into Acme to perform this function.
If you experience data inconsistencies due to network or power failures running this process can help.
"Backup and Tune Up" is the often the first response and answer to many technical support issues.
If you find you must tune up on a regular basis to fix data problems you should have your network checked by a professional.
>Maintenance >Update Database
As needed / instructed by tech support. Backup data first. Typically database updates occur automatically during upgrades when we add new fields / capabilities to Acme. On rare occasion it may be helpful to trigger them manually. This process also performs a reindex.
In Acme Data Pump
If you have multiple stores and a host accounting system perform these daily or more often if desired: (can be auto-run via scheduler)
Data Pump > Post to Host
Perform at the end of each day. More often if desired. -Can be run via Windows Scheduler.
Data Pump > Import From Host
Perform daily, or any time changes are made in host (to items or customers) and you want them reflected in Acme. -Can be run via Windows Scheduler.
If you want accurate on hand levels in Acme just post any Acme transactions into your host (record/post them in host if necessary) and receive Po’s for deliveries that have arrived. Then import from host to Acme.
Data Pump > Backup / Restore
Backup daily and before any major changes are made in Acme, then if you ever need to restore, you can use the most recent backed up data.
Multi-Store Data Movement Illustration
Data Pump >Multi Store >Get Transactions From Satellite Stores
Generally once a day, but can be performed as desired.
Data Pump >Multi Store >Send Update To Satellite Store(s)
Generally once a day, but can be performed as desired.
As needed in Acme Data Pump (regardless of host accounting system)...
Data Pump >Utilities> Remove Old Records
As needed. Backup data first.
Data Pump >Utilities > Tune Up Database
As needed. Backup data first. After power outage or other machine or network malfunction causes data corruption. The indexes are normally self maintaining but if you are experiencing any type of odd behavior or errors backup your data and tune-up. The process can also recreate missing tables and validate table structures.
Data Pump >Utilities > Update Super Find Dictionaries
Updates item and customer dictionaries. Perform after first import from host, after that the Super Find dictionaries are self maintaining.
Data Pump >Utilities > Empty Database
Can be used prior to "going live" to remove sample data and test transactions. Always backup first!
In the Help file
Periodically Review Acme Change Log
See what's new in Acme and easily determine the difference between your build and the most recent build. In F1 (online) help there is a link to the latest change log.
