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 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