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
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. ...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 > ...NSCTLMN5 Global Setup Change Quote to Order 3
Order Entry Header Screen Application Overview Elliott COP is a feature rich module with many features and functions that are controlled in the Order Header, Order Line Item, and Order Billing Screens. Rather than enabling these features and ...How Do I Purge Notes?
Release Date: 3/1/2024 Q: The Note file is very large. How do I purge old records? A: Purging can be a double-edged sword, so you should be very careful when purging. The first step we recommend is to backup your data. Backup Your Data It is ...