How Do You Purge Quote Type Orders?
A: What is the best way to purge quote orders up to 12/31/13 ? I thought one way is to delete Q orders from the CPORDHDR table by using PSQL Control Center and then run the utility to delete orphan lines.
Q: The best way is to accomplish this task is to go to COP -> Processing -> Purge Posted Orders -> Purge -> Posted Orders. Answer "Q" to
Purge Quote Type Orders ?
The possible values are:
Y = Purge Quote (& Posted Orders Will Be Purged Too)
N = Do Not Purge Quote
Q = Purge Quote Only
After you purge the quote type orders, they will be moved to "Order History" so you can still see them through Order History Inquiry without losing the information. In the meantime, your open order database will become smaller and faster (if you perform a Pervasive Rebuild on CPORD*.BTR files).
Related Articles
BM27S1 Bill of Material Purge Complete Production Orders
Purge Complete Production Orders Application Overview The Purge Complete Production Orders application will delete selected orders from the BOMP Order File. This is designed to keep the data file from taking up disk space with orders, which are no ...CPPURSDQ Customer Order Processing Purge Sales Desk Quote
Purge Sales Desk Quote Application Overview Quotes entered in Sales Desk can be purged quickly and easily. You are asked if you wish to purge and then prompted for a cut-off date. Run Instructions COP Main Menu > Util-Setup > Purge Sales Desk Quote > ...Avalara - Copy/Consolidate Orders
Release Date: 4/28/23 Version: 8.6 and Above When the Avalara Integration is enabled, the following changes will take effect in Copy/Consolidate Orders. Copy/Consolidate Orders must be run under version 8.6. If the user attempts to run the ...ARPRGSCN Accounts Receivable Purge Closed Open Items
Purge Closed Open Items Application Overview Periodically, you will want to remove from the A/R Open Item File all transactions that have been fully paid off. Otherwise, the file could become very large over a period of time. This application will ...CP0308S1 Customer Order Processing Purge Invoice History
Purge Invoice History Application Overview This enhancement purges the invoice history file. The user can enter the invoice cutoff date for the purge to end. All invoice headers and invoice line items will be deleted. This will help make invoice ...