Home » Categories » Solutions by Business Process » Finance » Sales and Purchase Ledgers |
Compact & Audit Database |
Article Number: 1364 | Rating: Unrated | Last Updated: Mon, Jun 19, 2023 at 3:39 PM
|
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). |
Attachments
![]() There are no attachments for this article.
|
System Profiles Screen 5 (excluding Compact)
Viewed 1887 times since Mon, Jul 2, 2012
Credit Control Manager / Accounts On-Stop List
Viewed 2547 times since Mon, Jun 11, 2012
Trans Sub Contract (Purchase Ledger) - Database Profiles
Viewed 1952 times since Mon, Jul 2, 2012
Omit Statement Print for Flagged Accounts
Viewed 1866 times since Wed, Jun 13, 2012
Credit Control Manager (S/L Only)
Viewed 27430 times since Wed, Jun 13, 2012
Show History on Order Entry
Viewed 265 times since Thu, Jan 2, 2025
Set Auto Expand Data Files
Viewed 1823 times since Mon, Jul 2, 2012
Update Nominal Ledger
Viewed 1808 times since Mon, Jul 2, 2012
Change Order Status - Stock Record Locking
Viewed 100 times since Thu, Jan 2, 2025
Account Authority Levels
Viewed 2808 times since Tue, Jun 12, 2012
|