Purpose: In addition to the purges described earlier under Purging Files, you can use the purge options below to delete outdated or unneeded records in various files. Purging unnecessary records can help save space and improve performance.
For more information:
• A/P Transfer: Accounts Payable Using the STS Interface.
• A/R Open Items: Accounts Payable Purging (MOIP) and Resetting (TARO).
• Active Procedures: Purging Active Procedures.
• Call Tags: Customer Service Processing Call Tags (MCTG).
• Correspondence History: Customer Service Purging Correspondence History (MPCH).
• Coupon Redemption Records: Purging Coupon Redemption Records (MPCP).
• Customer Subscriptions: Customer Service Purging Subscriptions (MPCS).
• ECLOGF records: Purging ECLG Files (PECF).
• General Ledger Detail: Press F7 through Displaying the General Ledger Interface (DGLI).
• Orders (multiple): Purging Orders (MPOR, FORP, VORP, DORP). You can also purge a single order through Purge Orders by Order Number (MORP),
• Pick Control Label Records: Purging Unused Pick Control Label Records (PLBS).
• Prestige Credit Card Deposits: Purging Prestige Credit Card Deposits (MPSP).
• Prospect Finder File: Marketing Purging the Prospect Finder File (MPFF).
• Refund Checks: Customer Service Reconciling Checks (MREC).
• SKUs: Purging SKUs (MPSK).
• Suspended Orders: Purging Suspended Orders (PSOR).
• Vendor Charge Back: Accounts Payable Purging Vendor Charge Backs (PVCR).
In this topic:
• Purge A/P Checks/Invoices (MCKP)
• A/P Check/Invoice Purge Screen
• Purge Inventory Transaction History (MITH)
• Purge Inventory Transactions Screen
• Purge Marketing Customers and Orders (MPMC)
• Purge Marketing Customer Files Screen
• Purchase Order Purge Selection Screen
• Purchase Order Purge Listing
• Purge Empty Item Locations (PITL)
• Purge Empty Item Locations Screen
• Purge Order Billing History (POBH)
• Purge Order Billing History Screen
• Purchase Order Purge Listing
• Purge Orders by Order Number (MORP)
Purge A/P Checks/Invoices (MCKP)
Purpose: Use this menu option to purge records in the A/P Checks file and related records in the A/P Invoice Header and Detail files.
Purge dates: The A/P Files Purge Days (C21) system control value indicates how many days old records need to be in order to be eligible for purge.
A/P Check/Invoice Purge Screen
How to display this screen: Enter MCKP in the Fast path field at the top of any menu, or select Purge A/P Checks/Invoices from a menu.
ACR0155 ENTER A/P Check/Invoice Purge 9/08/06 8:33:19 EZK Mail Order
Archive information (Y,N)
F3=Exit F9=Accept F12=Cancel F22=User defined option F24=Select company |
Completing this screen: Enter Y in Archive information to archive the purged information in the library specified in the Archive Library (C11) system control value; then, press F9 to submit the AP_PURGE job, which purges the records.
For more information: For background on A/P checks and invoices, see Entering A/P Invoices and Generating A/P Checks.
Purge Inventory Transaction History (MITH)
Purpose: Use this option to purge records in the Item Transaction History file that are older than the number of days specified in the Inventory Transaction History Retention Days (A24) system control value.
Purge Inventory Transactions Screen
How to display this screen: Enter MITH in the Fast path field at the top of any menu, or select Purge Inventory Transaction History at a menu.
INR0069 ENTER Purge Inventory Transactions 9/08/06 8:58:10 EZK Mail Order
Purge records for Company . : 27 EZK Mail Order
F3=Exit F12=Cancel F24=Select company |
Completing this screen: This screen indicates the numeric code and description of the company where the records will be purged. Press Enter to submit the PURGE_ITH job, which purges the records.
For more information: For background on inventory transaction history, see Display Inventory Transaction History (DITH).
Purpose: Use this option to purge records in the Correspondence History and Correspondence History Detail files that are older than a specified date.
How to display this screen: Enter MPCH in the Fast path at the top of any menu or select Purge Email History from a menu.
CSR1263 ENTER Purge Email History 9/08/06 9:08:41 EZK Mail Order
Purge Email History older than (MMDDYY)
F3=Exit F9=Accept F12=Cancel |
Completing this screen:
• Specify the cutoff date for purging Correspondence History and Correspondence History Details records. All records older than the date you enter will be purged.
• Press F9to submit the CORHS_PURG job.
For more information: For background on correspondence history, see Email Repository.
Purge Marketing Customers and Orders (MPMC)
Purpose: Use this option to purge records in the Marketing Customer Tran file and Marketing Order Tran file older than a specified date. These records are generated through House List selection.
Purge Marketing Customer Files Screen
How to display this screen: Enter MPMC in the Fast path field at the top of any menu, or select Purge Marketing Customers and Orders from a menu.
HLR0162 ENTER Purge Marketing Customer Files 9/08/06 9:21:17 EZK Mail Order
Purge date
F3=Exit F9=Accept F12=Cancel |
Completing this screen:
• Specify the cutoff date for purging Marketing Customer Tran and Marketing Order Tran records. All records older than the date you enter will be purged.
• Press F9to submit the PURGE_MRKT job.
For more information: For background on house list selection, see Working with Drops (WHLS).
Purpose: Use this option to purge canceled and/or completed records in the following files:
• PO Detail
• PO Detail Audit
• PO Detail Estimated Charges
• PO Detail Hold
• PO Detail Messages
• PO Detail Noninventory
• PO Header
• PO Header Audit
• PO Message
• PO Receipt Header
• PO Suspense
Purge dates: Records are eligible for purging if the date they were canceled or received is older than number of days specified in the # of Days Before PO Purge (A58) system control value.
Report: This option also generates the Purchase Order Purge Listing listing the purchase orders deleted through the purge.
Purchase Order Purge Selection Screen
How to display this screen: Enter MPOP in the Fast path field at the top of any menu, or select Purge Purchase Order from a menu.
POR0169 ENTER Purchase Order Purge Selection 9/08/06 9:27:26 EZK Mail Order
Purge completed orders . . N (Y/N)
Purge cancelled orders . . N (Y/N)
* * * * * *
Purge report . . . . . . . D (D=Detail,S=Summary)
F3=Exit F9=Accept F12=Cancel |
Completing this screen:
• Enter Y in the Purge completed orders flag to delete purchase orders that are completed; otherwise, leave this flag set to N.
• Enter Y in the Purge cancelled orders flag to delete purchase orders that are canceled; otherwise, leave this flag set to N.
Note: You must select either completed or canceled purchase orders for purge at this screen.
• Leave the Purge report field set to D (default) to print the Purchase Order Purge Listing with information on purchase order detail lines, or change the setting to S to print the summary version.
• Press F9 to submit the PO_PURGE job. This job purges the records based on your screen selections and the setting of the # of Days Before PO Purge (A58) system control value, and generates the Purchase Order Purge Listing.
For more information: For background on purchase orders, see Entering Purchase Orders (MPOE) and Purchase Order Inquiry (MPOI).
Purge Empty Item Locations (PITL)
Purpose: Use this option to purge Item Location records whose Physical freeze flag is set to N and have zero:
• on-hand quantity
• pending transaction quantity
• printed quantity
You need to specify the warehouse where empty item locations should be deleted. In addition, the prompt screen allows you to specify the number of days since placement date. For example, if you specify 45 days, only item locations whose placement dates were more than 45 days ago and which match all the other criteria will be deleted.
Even if the purge deletes the item location record, it is possible that the item/SKU has this warehouse and location identified in the SKU file as the “primary primary” location. The record in the SKU file is not cleared by this purge.
Note: Ordinarily, the system automatically deletes all item locations when the above quantities are zero, except in the case of primary locations.
Purge Empty Item Locations Screen
How to display this screen: Enter PITL in the Fast path field at the top of any menu, or select Purge Empty Item Locations from a menu.
INR1664 ENTER Purge Empty Item Locations 9/08/06 10:35:19 EZK Mail Order
Warehouse . .
# of days . .
*** Press F9 to submit the process to delete Empty Item Locations. ***
F3=Exit F9=Accept F12=Cancel F24=Select company |
Completing this screen:
• Enter the 3-position warehouse number where the item locations should be deleted. This entry is required.
• Enter the number of days required since placement date for an item location to be eligible for deletion. For example, if you enter 45, and an empty item location has a placement date of 50 days ago, it is eligible for deletion.
• Press F9 to submit the PURGITL job.
Purge Order Billing History (POBH)
Purpose: Use this option to purge Order Billing History records on or earlier than a specified date. You also have the option to end journaling in order to improve system performance during the purge.
Purge Order Billing History Screen
How to display this screen: Enter POBH in the Fast path field at the top of any menu, or select Purge Order Billing History from a menu.
CSR1020 ENTER Purge Order Billing History 9/08/06 11:05:05 EZK Mail Order
Purge transactions up to . . . .
End journaling first . . . . . . . . N (Y/N)
F3=Exit F9=Submit F12=Cancel |
Completing this screen:
• Use the Purge transactions up to field to indicate the latest date to purge in the Order Billing History file.
• Use the End journaling first field to indicate whether to end journaling before starting the purge process in order to improve system performance, or allow journaling to continue.
• Press F9 and then press Enter at the confirmation window to submit the PURGE_OBH job and generate the Order Billing History Purge report.
Note: The job is submitted in held status; you will need to release it in order to perform the purge and generate the report.
For more information: For background on the Order Billing History file, see the Order Billing History Detail Screen. Also, see Consolidating Order Billing History (MOBH) for information on consolidating the Order Billing History file.
Purge Orders by Order Number (MORP)
Purpose: Use this option to purge individual orders.
Purge an Order Screen
How to display this screen: Enter MORP in the Fast path field at the top of any menu, or select Purge Orders by Order Number from a menu.
XXR0110 ENTER Purge An Order 9/08/06 13:02:14 EZK Mail Order
Order # . . . .
F3=Exit F12=Cancel |
Purging an order: Enter the order number to purge and enter Y in the Confirm flag to purge the order.
Eligible to purge? The system displays an error message if the order is ineligible for purge. An order is eligible for purge if it is closed, there are no pending transactions or activity such as refunds, and there has been no recent activity within the period specified by the Order Purge Days (C62) system control value. For example, an order might be ineligible for purge for any of the following reasons:
• Order Header not found (Indicates that the order number you entered does not exist.)
• Open R/A for order
• Order Status is Open
• Order not old enough to purge (Indicates that there has been activity against the order within the Order Purge Days (C62))
• Open A/R for order
• Open refund for order
• Order status is Held
If the order is eligible to purge, the system deleted the Order Header and all related files and displays a message indicating that the order has been purged. See Order-Related Files for a list.
| Purged SKU List | Contents | SCVs | Search | Glossary | Reports | Solutions | XML | Index | Purchase Order Purge Listing |
SO05_08 CWDirect 18.0.x 2018 OTN