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.
|
Configuration
Viewed 1729 times since Mon, Jul 2, 2012
Document Watermark - Document Design Manager
Viewed 2261 times since Mon, Jul 2, 2012
Default Invoice Status by Account
Viewed 2791 times since Fri, May 27, 2016
Controls and Audit Manager
Viewed 2042 times since Mon, Jul 2, 2012
Transfer Outstanding Invoices
Viewed 1757 times since Mon, Jul 2, 2012
Default ‘Eligible Accounts’ on Statements
Viewed 1692 times since Wed, Jun 13, 2012
Additional Copy Items from Stock to Order Detail
Viewed 1532 times since Fri, Mar 11, 2016
Unallocated Receipts / Payments
Viewed 2642 times since Mon, Jul 2, 2012
Additional Lookups on Account Maintenance
Viewed 2120 times since Wed, Jun 13, 2012
Discount and Supplier Matrix Prevent Sale of Items to Selected Customers
Viewed 2188 times since Fri, May 20, 2016
|