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
Transaction Reports - Batch Tracking
Viewed 1486 times since Tue, Jun 19, 2012
Goods Returns - Update FIFO Cost Table
Viewed 2570 times since Fri, Jun 8, 2012
Cost / Sale Price Changes - Stock Control
Viewed 3938 times since Mon, Jun 18, 2012
Record Batch Transactions on Stock Transaction File
Viewed 1521 times since Wed, Jun 13, 2012
Assemblies - Component Stock Check Report
Viewed 1557 times since Fri, Jun 8, 2012
Introduction to Batch Tracking
Viewed 1640 times since Tue, Jun 19, 2012
Update Last Sale / Purchase Dates with Assembly Build
Viewed 143 times since Wed, Oct 16, 2024
Assign Nominal Codes from Stock Location File
Viewed 3063 times since Fri, Jun 8, 2012
Expand Data Files - Batch Tracking
Viewed 1493 times since Tue, Jun 19, 2012
Multi Location Stock - Stock Control
Viewed 1681 times since Mon, Jun 18, 2012