How Do You Purge Quote Type Orders?

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 > ...
    • Feature - Add HTML Version of Quote Acknowledgement

      Release Date: 11/30/2022 Version: 8.6 & Up A new HTML version of the Quote Acknowledgement email has been created in Elliott 8.6. Setup for this feature is found in: Global Setup --> cop-Func --> print order/quote/rmA. This feature is related to HTML ...
    • Feature - Add HTML Version of Sales Desk Quote Acknowledgement

      Release Date: 3/17/2023 Version: 8.6 and Up A new HTML version of the Sales Desk Quote Acknowledgement email has been created in Elliott 8.6. Setup for this feature is found in: Global Setup --> cop-Func --> print order/quote/rmA. This feature is ...
    • 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 ...