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
Application User Facilities - Nominal
Viewed 1631 times since Thu, Jun 28, 2012
Maintain Auto Postings - Cashbook
Viewed 1850 times since Wed, Jun 27, 2012
Column Headings for Financial Summaries Spreadsheet Output
Viewed 2631 times since Fri, Oct 26, 2012
System Status - Cashbook
Viewed 1557 times since Wed, Jun 27, 2012
Set Current Period - Nominal
Viewed 1781 times since Wed, Jun 27, 2012
Payment Column Headings - Cashbook
Viewed 1906 times since Wed, Jun 27, 2012
Delete an Account - Cashbook
Viewed 2438 times since Wed, Jun 27, 2012
System Profiles Screen 3 - Nominal
Viewed 1522 times since Wed, Jun 27, 2012
Defining Financial Summaries - Nominal
Viewed 2919 times since Wed, Jun 27, 2012
DELETE - Delete an Account - Nominal
Viewed 2647 times since Wed, Jun 27, 2012