Mass Change Vendor Numbers

BCT Mass Change Vendor Numbers

Purpose

The Ability to change a vendor from one vendor number to another vendor number en masse through out the Macola database

Features

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

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

Updated Tables

Accounts Payable (ApVenFil, ApAdjTrx, ApAltAdr, ApBnkFil, ApDisil, ApOpnFil, ApOpnHst, ApRecDst, ApRecVch, ApTrxFil, ApVenAdt, ApVenDst, CheckRec)
Accounts Receivable (ArCusAdt, ArCusFil)
Assets and Depreciation (FxAcqAst, FxAstFil, FxCngAst)
Bank Book (BbOpnFil)
Bar Coding (BcImpHdr, BcPexHdr)
Capacity Requirements Planning (CrDdtlBl0, CrDtlBl1, CrDtlBl2, CrDtlBl3)
Electronic Data Interchange (EdCtp_Fl)
Inventory Management (ImAtpOrd, ImInvAud, ImInvLoc, ImInvTrx,
ImOrdBld, ImOrdHst, ImRecHst)
Manufacturing (HzEqpFil, HzMcoFil, HzOcFil, HzPpvFil)
Manufacturing Cost Accounting (McDisFil, McTrxFil, McTrxHst)
Material Requirements Planning (MrItmFil, MrLwlFil, MrReqFil)
Master Scheduling (MsFrcFil, MsSchFil)
Order Entry (OeLinAud, OeLinHst, OeOrdLin)
Purchase Order (PoComCde, PoComFil, PoConFil, PoConHst, PoCshReq, PoHdrAud, PoHdrHst, PoInsHdr, PoItmVnd, PoIvAud, PoLinAud, PoLinHst, PoLndCst, PoOrdHdr, PoOrdLin, PoPrpVen, PoPurCst, PoQteHdr, PoQtePre, PoQtHdHs, PoReqLin, PoRqLnHs, PoTrxDst, PoTrxFil)
Quoting and Estimating (QeDtlAud, QeDtlHst, QeEstDtl)
Shop Floor Control (SfDtlAud, SfDtlFil)
Standard Product Routing (SrDtlAud, SrDtlFil)
System Manager (JobHist, SysNotes, SyTaxHst, SyTaxTrx)

Supported Versions

Exact Macola Progression version 7.x (SQL)