Home » Categories » Solutions by Business Process » Finance » Nominal and Cashbook

Compact & Audit Database - Cashbook

Datafile Software

Compact & Audit Database - Cashbook

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 nominal account 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 transaction file – the journal clear down process will 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
Trial Balance - Cashbook
Viewed 1884 times since Wed, Jun 27, 2012
Account Currency ? 2 - Nominal - Database Profiles
Viewed 1340 times since Thu, Jun 28, 2012
System Status - Cashbook - Application User Facilities
Viewed 1480 times since Thu, Jun 28, 2012
VAT Adjustments - Partial VAT Exemption Scheme
Viewed 3330 times since Thu, Oct 11, 2018
Maintain Cash Book Accounts - Cashbook
Viewed 1548 times since Thu, Jun 28, 2012
Reconcile Bank Account - Cashbook
Viewed 2031 times since Wed, Jun 27, 2012
Drill Down Enquiry - Nominal
Viewed 1574 times since Wed, Jun 27, 2012
VAT Adjustments - Post-Dated Purchase Invoices
Viewed 3855 times since Thu, Oct 11, 2018
Application Manager - Nominal
Viewed 1390 times since Wed, Jun 27, 2012
Account Maintenance Improvements
Viewed 1534 times since Fri, Jun 8, 2012