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