Reviewing the Style Item Balance Purge Report

Select Apparel Advanced and Technical Ops (G41F31), Style Item Balance Purge.

Use the Style Item Balance Purge report (RCW33) to purge the style item branch records that are stored in the following tables:

  • Item Cost File (F4105).

  • Item Units of Measure Conversion Factors (F41002).

  • Item Location File (F41021).

  • Item Cost Component Add-Ons (F30026).

  • Supplier Price/Catalog File (F41061).

  • Supplier/Item Relationships (F43090).

  • Price List Detail (FCW34).

  • Copy to Outsource Operations for Style Items (FCW93).

  • Supplier Price/Catalog File - Detail (FCW71).

You can define whether to delete the multiple-level style item branch records based on the Delete Complete Levels processing option on the Process tab of the Style Item Master Balance Purge report. In addition to the Delete Complete Levels processing option, the system does the following validations before purging an item balance record:

  • Work orders do not exist in the Work Order Master File (F4801).

  • Parts list does not exist in the Work Order Parts List (F3111).

  • Bill of material does not exist in the Bill of Material Master File (F3002).

  • Any secondary locations do not exist in the Item Location File (F41021).

  • Data is not present 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)

You can opt for printing a detailed log report of the style item balance records that cannot be purged by setting up the Detail Log Report processing option on the Process tab of the Style Item Balance Purge report.

Note: You can delete only style item balance records using the Style Item Balance Purge report. To delete standard JD Edwards EnterpriseOne items balance records, you must use the Item Balance Purge (F4102) report (R4102P).

See "Running the Item Balance Purge" in the JD Edwards EnterpriseOne Applications Inventory Management Implementation Guide.