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
Stock Record and Stock Transaction Pick Lists
Viewed 17781 times since Fri, Jun 8, 2012
Transaction Control Numbers - Stock Control
Viewed 1899 times since Tue, Jun 19, 2012
Copy Item Facilities - Batch Tracking
Viewed 2072 times since Wed, Jun 20, 2012
Component Stock Check Report - Include Notes / Comments
Viewed 4414 times since Fri, Oct 26, 2012
Out of Stock Report - Stock Control
Viewed 1694 times since Mon, Jun 18, 2012
Invoicer Documents - Batch Tracking
Viewed 1622 times since Wed, Jun 20, 2012
Set Company Details - Stock Control
Viewed 1818 times since Mon, Jun 18, 2012
Sales Issues / Reservation Listing - Stock Control
Viewed 1761 times since Mon, Jun 18, 2012
Potential Out of Stock Report - Stock Control
Viewed 2286 times since Mon, Jun 18, 2012
Retail Stock (1 and 2) and Retail Transactions - Stock Control
Viewed 1865 times since Tue, Jun 19, 2012