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 Work Order 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
WOX record exists for the item in a Work Order template
WOX
WOX record exists for the item in a work order
WOX
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
