On selection of this option you are prompted to confirm whether you wish to remove all completed orders.
If you respond ‘No’ you are returned to the menu.
If you respond ‘Yes’ then the system processes the sales order header and sales order detail files and deletes any records with a ‘C-Complete’ or ‘D-Delete’ order status.The system displays the number of records removed and prompts to check ‘File Usage’.
When the system deletes a record it doesn’t automatically free up the space for re-use, instead a blank record is left within the file. When you elect to check file usage the system displays the number of records reserved within the database, the highest in use and the number of deleted records. If the highest record in use is close to the number reserved and there are a significant number of deleted records you may wish to compact the file so you can re-use the deleted records and delay expansion of the works order files.NB: Whilst larger file sizes will not cause any problems within Datafile they do take up extra space on your system and can increase backup times.
Respond ‘Y’ or ‘N’ accordingly. ‘N’ returns you to the menu, ‘Y’ compacts the sales order header and detail files and audits the pointers (i.e. rebuilds the links) between them. This may take some time on larger files.
Article ID: 1436
Created On: Tue, Jul 3, 2012 at 1:55 PM
Last Updated On: Wed, Jun 14, 2023 at 5:08 PM
Online URL: https://kb.datafile.co.uk/article/remove-all-completed-orders-1436.html