Deleting Item Codes Home | FAQs & Troubleshooting

 

If an item code is selected for deletion, the Purchase Order, Sales Order, Sales Kit, Bill of Materials, Job Cost, Return Merchandise Authorization, eBusiness Manager, and Production Management files are checked for that item code. Item codes are also checked for quantities on hand if the Inventory file, Warehouse Detail, or Item Costing Detail records are selected for deletion.

Note If the item code or quantities on hand are found, the deletion is not performed and a message is printed on the Delete and Change Items Listing.

The following table shows which records and data files Delete and Change Items checks.

Delete will not occur if the following is true:	Data File Checked
CI_Item, TotalQuantityOnHand is not 0	CI_Item
Any quantity or TotalWarehouseValue on any IM_ItemWarehouse record	IM_ItemWarehouse
IM_ItemWarehouse record exists and the user does not have rights to delete an item warehouse record	IM_ItemWarehouse
IM_ItemCost record exists for the item	IM_ItemCost
IM_ItemTransactionHistory record exists for the item	IM_ItemTransactionHistory
IM_LotSerialTransactionHistory record exists for the item	IM_LotSerialTransactionHistory
IM_ItemWhseHistoryByPeriod record exists for the item with any quantity or value	IM_ItemWhseHistoryByPeriod
IM_ItemCustomerHistoryByPeriod record exists for the item with any quantity or value	IM_ItemCustomerHistoryByPeriod
IM_ItemVendorHistoryByPeriod record exists for the item with any quantity or value	IM_ItemVendorHistoryByPeriod
IM_SalesKitDetail record exists for the item	IM_SalesKitDetail
IM_SalesKitHeader record exists for the item	IM_SalesKitHeader
BM_BillHeader record exists and BillType is S (Standard bill)	BM_BillHeader
BM_BillDetail record exists for the item	BM_BillDetail
BM_BillOptionDetail record exists for the item	BM_BillOptionDetail
BM_OptionInteractionDetail record exists for the item	BM_OptionInteractionDetail
Estimate record exists for the item	JC_JobEstimateDetailAssy
Item used as parent, material, or substitute item	PM_TransactionDetail
Material record exists for the item	PM_DailyMaterialUsage
Item used as parent item on work ticket	PM_WorkTicketHeader
Item used as parent item on work ticket	PM_WorkTicketHistoryHeader
Item used on work ticket material line	PM WorkTicketDetail
Item used on work ticket material line	PM WorkTicketHistoryDetail
Item used on work ticket template material line	PM_TemplateMaterials
Transaction record exists for item and PM Transaction entry is in progress	PM_TransactionTierDist
RA_DeleteRenumberMergeXref record exists for the item	RA_DeleteRenumberMergeXref
RA_ReturnDetail record exists for the item	RA_ReturnDetail
IT_ShoppingCartDetail record exists for the item and the corresponding IT_ShoppingCartHeader status is not equal to “T”	IT_ShoppingCartDetail
The item is included on a SO_SalesOrderDetail record	SO_SalesOrderDetail
The item is included on a PO_PurchaseOrderDetail record	PO_PurchaseOrderDetail