Home » Categories » Solutions by Business Process » Finance » Job Costing

Compact & Audit Database

Datafile Software

Compact & Audit Database

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 Job and Cost Code files). 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 Job Transaction file – the cleardown processes 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
Controls and Audit Manager
Viewed 1814 times since Mon, Jun 25, 2012
Job Costing System Profiles (1/3)
Viewed 2386 times since Mon, Jun 25, 2012
Link to Sales Ledger
Viewed 1939 times since Mon, Jun 25, 2012
Link to Purchase Ledger
Viewed 1854 times since Mon, Jun 25, 2012
Timesheet Authorisation
Viewed 2851 times since Tue, Jun 12, 2012
Job Accum Costs
Viewed 2360 times since Mon, Jun 25, 2012
Update from Purchase Ledger
Viewed 1736 times since Mon, Jun 25, 2012
Link to Cashbook
Viewed 1631 times since Mon, Jun 25, 2012
Code Analysis
Viewed 1704 times since Mon, Jun 25, 2012
Updating an Existing Job
Viewed 2173 times since Mon, Jun 25, 2012