New features added, version 7.5.2, 7.5.3, 8.1
Program OEHP, Order History Purge by Date, is used to delete old sales orders from the system.
This program will purge a sales order if it meets any of the following conditions:
* The order has been canceled (status "X").
* The order has been invoiced and all invoice transactions have been purged with program ARPP, Period End AR Purge. As long as there are any accounts receivable invoice transactions remaining in the system, the order will not be purged.
* The sales order is still a quotation and the status is won, abandoned, or lost.
Sales order records are purged, but sales analysis records remain.
You can further pare down the selected records by executing additional queries in the lower block. You should be aware however, that the additional queries do not automatically deselect the automatically selected orders from the initial query.
* For example, if you enter a date, select the desired order status flags, and press the query button, the orders returned will all be selected in the lower block. If you then click in the lower block, press [Enter Query], and enter additional query criteria, when you press [Execute Query], those records that were initially queried are still selected.
In short, if you wish to cherry pick the orders that will be purged, be sure to deselect all of those that you don't want to be purged before pressing the [Purge Selected] button. Keep an eye on the Purge Order Count field as it keeps a running total of the number of orders selected.
1. In the Enter New Earliest Date field, enter the earliest date of the orders that you do not want to purge.
2. To query invoiced sales orders (status V), set the Invoiced Sales Orders flag to on.
3. To query cancelled sales orders (status X), set the Canceled Sales Orders flag to on.
4. To query won quotations (status W), set the Won Quotations flag to on.
5. To query lost quotations (status L), set the Lost Quotations flag to on.
6. To query abandoned quotations (status A), set the Abandoned Quotations flag to on.
7. Press the [Query] button. The orders that can be purged will be displayed as selected for purge in the lower block.
8. Deselect the orders that you do not want to be purged. Orders that are not selected will have the select flag to the left of the Order No field set to off.
* To select all orders to be purged, press the [Select All] 
button. You can deselect orders after this button has been pressed.
* To deselect all orders, press the [Deselect All] 
button. You can select orders after this button has been pressed.
9. Set the Archived Purged Records flag to the desired setting. When this flag is set to on, the purged sales orders will be stored in the archiving table.
10. Press the [Show Analyze Dates] button to verify that the affected tables have been analyzed recently and that there are no tables that have not been analyzed. Contact your system administrator if this is not the case.
11. Press the [Purge Selected] button to purge all orders that are selected in the lower block.
12. Some orders may not be able to be purged. When the purge is complete, requery the orders to view those that could not be purged.
Press this button to deselect all orders displayed in the lower block.
Press this button to purge the selected sales orders in the lower block.
Press this button to query the sales orders that occur before the date entered in the Enter New Earliest Date field.
Press this button to select all orders displayed in the lower block.
Press this button to show the most recent and oldest analyze dates of the tables involved in the purge. You should not run the purge unless the analyze is very recent and all tables have been analyzed. Contact your system administrator if this is not the case.
* Use prochist.oehp_table_analyze to reanalyze affected tables.
Press this button to view the information about the last time the records were purged. The information includes the employee number, financial enterprise, manufacturing enterprise, plant code, date archived, earliest transaction date, and comments. The comment field can be maintained.