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.
|
Trans Currency - Database Profiles
Viewed 1854 times since Mon, Jul 2, 2012
Enter Payments
Viewed 2031 times since Mon, Jul 2, 2012
Customer Profitability (Sales Ledger)
Viewed 2019 times since Mon, Jul 2, 2012
Cheque Design (Purchase Ledger) (Excluding Compact) - Document Design Manager
Viewed 2464 times since Mon, Jul 2, 2012
Amend Status Flags - Purchase Ledger
Viewed 1770 times since Mon, Jul 2, 2012
Name and Address List
Viewed 1801 times since Mon, Jul 2, 2012
Account Invoicing (Sales Ledger) - Database Profiles
Viewed 2408 times since Mon, Jul 2, 2012
Scanning Invoice Documents
Viewed 8792 times since Wed, Jun 13, 2012
Trans Optional 2 - Database Profiles
Viewed 2002 times since Mon, Jul 2, 2012
Set Split Period Posting by Account
Viewed 125 times since Wed, Oct 16, 2024
|