Home » Categories » Solutions by Business Process » Order Processing and Invoicer » Sales Order Processing / Telesales

Remove All Completed Orders

Datafile Software

Remove All Completed Orders

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’.

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.

Do You Wish to Compact These Files?

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.

Custom Fields
  • Release ID: Standard
Attachments Attachments
There are no attachments for this article.
Related Articles RSS Feed
Frequency Call-Off
Viewed 1437 times since Tue, Jul 3, 2012
Job Costing Link at Detail Level
Viewed 1709 times since Tue, Jul 3, 2012
Set Flag Value on Order Detail based on Document Action Qty
Viewed 1806 times since Mon, Jun 11, 2012
Database Profiles
Viewed 1660 times since Wed, Jul 4, 2012
Batch “Auto-Run” Documents
Viewed 2926 times since Tue, Jul 3, 2012
Revalue a Currency Order
Viewed 1353 times since Tue, Jul 3, 2012
Document Processing – Instant Print from Landing Page
Viewed 47 times since Tue, Oct 22, 2024
Omit Application of Discount Matrix Entries on Price Band (SOP Only)
Viewed 1759 times since Wed, Jun 13, 2012
Detail Optional 1
Viewed 1813 times since Wed, Jul 4, 2012
Print Acknowledgement if no Details
Viewed 1705 times since Wed, Jun 13, 2012