Home » Categories » Solutions by Business Process » Stock Control and Batch Tracking

Compact & Audit Database - Batch Tracking

Datafile Software

Compact & Audit Database - Batch Tracking

The internal processing of databases does not necessarily re-use the space occupied by records that have been deleted (particularly in master files such as the Batch file). New records are always added to the end of the file. Therefore, over a period of time, it is possible a file may appear full but there could be gaps in the middle where records were deleted. Using this option consolidates the active data and frees up space.

This option effectively re-arranges all the active records so you must run both the ‘Audit Pointers’ functions after using this option. In practice you are unlikely to use this option unless you have manually removed batch records or transactions – the clear down processes within batch tracking running the compact process.

Custom Fields
  • Release ID: Standard
Attachments Attachments
There are no attachments for this article.
Related Articles RSS Feed
Batch Tracking
Viewed 1811 times since Mon, Jun 18, 2012
Stock Price Changes - Stock Control
Viewed 1733 times since Mon, Jun 18, 2012
Stock Locations - Auto Create / Update Stock Locations
Viewed 2093 times since Fri, Jun 8, 2012
Choosing the Right Company - Stock Control
Viewed 2031 times since Mon, Jun 18, 2012
Mark Stock Records for Year End Delete - Stock Control
Viewed 1827 times since Mon, Jun 18, 2012
Batch Reports - Batch Tracking
Viewed 1810 times since Wed, Jun 20, 2012
Merge Stock Codes Utility
Viewed 1932 times since Tue, Jun 12, 2012
Recalculate Cost of Assemblies - Stock Control
Viewed 1856 times since Mon, Jun 18, 2012
Document Design Manager - Moving, Deleting and Amending Items - Stock Control
Viewed 1847 times since Tue, Jun 19, 2012
Stock Optional 1 - Stock Control
Viewed 1648 times since Tue, Jun 19, 2012