Taking out old part numbers

LX uses Product Lifecycle Control codes to manage and restrict the use and processing of items based on where they are in their life cycle. Each lifecycle control code includes flags that allow you to specify restrictions individually for a number of basic transactions. The Product Life Cycle code is entered in the Item Master and is a global value. However, overrides are available on an Item/Facility (CIC) and Item/Warehouse basis (IWI). The system stores lifecycle control codes in the PLC Code Master file, ILC. The restriction values for PLC codes are: 1=Allowed, 2=Not Allowed, 3=Allowed with Warning.

LX 8.3.3 has Product Life Cycle functionality as basic functionality. This functionality is available to ERP Lx 8.3.2 FP2 customers via BMR 72269.

LX 8.3.3 has an Action Function 17=Delete Validation Report. This report determines when deletion of an Item is Allowed or Not Allowed. This routine checks the files listed below to determine if active records exist, which would prevent deletion of an item.
---------------------------------------------------
Delete Condition Exists?
---------------------------------------------------
Customer Invoice
Sales History
Customer Order Line
RMA Line
Quote Line
Free Goods Item
Packaging
Inventory Balance
Customer Allocation
Production Allocation
Alternate Item
Unit of Measure Conversion
Bill of Materials
Bill of Materials component
Planning Bill parent
Planning Bill component
Configuration Structure
Configuration Structure child
Routing
Item/Manufacturer
Purchase Order Line
Planned Order
Planned Requirement
Material Allocation
Shop Order
Campaign
Cost Master
Physical Inventory Tag
Cycle Count
Integration setup

If you are considering a hard delete to an Item Master or updating the status to Inactive on versions previous to 8.3.2, you should run SQL statements to determine if active records exist in the above listed files, before using SQL delete or update statements to either delete the Item Masters or set them as inactive.

Best Regards,

Gerry Duhon, CPIM | Sr. Application Consultant, Supply Chain & Manufacturing, ERPLX & BPCS | Infor Professional Services | Cell:815.347.0754 | Home Office:484.341.8225 |Gerry.Duhon@xxxxxxxxx

From:
"Don Cavaiani" <dcavaiani@xxxxxxxxxxxxx>
Subject:[Gerry Duhon, CPIM] [BPCS-L] Taking out old part numbers



No vendors please.

Any warnings/caveats regarding use of strsql to delete very old part
numbers out of the database -e.g., IIM/CIC/HPO/MBM/ITH/ECH/ECL/FSO/FOD/FRT
.....???

TIA

Don F. Cavaiani
IT Manager
Amerequip Corp.
920-894-7063

"It's amazing what you can accomplish if you don't care who gets the
credit." Harry S. Truman