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
CP0300 Customer Order Processing Order Billing
Order Billing Application Overview Order Billing is an application that will be used routinely. Regardless of which billing procedure you implement you will at least print invoices. The two billing procedures and other related concepts are explained ...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 ...PO0105 Purchase Order and Receiving Purge Closed Purchase Orders
Purge Closed Purchase Orders Application Overview The Purge Closed Purchase Orders function deletes fully received, invoiced, or canceled orders. Those Purchase Orders that maintain an order status set of C, may also be deleted by this application. ...CP0000 Customer Order Processing Overview
Overview How To Use This Manual When most people receive a new product, they want to use it right away. Unfortunately, this is not quite possible when dealing with computer hardware and software. This manual is intended to serve as a reference guide ...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 > ...