Please enable JavaScript to view this site.

Click >Utilities Tab >Empty Database

 

You must be a member of the Manager or Administrator Group to perform this task.

 

Choose the Acme data tables that you would like to totally purge of data. Typically the only time this is done is when you have used the Acme sample data and you are ready to replace it with your own data. You would also want to do this is you were going to re-install Acme and you do not want all or part of the "old" data to be in the new install.

 

It is rare to want to empty Terminal Tables or Tender Types. Theses are usually easier to edit than to create from scratch.

 

If you want to purge Acme sample data and start entering your own by hand or by importing from your accounting system then choose Empty Tables for First Time Bridge. If you are going to use multi-rate sales tax then run the routine twice, once for first time bridge and a second time to empty the Sales Tax Tables.

 

Check Boxes

 

Empty Tables for First time Bridge. -Prepares Acme for receipt of data from a host accounting system. Use this to remove sample data.  

 

Empty ALL Tables -Empties all of the below… -highly unlikely anyone would want to do this, see note below.

 

Empty ALL Transactions

Only empties transaction tables. Keeps customer, inventory and setup tables.

This is a good way to remove testing transactions that were created outside of Practice Mode.

 

Empty Ticket Tables

Empties receipt (transaction) information. Leaves cash tray reconciliation data.

Empty Sales Tax Tables

Empties sales tax setup information.

 

Empty Customer Tables

Empties all customers information including alternate addresses.

Empty Point of Sale Terminal Tables

Empties all terminal setup information.

Empty Inventory Tables

Empties all inventory and pricing information, including PLU's.

 

Empty Tender Type Tables

Empties all tender types setup.

 

Empty Cash Tray Reconciliation

Empties all records from current and past reconciliation’s.

 

Empty Miscellaneous Tables

Empties data from several misc. tables.

 

Enter "EMPTY" to empty database(s) -If you really want to do this type in the word "EMPTY" before you can click on [EMPTY] button.

Warning: There is no date cut-off. The records are not just deleted, the tables are emptied.

Your only recourse would be to restore from backup if you have one.  Backup your data prior to emptying database(s).

 

Empty [button] -Available only after you have selected table(s) and typed "EMPTY".

 

Related Topics

 

Practice Mode

 

Go Live Checklists

Acme Point of Sale is brought to you by Total BusinessWare Inc.

  

Keyboard Navigation

F7 for caret browsing
Hold ALT and press letter

This Info: ALT+q
Page Header: ALT+h
Topic Header: ALT+t
Topic Body: ALT+b
Contents: ALT+c
Search: ALT+s
Exit Menu/Up: ESC