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

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.

The following tables are updated:

 
 
  • 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 - Macola Progression 7.x (SQL Only)
More Info - For more information contact BCT  ( More... )


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