Home » Categories » Solutions by Business Process » Finance » Sales and Purchase Ledgers

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 Customer and Supplier 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 Transaction files – 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
Additional Transaction Report Utilities
Viewed 1565 times since Mon, Jun 11, 2012
Invoice Document Clear Down Options
Viewed 1687 times since Fri, Jun 8, 2012
Include Notes on Unallocated Transaction Reports
Viewed 1738 times since Fri, Jun 8, 2012
System Status
Viewed 1527 times since Mon, Jul 2, 2012
Inserting New Items - Document Design Manager
Viewed 1843 times since Mon, Jul 2, 2012
Customers / Suppliers
Viewed 1618 times since Fri, Jun 29, 2012
Contact Management - List Activities in LIFO Order
Viewed 1364 times since Tue, Mar 3, 2020
Ledger Enquiry
Viewed 1592 times since Mon, Jul 2, 2012
Year End Reports
Viewed 1727 times since Mon, Jul 2, 2012
Cheque Design (Purchase Ledger) (Excluding Compact) - Document Design Manager
Viewed 2187 times since Mon, Jul 2, 2012