Ledger Consolidation File Creation (ML320)

Run Ledger Consolidation File Creation (ML320) to rebuild the consolidation file that is used by Multi-Book Ledger and Report Writer to consolidate balances for reporting. The MLCONSOL (UNIX/Windows) or DBMLMCN (IBM i) file is maintained automatically by the Multi-Book Ledger application. This program is provided for use in the event of unusual circumstances.

Note: For UNIX/Windows platforms: If the MLAMOUNTS, MLUNITS, or MLCUAMOUNT balances are corrupted, you must rebuild those file balances before you run this program. Use Ledger AMOUNTS, UNITS Rebuild (ML325) to rebuild MLAMOUNTS and MLUNITS balances. Use Ledger Report Currency Rebuild (ML327) to rebuild MLCUAMOUNT balances. Use Ledger Undistributed RE Rebuild (ML330) to rebuild retained earnings.
Note: For IBM i platform: If the DBMLMLA, DBMLMLU, or DBMLMCA balances are corrupted, you must rebuild those file balances before you run this program. Use Ledger AMOUNTS, UNITS Rebuild (ML325) to rebuild DBMLMLA and DBMLMLU balances. Use Ledger Report Currency Rebuild (ML327) to rebuild DBMLMCA balances. Use Ledger Undistributed RE Rebuild (ML330) to rebuild retained earnings.

More information

The time needed to run this program depends on the number of accounts and budgets a company has. The program runs faster if you run it for an amount type.

For UNIX/Windows platforms: This program prints a report giving you the following information:

  • The total MLAMOUNTS, MLUNITS, and MLCUAMOUNT records processed, and the total MLCONSOL records created for each company.

    The MLCUAMOUNT records are further broken down by Account Currency, Report Currency One, and Report Currency Two

  • The total MLAMOUNTS, MLUNITS, and MLCUAMOUNT records processed, and the total MLCONSOL records created for all the companies involved in the rebuild.

For IBM i platform: This program prints a report giving you these information:

  • The total DBMLMLA, DBMLMLU, and DBMLMCA records processed, and the total DBMLMCN records created for each company.

    The DBMLMCA records are further broken down by Account Currency, Report Currency One, and Report Currency Two

  • The total DBMLMLA, DBMLMLU, and DBMLMCA records processed, and the total DBMLMCN records created for all the companies involved in the rebuild.