Sidebar
assetmanagement:utilities:fiscalyearprocessing:massdelete
Mass Delete - BAM6100
Asset Management > Utilities > Fiscal Year Processing > Mass Delete
This utility is used to selectively drop records for capital assets, inventory items, and associated files. The records that are selected for deletion are based on the acquired date range and the status codes that are entered on the page. The user may also delete closed checkout inventory records that are no longer needed.
Note: The Mass Delete process modifies files, so it is recommended that you create a backup of your files before running this process.
Mass delete capital asset and inventory records
❏ Under Capital Assets and Inventory, select Delete Capital Asset and Inventory Records to enable the Delete options:
❏ Under Records to Delete:
| Field | Description |
|---|---|
| Inventory Master and All Associated Records |
Select to delete inventory master records and all associated records. If selected, the following options are enabled under Inventory Types: Capital Assets - If selected, the Status Codes field is required. Inventory Both - If selected, the program requires the Status Codes field to be completed. |
| Audit Tables Only |
Select to select one or more types of audit table records to be deleted. Inventory Audit Table - Records selected are based on the date acquired. Transaction Audit Table - Records selected are based on the effective date. Book Audit Table - Records selected are based on the date in service. |
| From Date |
Type the beginning date to use when evaluating records for deletion. If no date is entered, 00000000 is assumed. This date is compared to the inventory audit acquired date to delete inventory audit records, the transaction audit effective date to delete transaction audit records, and the book audit date in service to delete book audit records. This date is also used when removing inventory and associated records based on the status codes entered. |
| To Date |
Type the ending date to use when evaluating records for deletion. If no date is entered, 12319999 is assumed. This date is compared to the inventory audit acquired date to delete inventory audit records, the transaction audit effective date to delete transaction audit records, and the book audit date in service to delete book audit records. This date is also used when removing inventory and associated records based on the status codes entered. |
| Item Nbrs |
Click |
| Status Codes |
Click |
❏ Under Check Out:
| Delete Check Out Records |
Select to delete checkout records.
|
|---|
❏ Click Execute to execute the process. When the processing is completed, the Mass Delete Preview report is displayed. Review the report.
❏ Click Process to update the selected records in the asset management tables. A message is displayed prompting you to create a system backup.
A message is displayed indicating that the process was completed successfully. Click OK.
assetmanagement/utilities/fiscalyearprocessing/massdelete.txt · Last modified: 2020/09/15 22:03 by emoreno