Renumbering Item Codes

When using wildcards to renumber accounts, the wildcard is used to replace, but not remove, a character. For example, if the starting and ending numbers are 1A*** and the new number is 1B***, all numbers starting with 1A will then begin with 1B; however, if the starting and ending numbers entered are 1A*** and the new customer number entered is 1***, the numbers remain 1A**. In this example, the last asterisk (*) is dropped, but the "A" is not omitted because the wildcard indicates that all numbers in this range remain the same.

When renumbering an inventory item, the item is checked to make sure it exists. Also, you cannot renumber an item to a number that already exists. After the following tables are checked, the Delete and Change Items utility updates the records.

Table

Field

AP_InvoiceHistoryDetail

Item Code

AR_Customer

Item Code

AR_InvoiceHistoryDetail

Item Code

AR_TrackingByItemHistory

Item Code

BM_BillDetail

Bill Number

BM_BillHeader

Bill Number

BM_BillOptionCategory

Bill Number

BM_BillOptionDetail

Bill Number

BM_BillOptionHeader

Bill Number

BM_BillWhereUsed

Bill Number

BM_OptionInteractionDetail

Bill Number

BM_OptionInteractionHeader

Bill Number

BM_OptionInteractionWhereUsed

Bill Number

BM_ProductionHistoryDetail

Bill Number

BM_ProductionHistoryHeader

Bill Number

CI_Item

Item Code

CI_ItemTransactionHistory

Item Code

IM_AliasItem

Item Code

IM_AlternateItem

Item Code

IM_Audit

Item Code

IM_DataEntryCostCalcCommit

Item Code

IM_ItemCost

Item Code

IM_ItemCostCalcSource

Item Code

IM_ItemCustomerHistoryByPeriod

Item Code

IM_ItemTransactionHistory

Item Code

IM_ItemVendor

Item Code

IM_ItemVendorHistoryByPeriod

Item Code

IM_ItemWarehouse

Item Code

IM_ItemWhseHistoryByPeriod

Item Code

IM_LotSerialTransactionHistory

Item Code

IM_PeriodPostingHistory

Item Code

IM_PriceCode

Item Code

IM_SalesKitDetail

Item Code

IM_SalesKitHeader

Item Code

IT_Item

Item Code

IT_ItemAttachment

Item Code

IT_ItemCategory

Item Code

IT_ShoppingCartAutoLogDtl

Item Code

IT_ShoppingCartItemsSelected

Item Code

JCI Job Estimate Line Detail

Item Code

JCJ Job Estimate Item Price File

Item Code

JCM Job Estimate Line Detail - Item Price

Item Code

MP2 Projected Demands

Item Code

PO_OpenOrderDetailByItem

Item Code

PO_PurchaseOrderDetail

Item Code

PO_PurchasesHistory

Item Code

PO_ReceiptHistoryDetail

Item Code

PO_ReceiptHistoryLotSerial

Item Code

PO_VendorPriceLevel

Item Code

RA_DeleteRenumberMergeXref

Item Code

RA_Options

Item Code

RA_ReceiptsHistoryDetail

Item Code

RA_RepairDetail

Item Code

RA_ReturnDetail

Item Code

RA_ReturnReasonDetail

Item Code

RA_ReturnReasonLotSerial

Item Code

SO_LastPurchaseHistory

Item Code

SO_LotSerialHistory

Item Code

SO_OpenOrderDetailByItem

Item Code

SO_PackageTrackingByItem

Item Code

SO_SalesHistory

Item Code

SO_SalesOrderDetail

Item Code

SO_SalesOrderDropShip

Item Code

SO_SalesOrderHistoryDetail

Item Code

SO_ShippingQtyByItem

Item Code

WO_WorkOrder WO1

Item Code

WO_WorkOrder WO2

Item Code

WO5 WorkOrderTemplateMaster

Item Code

WO6 WorkOrderTemplateDetail

Item Code

WO9 WorkOrderCostLedger

Item Code

WOY WorkOrderGenericSort

Item Code

Table	Field
AP_InvoiceHistoryDetail	Item Code
AR_Customer	Item Code
AR_InvoiceHistoryDetail	Item Code
AR_TrackingByItemHistory	Item Code
BM_BillDetail	Bill Number
BM_BillHeader	Bill Number
BM_BillOptionCategory	Bill Number
BM_BillOptionDetail	Bill Number
BM_BillOptionHeader	Bill Number
BM_BillWhereUsed	Bill Number
BM_OptionInteractionDetail	Bill Number
BM_OptionInteractionHeader	Bill Number
BM_OptionInteractionWhereUsed	Bill Number
BM_ProductionHistoryDetail	Bill Number
BM_ProductionHistoryHeader	Bill Number
CI_Item	Item Code
CI_ItemTransactionHistory	Item Code
IM_AliasItem	Item Code
IM_AlternateItem	Item Code
IM_Audit	Item Code
IM_DataEntryCostCalcCommit	Item Code
IM_ItemCost	Item Code
IM_ItemCostCalcSource	Item Code
IM_ItemCustomerHistoryByPeriod	Item Code
IM_ItemTransactionHistory	Item Code
IM_ItemVendor	Item Code
IM_ItemVendorHistoryByPeriod	Item Code
IM_ItemWarehouse	Item Code
IM_ItemWhseHistoryByPeriod	Item Code
IM_LotSerialTransactionHistory	Item Code
IM_PeriodPostingHistory	Item Code
IM_PriceCode	Item Code
IM_SalesKitDetail	Item Code
IM_SalesKitHeader	Item Code
IT_Item	Item Code
IT_ItemAttachment	Item Code
IT_ItemCategory	Item Code
IT_ShoppingCartAutoLogDtl	Item Code
IT_ShoppingCartItemsSelected	Item Code
JCI Job Estimate Line Detail	Item Code
JCJ Job Estimate Item Price File	Item Code
JCM Job Estimate Line Detail - Item Price	Item Code
MP2 Projected Demands	Item Code
PO_OpenOrderDetailByItem	Item Code
PO_PurchaseOrderDetail	Item Code
PO_PurchasesHistory	Item Code
PO_ReceiptHistoryDetail	Item Code
PO_ReceiptHistoryLotSerial	Item Code
PO_VendorPriceLevel	Item Code
RA_DeleteRenumberMergeXref	Item Code
RA_Options	Item Code
RA_ReceiptsHistoryDetail	Item Code
RA_RepairDetail	Item Code
RA_ReturnDetail	Item Code
RA_ReturnReasonDetail	Item Code
RA_ReturnReasonLotSerial	Item Code
SO_LastPurchaseHistory	Item Code
SO_LotSerialHistory	Item Code
SO_OpenOrderDetailByItem	Item Code
SO_PackageTrackingByItem	Item Code
SO_SalesHistory	Item Code
SO_SalesOrderDetail	Item Code
SO_SalesOrderDropShip	Item Code
SO_SalesOrderHistoryDetail	Item Code
SO_ShippingQtyByItem	Item Code
WO_WorkOrder WO1	Item Code
WO_WorkOrder WO2	Item Code
WO5 WorkOrderTemplateMaster	Item Code
WO6 WorkOrderTemplateDetail	Item Code
WO9 WorkOrderCostLedger	Item Code
WOY WorkOrderGenericSort	Item Code