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.
|
Account Currency - Database Profiles
Viewed 2183 times since Mon, Jul 2, 2012
Recalculate Debtor/Creditor Control
Viewed 2392 times since Mon, Jul 2, 2012
Validate Account and Stock Groups Entries
Viewed 2123 times since Fri, May 27, 2016
Add Debtor / Creditor Control Memo from Ledger Enquiry
Viewed 4782 times since Fri, Jun 8, 2012
Account Optional 2 - Database Profiles
Viewed 2439 times since Mon, Jul 2, 2012
System Profiles Screen 3 (excluding Compact)
Viewed 1983 times since Mon, Jul 2, 2012
Holding Rate Revaluation
Viewed 2268 times since Mon, Jul 2, 2012
Statement/Remittance Design - Document Design Manager
Viewed 8092 times since Mon, Jul 2, 2012
Set Account Group on Stop
Viewed 13562 times since Fri, Oct 26, 2012
Application User Facilities
Viewed 1899 times since Mon, Jul 2, 2012
|