Deleting Item Codes

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

JCM record exists for the item

JCM

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

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
JCM record exists for the item	JCM
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