This chapter contains these topics:
There are two types of purges within the distribution systems:
General purges
Special purges
General purges include the Item History purge, which is a version of the general purge program. The general purge program removes data from the Item History file (F4115). You can create versions of the general purge program to purge data from any JD Edwards World file, although JD Edwards World recommends that you do not use general purges for files that have their own special purge programs. General purges are not designed for files that are associated with data in other files. Running a general purge for such files could cause you to lose important data.
JD Edwards World provides special purges for removing data from files. Special purges are programs that allow you to provide more specific information. Special purges have built-in criteria that the system checks before removing any data. For example, you might want to purge an Item Master record that has an associated record in the Item Location file (F41021). The built-in selection criteria prevent the system from purging the Item Location record.
Each distribution system comes with special purge programs. In Inventory Management, the special purge programs include the following:
Item Deletion (all files associated with items-F4101, F4102, F4111, F4211, and F4311)
Item Master (F4101)
Item Balance (F4102)
Complete the following tasks:
Running the General Purge
Running the Special Purge
Verify that no users are working with the data that you want to purge and reorganize
From Inventory Management (G41), enter 27
From Inventory Advanced and Technical Operations (G4131), choose Global Updates and Purges
From Global Updates and Purges (G41311), choose Item History
To perform a general purge, run the Item History Purge. The Item History Purge is a program that you run when you want to remove a large amount of data and do not need to be concerned with implications for other files. You can use this program to perform either a global or specific purge. To perform a specific purge, specify selection criteria.
Running special purges includes the following tasks:
Running the Item Deletion purge
Running the Item Master purge
Running the Item Balance purge
From Inventory Management (G41), enter 27
From Inventory Advanced and Technical Operations (G4131), choose Global Updates and Purges
From Global Updates and Purges (G41311), choose Item Deletion (All Files)
Run the Item Deletion Purge to permanently remove an item's records from all files in the system except the sales order files (F4211 and F4201). The system deletes any existing sales order detail lines and adjusts the total order amount on the sales order header to account for the deletion. The system also adjusts the "on order" amount in the Billing Instructions file (F4205).
Note:
Item Deletion is an RPGSQL program. Therefore, you must run it in an AS/400 environment.The system deletes the item that you specify from the following files:
| Field | Explanation |
|---|---|
| F0018 | Sales/Use/V.A.T. Tax |
| F3002 | Bill of Materials Master |
| F30026 | Item Cost Component Information |
| F3011 | Bill of Materials Change |
| F3411 | MPS/MRP/DRP Message |
| F3412 | MPS/MRP/DRP Lower Level Requirements |
| F3413 | MPS/MRP/DRP Summary |
| F3460 | Forecast |
| F4008 | Tax Areas |
| F41002 | Unit of Measure Conversion Factors |
| F4101 | Item Master |
| F4102 | Item Branch Master |
| F41021 | Item Location |
| F4104 | Item Cross-Reference |
| F4105 | Item Cost Ledger |
| F4106 | Item Price |
| F4111 | Item Ledger |
| F4115 | Item History |
| F4116 | WF - Inventory Turn Report |
| F41291 | Item Cost Components |
| F4141 | Cycle Count Transactions |
| F4160 | Tag Inventory |
| F42005 | Sales Commission |
| F4201 | Sales Order Header |
| F4209 | Held Orders |
| F4211 | Sales Order Detail |
| F4213 | Sales Order Reprice |
| F4220 | Serial Number - Warranty |
| F4229 | Sales Summary - History |
| F4301 | Purchase Order Header |
| F4311 | Purchase Order Detail |
| F43121 | Purchase Order Receiver |
| F4801 | Work Order Master |
To run the Item Deletion purge
On Item Deletion
1. Complete the following field:
Item No
Delete the item.
The system displays a caution message and indicates the amount by which you will need to adjust the general ledger records if you confirm the deletion.
Confirm the deletion or return to the first form in Item Deletion.
| Field | Explanation |
|---|---|
| Item No | An identifier for an item. |
From Inventory Management (G41), enter 27
From Inventory Advanced and Technical Operations (G4131), choose Global Updates and Purges
From Global Updates and Purges (G41311), choose Item Master (F4101)
The Item Master purge allows you to select and purge specific information from the Item Master file (F4101).
Before purging the records you specify from the Item Master file, the system verifies that the records are not associated with other files. The system will not purge any item information that exists in the following files:
Item Location (F41021)
Item Branch (F4102)
Cost Ledger (F4105)
Lot Master (F4108)
Item Bill of Material (F3002)
Item Routing (F3003)
From Inventory Management (G41), enter 27
From Inventory Advanced and Technical Operations (G4131), choose Global Updates and Purges
From Global Updates and Purges (G41311), choose Item Balance (F4102)
The Item Balance purge allows you to select and purge records that you specify from the Item Branch file (F4102).
Before purging the specified records from the Item Branch file, the system verifies the records using the following criteria. The system will not purge the records if:
Work orders exist in the Work Order Master file (F4801)
A parts list exists in the Work Order Parts List file (F3111)
A bill of materials exists in the Bill of Materials Master file (F3002)
Any secondary locations exist in the Item Location file
There are deleted records from files
There is information in any of the following fields for the item location record:
On-hand
Hard Commitments
Soft Commitments
Back Order Quantity
On Order Quantity
Quantity Outbound (EDI)
Quantity Inbound (EDI)
The system also checks all quantity fields for primary and secondary locations.
After the system determines which Item Balance records are to be purged, the following occurs:
The system verifies the records in the Item Branch file.
The system verifies that all records in the Item Location file (F41021) with the same item and branch have zero quantities.
Next, the system checks the Item Bill of Material, Work Order Parts List, and the Work Order Master files. If it does not use this item and business unit combination in any of these files, the system continues.
The system then starts the purge process.
The system first purges the Item Branch record. If the cost level for this item is 2, the system purges the cost records for this item and branch.
The system then purges the Unit of Measure Conversion records for this item and branch.
Finally, the system purges the Item Location records. If the cost level for this item is 3, the system purges the cost records for this item, branch, location, and lot.
If you have set the processing option to delete all Item Branch information, the following occurs:
The system checks the Item Branch file.
The system starts the purge process.
The system verifies the Item Location file (F41021) to ensure that records with the same item and branch have zero quantities and are not primary bins. If these conditions exist, the system purges these records.
If the cost level for this item is 3, the system purges the cost records for item, branch, location, and lot.
| Topic | Description |
|---|---|
| Saved purged records processing option | If you set this processing option to save, purges performed on the same file and on the same day will be added to the existing library and file. |
| Reorganize file processing option | If you do not set this processing option to automatically submit the Reorganize Files program, you can run it manually at a later time. |