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.
|
VAT Summary – Include Out of Scope VAT Codes
Viewed 19443 times since Tue, Oct 12, 2021
Edit System Status Display
Viewed 1920 times since Mon, Jul 2, 2012
Display Price Item Names
Viewed 2369 times since Fri, May 20, 2016
Cash Accounting and Forward Payments
Viewed 2187 times since Wed, Jun 13, 2012
Allow Insert of Lines within Order by Status
Viewed 488 times since Thu, Jan 2, 2025
Nominal Analysis
Viewed 1946 times since Mon, Jul 2, 2012
Default Invoice Status by Account
Viewed 2937 times since Fri, May 27, 2016
Moving, Deleting and Amending Items - Document Design Manager
Viewed 2074 times since Mon, Jul 2, 2012
Show Credit Values as Negative on Sales Statements
Viewed 156 times since Tue, Oct 15, 2024
Controls and Audit Manager
Viewed 2156 times since Mon, Jul 2, 2012
|