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

Compact & Audit Database - Stock Control

Datafile Software

Compact & Audit Database - Stock Control

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 Stock 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 the ‘Audit Pointers’ function after using this option. In addition you should not, in the normal course of events, use this option on the Stock Transaction file – the period end process will usually do this for you and running here could affect the transaction control numbers (see above).

Custom Fields
  • Release ID: Standard
Attachments Attachments
There are no attachments for this article.
Related Articles RSS Feed
Document Design Manager - Stock Control
Viewed 1561 times since Tue, Jun 19, 2012
Expand Data Files - Stock Control
Viewed 1473 times since Tue, Jun 19, 2012
Enter Purchase Orders - Stock Control
Viewed 1430 times since Mon, Jun 18, 2012
Ideal Buying Quantity
Viewed 1442 times since Mon, Jun 18, 2012
Replicate a Stock Record - Stock Control
Viewed 1463 times since Mon, Jun 18, 2012
Transaction Control Numbers - Stock Control
Viewed 1573 times since Tue, Jun 19, 2012
Stock Take / Forward - Stock Control
Viewed 40481 times since Tue, Jun 19, 2012
Stock Issues - Batch Tracking
Viewed 1431 times since Tue, Jun 19, 2012
Batch Code Enquiry - Batch Tracking
Viewed 1708 times since Tue, Jun 19, 2012
Document Design Manager - Save and Exit - Stock Control
Viewed 1460 times since Tue, Jun 19, 2012