Mass Change Inventory Item Numbers

BCT Mass Change Inventory Item Numbers

Purpose

The Ability to change an inventory item number to another inventory item number en masse through out the Macola database

Features

Change an unlimited number of item numbers from one item number (characters are supported) to another item number.

If you wish to change all your item numbers, there is not need to input the current item list. You can simply display the current item list and input the new item numbers.
If you have a spreadsheet with the items you wish to change, you can upload it to our cross reference table without having to input the item numbers.
You may add additional tables to the mass change list of tables.

Updated Tables

Accounts Payable (ApTrxDst)
Bar Coding (BcImpHdr, BcPexHdr, BcPexSfc, BcTagFil, BcTagPex)
Bill of Materials (BmEngChg, BmEngHst, BmFtrFil, BmOptExc, BmOptFil, BmPrdAud, BmPrdStr)
Currency Manager (CmPrcCst)
Capacity Requirements Planning (CrDtlBl0, CrDtlBl1, CrDtlBl2, CrDtlBl3, CrOrdBl0, CrOrdBl1, CrOrdBl2, CrOrdBl3, CrTrxHst)
Electronic Data Interchange (EdAblkfl, EdAcumfl, EdAtpqfl, EdAtpsfl, EdCitmfl)
Inventory Management (Im2801st, ImAtpFil, ImAtpOrd, ImBinTrx, ImCapBld, ImCapHst, ImDisFil, ImInvAud, ImInvBin, ImInvHst, ImInvLoc, ImInvTrx, ImInvAdt, ImItmIdx, ImItmNot, ImKitFil, ImLfMst, ImLfTrx, ImLsMst, ImLsTrx, ImOrdBld, ImOrdHst, ImRecHst, ImSht999, ImShtFil, ImSubItm, ImTagFil, ImTagHst, ImTagSub, ImTrxDst)
Labor Performance (LpTrxAud, LpTrxExp, LpTrxFil, LpTrxHst)
Manufacturing (HzMcoFil, HzNotFil, HzNotHst, HzOcFil, HzPlpFil, HzPpVFil, HzPreLod)
Manufacturing Cost Accounting (McDisFil, McTrxFil, McTrxHst)
Master Scheduling (MsFrcFil, MsSchFil)
Material Requirements Planning (MrCpoFil, MrEtfFil, MrExpFil, MrItmFil, MrLwlFil, MrOrdFil, MrPegFil, MrPegWfl, MrPegWfl, MrReqFil, MrSpcItm, MrVpw999)
Order Entry (OeCusItm, OeFboAud, OeLinAud, OeLinHst, OeOptHst, OeOrdDtl, OeOrdLin, OePrcFil, OeRdtFil, OeRdtHis, OeSlsHst)
Purchase Order (PoComFil, PoConFil, PoConHst, PoCshReq, PoInsHdr, PoItmVnd, PoIvAud, PoLinAud, PoLinHst, PoOrdLin, PoQteLin, PoQtrPre, PoQtLnHs, PoReqLin, PoRqLnHs, PoTrxDst, PoTrxFil)
Production Order Processing (PpCstStr, PpCstTrx, PpOrdAud, PpOrdFil, PpOrdTrx)
Quoting and Estimating (QeDtlAud, QeDtlHst, QeEstDtl, QeEstItm, QeItmAud, QeItmHst, QeNotFil, QeNotHst, QeQtyAud, QeQtyFil, QeQtyHst)
Standard Product Costing (ScCstAud, ScCstFil)
Shop Floor Control (SfDtlAud, SfDtlFil, SfOrdAud, SfOrdFil, SfShtFil)
Standard Product Routing (SrDtlAud, SrDtlFil, SrRtgAud, SrRtgFil)
System Manager (JobHist, SyHstLin, SyTaxLin)

Supported Versions

Exact Macola Progression version 7.x (SQL)