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
Account Invoicing (Sales Ledger) - Database Profiles
Viewed 2180 times since Mon, Jul 2, 2012
Re-Scan Documents (Purchase Ledger)
Viewed 1537 times since Mon, Jul 2, 2012
Memo Facility Configuration
Viewed 1539 times since Mon, Jul 2, 2012
User Instructions
Viewed 3804 times since Fri, Jun 29, 2012
Account Authority Levels
Viewed 2533 times since Tue, Jun 12, 2012
System Profiles Screen 3 (excluding Compact)
Viewed 1599 times since Mon, Jul 2, 2012
Sub-Contractor Accessory - Supplier Maintenance
Viewed 1856 times since Mon, Jul 2, 2012
Allocations by Account - Sales Ledger
Viewed 2083 times since Mon, Jul 2, 2012
Account Optional 1 - Database Profiles
Viewed 1940 times since Mon, Jul 2, 2012
Foreign Currency Statement Print
Viewed 1770 times since Fri, Jun 8, 2012