Defining Chart Maps for Consolidated Reporting

Note: Plan the level of detail you need for reporting before setting up the chart of accounts for the reporting company. You can assign an accounting unit for each company or you can assign accounting units that consolidate similar functions across companies.

If your corporation consists of companies that use different charts of accounts, different currencies, or even different fiscal calendars, you can produce consolidated financial reports with the chart mapping feature. Use this procedure to define a chart map for consolidated reporting.

Before you can use chart mapping, you must set up a reporting company, its accounting structure, and its chart of accounts. The reporting company should have no other function than to produce consolidated reports for companies mapped to it. If the companies have different currencies, you will also need to set up currency relationships and translation rates.

Note: Use Chart Map Maintenance (GL35.1) to maintain a chart map.

To define a chart map for consolidated reporting

Run Chart Map Creation (GL130) to create a chart map from each posting company to the reporting company. Use the following guidelines to enter field values:

From Company

Select the company whose chart of accounts must be mapped to a "parent" (reporting) chart of accounts. Must be a valid company in the General Ledger application with a defined chart of accounts.

To Company

Select the "parent" (reporting) company to which the "From Company" chart of accounts is to be mapped. Must be a valid company in the General Ledger application with a defined chart of accounts.

Update

To create the map without updating the database records select N (Report Only). Lawson recommends running GL130 in nonupdate mode first to avoid creating unnecessary records in your General Ledger application.

To map each posting account in the posting company (identified in the From Company field) to a corresponding posting account in the reporting company (identified in the To Company field), select Y (Update and Report).