:: Home   :: Contact us   :: Feedback   :: Site Map  
Customer Mass Change
| About us | Products | Services | Utilities | Portals

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.

The following tables are updated:

 
  • 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 - Macola Progression 7.x SQL

More Info - For more information contact BCT  ( More... )


Copyright ⓒ 2006 Business Computer Technologies, Inc. All rights reserved