Accounting Finance:Consolidations

Consolidation Management

• Consolidation rolls G/L balance from multiple originating companies into one corporate company. The corporate company can be an operating company, but it is best if it is not. Consolidation clears records in ANOBAL and rebuilds them. Any G/L numbers or summaries used by the originating companies are cleared; even if the corporate coming is also using them.
• All companies use the same chart of accounts.

Working with General Ledger Consolidations

• Select ASW FastPath→Consolidation Management→Work with Consolidation relationships

Company hierarchy maintenance

• This tells the consolidation how to relate account parts from the originating company to the corporate company. As we use the same structure in all companies, it’s a one to one relationship.

Accounting period relationship

• This tells the consolidation how to relate accounting periods from the originating company to the corporate company. As we use the same periods in all companies, it’s a one to one relationship.

Budget relationship

• This tells the consolidation how to relate budgets (if they are being consolidated) from the originating company to the corporate company.

Consolidation Management Tasks

• Select ASW FastPath→Consolidation Management→Work with Consolidation conversions

Account/Sum id part conversion

• This tells the consolidation process how to map account numbers from the originating company to the corporate company. In most cases, it is a one to one relationship. But there are some that you may want to transfer. For example, inter company transfers.

• Select the account part that is to be mapped from the originating company to the corporate company.
• Note that underscore (_) means any character. In ‘from account number’ it means all values in that column will be accepted. In ‘to account number’ it means the value won’t be converted.
• If you are consolidating into an operating company, an underscore in all positions for all account parts would be a bad thing. As accounts from the originating company would be consolidated to the same account in the corporate company, the analyzer totals would be cleared in the update, and recalculated from the originating company only.
• The accounts for the originating company have to be different than ones used in the operating corporate company. This can be done by either putting a fixed account in a new account part, or by changing a character in one of the account parts in account part conversion.

• Select ASW FastPath→Consolidation Management→Create Interface File
• Note that this must be run from the originating company

Company consolidation

• Enter Accounting year
• Change Conversion report Y
• Change printer queue prt01

• This will create a work file of all analyzer total records for the originating company for the requested year, that fall into the selections made in Account/Sum id part conversion. It will generate two reports.

• Select ASW FastPath→Consolidation Management→Update corporate company (corporate company)
• Note that this must be run from the corporate company

Update corporate company

• This will list consolations waiting to update. Select one and press enter, or, if only one, just press enter.

• The bolded fields must be entered to process correctly.
• The file created in the previous step will be used to recalculate the analyzer totals in the corporate company.

Programming Notes

• Note – in RPG, files prefixed by OR are overridden to the originating company’s SR files.
• 2. Create interface file (originating company)
• GF210 – FSR510 – Consolidation, create interface file - sel.
• FSC511 – Consolidation, create interface file
• FSR511 – Consolidation, create interface file – update (reads from ANOBAL)
• SROCIB – Consolidation interface file - balances
• SROCIP – Consolidation interface file - transactions
• SROCID – Consolidation interface file - différences
• FSR521 – Consolidation, interface conv error - print
• FSR522 – Consolidation, interface conversion - print
• 3. Update corporate company (corporate company)
• GF513 – FSR513 – Consolidation, update - selections
• FSC514 – Consolidation, update corporate comp
• FSR514 – Consolidation, update - retrieve files (1)
• FSC515 – Consolidation, print error report
• FSR515 – Update temp work file FSR515A with exchange rate errors
• FSR521 – Print conversion error report
• FSR522 – Print conversion report
• FSR523 – Consolidation, update exchange rate error (the following programs are only called if updates are requested)
• FSR520 – Consolidation, update - clear/restore BAL/BUD
• FSR514 – Consolidation, update - retrieve files (2)
• FSC516 – Consolidation, translate system curr amount
• FSR516 – Update temporary work file FSR516A with translation differences and update ANOBAL for corporate company
• ANLR908 – Update from interface file ANTBIF - update
• ANLR902 – Update balance values
• FSR524 – Print balance report
• ANLR818 – Delete summary levels for a balance group
• ANLR819 – Create summary levels from a list