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