Mass Change GL Account Numbers

BCT Mass Change GL Account Numbers

Purpose

The Ability to change a general ledger account to another general ledger account en masse through out the Macola database

Features

Change an unlimited number of general ledger accounts from one general ledger account number (characters are supported) to another general ledger account number.

If you wish to change you entire chart of accounts, there is not need to input the current account list. You can simply display the current chart of accounts and input the new accounts.
If you have a spreadsheet with the accounts you wish to change, you can upload it to our cross reference table without having to input the accounts.
The ability to combine multiple accounts together. We will combine records in the following tables (ApDisFil, ArDisFil, CheckRec, FxDisFil, GlBudFil, GlCmpFil, GlTrxFil, GlTrxHst, ImDisFil, JobHist, McDisFil, PrDisFil, SyActAdt, SyActFil, SyCshFil)
You may add additional tables to the mass change list of tables.

Updated Tables

Accounts Payable (ApAdjTrx, ApCtlFil, ApDisFil, ApOpnFil, ApOpnHst, ApRecDst, ApRecVch, ApTrxDst, ApTrxFil, ApVenDst, ApVenTyp, CheckRec)
Accounts Receivable (ArCshApL, ArCshTrx, ArCtlFil, ArDisFil, ArOpnFil, ArOpnHst, ArRecDst, ArSlsDst, ArSrvFil, ArSrvHst, ArSrvTrx, ArTypFil)
Assets and Depreciation (FxDisFil, FxDisSeq, FxTblFil)
Bank Book (BbDepFil, BbDepHdr, BbDisFil, BbOpnFil, BbStmFil, BbTrxFil, BbTypFil)
Currency Manager (CmCurCod)
General Ledger (GlBalFil, GlBudFil, GlCmpFil, GlCtlFil, GlDistCd, GlGenTrx, GlIntTFil, GlLayout, GlRecTrx, GlTrxFil, GlTrxHst, GlXRefFil)
Inventory Management (ImCtlFil, ImDisFil, ImLocFil, ImTrxDst, ImTypLoc)
Labor Performance (LpCtlFil, LpErnAud, LpErnFil, LpErnHst)
Manufacturing (HzCdeFil, HzCtlFil, HzCtrAct, HzEmpAud, HzEmpPer, HzPlpFil, HzPpvFil)
Manufacturing Cost Accounting (McDisFil)
Order Entry (OeCcCtl_sql, OeCshFil, OeCtlFil, OeHdrAud, OeHdrHst, OeOrdHdr, OePrdAct, OePrePay)
Purchase Order (PoCtlFil, PoLinAud, PoLinHst, PoLndCst, PoOrdLin, PoPurCst, PoTrxDst, PoTrxFil)
Production Order Processing (PpCstCap, PpCstFil, PpCstStr, PpCstTrx, PpCtlFil)
Payroll (PrActFil, PrDisFil)
System Manager (CompFile, JobHist, SyActAdt, SyActFil, SyCdeFil, SyCshFil, SysNotes, TaxDetl)

Supported Versions

Exact Macola Progression version 7.x (SQL)