Mass Change Customer Numbers

BCT Mass Change Customer Numbers

Purpose

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

Features

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

If you wish to change all your customer numbers, there is no need to input the current customer list. You can simply display the current customer list and input the new customer numbers.
If you have a spreadsheet with the customers you wish to change, you can upload it to our cross reference table without having to input the customer numbers.
The ability to combine multiple records together. We will combine records in the following tables (ArCusFil, OeCusItm, OePrcFil, OeSlsHst)
You may add additional tables to the mass change list of tables.

Updated Tables

Accounts Receivable (ArAltAdr, ArComDue, ArCshApl, ArCshTrx, ArCusAdt, ArCusFil, ArDisFil, ArFchTrx, ArOpnFil, ArOpnHst, ArRecDst, ArRecInv, ArSelCus, ArSlsTrx, ArSrvHst, ArSrvTrx)
Accounts Payable (ApVenAdt, ApVenFil)
Bank Book (BbDepFil)
Bar Coding (BcImpHdr, BcPexHdr)
Capacity Requirements Planning (CrDdtlBl0, CrDtlBl1, CrDtlBl2, CrDtlBl3)
Electronic Data Interchange (EdAcumfl, EdAtpsfilL, EdBccifl, EdCaudfl, EdCcapfl, EdCchgfl, EdCitmfl, EdCsdqfl, EdCshtfl, EdCshvfl, EdCtpfl)
Inventory Management (ImAtpOrd, ImInvTrx)
Master Scheduling (MsFrcFil, MsSchFil)
Manufacturing (HzMcoFil)
Material Requirements Planning (MrLwlFil, MrReqFil)
Order Entry (OeBolFil, OeCshFil, OeCusItm, OeHdrAud, OeHdrHst, OeInqOrd, OeLinAud, OeLinHst, OeOrdHdr, OeOrdLin, OePrcFil, OeRdtFil, OeRdtHis, OeRhdFil, OeRhdHis, OeShpLdt, OeSlsHst)
Production Order Processing (PpOrdAud, PpOrdFil)
Quoting and Estimating (QeCusAud, QeCusFil, QeEstAud, QeEstFil, QeEstHst)
Shop Floor Control (SfOrdAud, SfOrdFil)
System Manager (JobHist, SysNotes, SySeqHst, SyTaxHst, SyTaxTrx)

Supported Versions

Exact Macola Progression version 7.x (SQL)