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
Assemblies - Bulk Stock Items
Viewed 2058 times since Fri, Jun 8, 2012
Stock Transactions - Stock Control
Viewed 1862 times since Tue, Jun 19, 2012
Component Stock Check Report - Include Notes / Comments
Viewed 4382 times since Fri, Oct 26, 2012
Document Design Manager - Moving, Deleting and Amending Items - Stock Control
Viewed 1812 times since Tue, Jun 19, 2012
Edit System Status Display - Batch Tracking
Viewed 1582 times since Tue, Jun 19, 2012
Database Audit - Batch Tracking
Viewed 1735 times since Tue, Jun 19, 2012
Enquire Where Stock Used - Stock Control
Viewed 1769 times since Mon, Jun 18, 2012
Copy Batch Items to Stock Transactions
Viewed 1847 times since Fri, Jun 8, 2012
Automatic Stock Take – Zero Quantity Adjustments
Viewed 66 times since Wed, Oct 23, 2024
Maintain Matrix Templates - Batch Tracking
Viewed 1750 times since Tue, Jun 19, 2012