Home » Categories » Solutions by Business Process » Stock Control and Batch Tracking |
Compact & Audit Database - Stock Control |
Article Number: 488 | Rating: Unrated | Last Updated: Thu, Jun 22, 2023 at 11:01 PM
|
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). |
Attachments
![]() There are no attachments for this article.
|
Period End - Stock Control
Viewed 2173 times since Mon, Jun 18, 2012
Transaction Analysis Summary - Stock Control
Viewed 1475 times since Mon, Jun 18, 2012
Stock Price Changes - Stock Control
Viewed 1527 times since Mon, Jun 18, 2012
Set Auto Expand Data Files - Batch Tracking
Viewed 1613 times since Tue, Jun 19, 2012
Batch Mandatory - Batch Tracking
Viewed 1600 times since Wed, Jun 20, 2012
Trans Mandatory - Batch Tracking
Viewed 1620 times since Wed, Jun 20, 2012
Maintain Stock File - Stock Control
Viewed 1764 times since Tue, Jun 19, 2012
Reports - Batch Tracking
Viewed 1679 times since Tue, Jun 19, 2012
Audit Pointers: Stock to Transactions & Audit Pointers: Assembly to Component - Stock Control
Viewed 1710 times since Tue, Jun 19, 2012
Component Items - Stock Control
Viewed 16024 times since Tue, Jun 19, 2012
|