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
System Status - Application User Facilities
Viewed 1746 times since Mon, Jul 2, 2012
Unallocated Transaction Reports
Viewed 1921 times since Mon, Jul 2, 2012
Cost Price Checks - Omit Warning if No Change in Selling Price (SOP Only)
Viewed 126 times since Thu, Jan 2, 2025
Enter Invoice Adjustments
Viewed 1900 times since Mon, Jul 2, 2012
Period / Year End Facilities - Application User Facilities
Viewed 1927 times since Mon, Jul 2, 2012
Credit Control Manager (S/L Only)
Viewed 27486 times since Wed, Jun 13, 2012
Account Aged Analysis - Database Profiles
Viewed 1900 times since Mon, Jul 2, 2012
Allow Insert of Lines within Order by Status
Viewed 266 times since Thu, Jan 2, 2025
Application Screen Layouts
Viewed 2244 times since Mon, Jul 2, 2012
Reprint Period Invoices
Viewed 2037 times since Mon, Jul 2, 2012