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

Compact & Audit Database - Nominal

Datafile Software

Compact & Audit Database - Nominal

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.

Custom Fields
  • Release ID: Standard
Attachments Attachments
There are no attachments for this article.
Related Articles RSS Feed
Optional Account Items - Nominal - Database Profiles
Viewed 1284 times since Thu, Jun 28, 2012
Quick Allocation Options
Viewed 1195 times since Wed, Jun 13, 2012
Receipt Posting – Advanced Search Options for Sales A/C’s
Viewed 1145 times since Wed, Jun 13, 2012
DELETE - Delete an Account - Nominal
Viewed 2263 times since Wed, Jun 27, 2012
Column Headings for Financial Summaries Spreadsheet Output
Viewed 1953 times since Fri, Oct 26, 2012
Drill Down Enquiry - Nominal
Viewed 1321 times since Wed, Jun 27, 2012
Journal Entry - Nominal
Viewed 2518 times since Wed, Jun 27, 2012
Standard Update – Payroll - Nominal
Viewed 1363 times since Thu, Jun 28, 2012
Revalue Nominal Accounts by Currency
Viewed 1246 times since Wed, Jun 13, 2012
Budget Report - Nominal
Viewed 1176 times since Wed, Jun 27, 2012