| 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.
|
Enquiries Configuration
Viewed 2191 times since Mon, Jul 2, 2012
Turnover Analysis
Viewed 2238 times since Mon, Jul 2, 2012
Run Proposed Payments - Purchase Ledger
Viewed 1989 times since Mon, Jul 2, 2012
Account Optional 1 - Database Profiles
Viewed 2340 times since Mon, Jul 2, 2012
Show Credit Values as Negative on Sales Statements
Viewed 539 times since Tue, Oct 15, 2024
Utilities
Viewed 2370 times since Mon, Jul 2, 2012
Account Optional 3 - Database Profiles
Viewed 2622 times since Mon, Jul 2, 2012
Account Costs (Sales Ledger) - Database Profiles
Viewed 2425 times since Mon, Jul 2, 2012
Reports
Viewed 2012 times since Mon, Jul 2, 2012
Write Off Bad Debts
Viewed 2485 times since Mon, Jul 2, 2012
|

