The Delete function is used to remove records from the database. Deleted records no longer appear in the database, reports, and various other program functions. Deleted database records may be recalled using the Recall function unless the database has been packed using the Pack function. Packing removes deleted database records from the Recall function.
To Delete a Database Record
- Select the appropriate database.
- Select Delete from the Record menu.
- Select the record to Delete from the Delete Record Lookup List.
- Press [Enter] to Delete the record. The record is no longer visible in the Delete Record Lookup List (and is displayed in the Recall Lookup List, until the Pack function is run).
- Press [Esc] to exit the Lookup List.
Note:
- If an Inventory record with an On Hand Quantity, Allocated Quantity, Layaway Quantity, or On Order Quantity not equal to 0 is selected to be deleted, a warning screen is displayed showing the current quantity and asks for confirmation to "Delete It Anyway?".
- If an Customer record with an Amount Due not equal to 0 is selected to be deleted, a warning screen is displayed showing the current Amount Due and asks for confirmation to "Delete It Anyway?".
- If the current Clerk selects their own record to be deleted, an Access Denied screen is displayed explaining that "The clerk record is the same as the current clerk. (You can't Delete it)".
- Deleting an active record may cause problems with Inventory levels or Accounts Receivable. Before deleting active database records, use one of the following functions to set the appropriate field(s) to 0: Sales Transaction, Purchase Transaction, Variance, ROA Payment, etc. Database records should be deleted ONLY AFTER the required field values have been appropriately adjusted.
See:
Database Manager Contents