Difference between revisions of "Information Systems:Company consolidation"
(Created page with "=Company Consolidation== Consolidation rolls G/L balances from multiple originating companies into one corporate company. The corporate company can be an operating company,...") |
|||
| Line 1: | Line 1: | ||
| − | =Company Consolidation |
+ | =Company Consolidation= |
Consolidation rolls G/L balances 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 company is also using them. |
Consolidation rolls G/L balances 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 company is also using them. |
||
Revision as of 10:52, 19 October 2015
Company Consolidation
Consolidation rolls G/L balances 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 company is also using them.
All companies use the same chart of accounts. To differentiate them in the corporate company, we have activated account part 6 as ‘company’. The consolidation relationships are configured to automatically populate account part 6 with the two character company code.
Management Tasks
To go to the Consolidation Menu, key in -
goto CONSOL
Select option ‘Work with consolidation relationships’.
*DV/480B* Company hierarchy maintenance 7/14/11 11:11:48 FSR50002
Account/summary id part relationship
------------------------------------------------------------------------------
Originating company. DV Test Company - DV
Corporate company... PL Test Company - PL
------------------------------------------------------------------------------
Corporate company or Originating company
Account parts Fixed account from Account part or Sum id part
Main................ 1
Grou................ 2
Subg................ 3
Cost................ 4
Pro................. 5
Co.................. I1
Copy balance types Actual Budget
System currency..... Y Y
Transaction currency Y Y
Quantity............ Y Y
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. Except for account part 6; which is populated with the company code.
*DV/480B* Company hierarchy maintenance 7/14/11 11:16:52 FSR50003
Accounting period relationship
------------------------------------------------------------------------------
Originating company. DV Test Company - DV
Corporate company... PL Test Company - PL
------------------------------------------------------------------------------
Originating company Corporate company
Copy period 1 to... 1
Copy period 2 to... 2
Copy period 3 to... 3
Copy period 4 to... 4
Copy period 5 to... 5
Copy period 6 to... 6
Copy period 7 to... 7
Copy period 8 to... 8
Copy period 9 to... 9
Copy period 10 to... 10
Copy period 11 to... 11
Copy period 12 to... 12
Copy period 13 to... 13
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.
*DV/480B* Company hierarchy maintenance 7/14/11 11:18:15 FSR50004
Budget relationship
------------------------------------------------------------------------------
Originating company. DV Test Company - DV
Corporate company... PL Test Company - PL
------------------------------------------------------------------------------
Originating Corporate
Budget selection 1. -
Budget selection 2. -
Budget selection 3. -
Budget selection 4. -
Budget selection 5. -
Budget selection 6. -
Budget selection 7. -
Budget selection 8. -
Budget selection 9. -
Budget selection 10. -
Budget selection 11. -
Budget selection 12. -
Budget selection 13. -
Budget selection 14. -
Budget selection 15. -
This tells the consolidation how to relate budgets (if they are being consolidated) from the originating company to the corporate company.
Select option ‘Work with consolidation conversions ‘.
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 transform. For example, inter company transfers.
*DV/480B* Account/Sum id part conversion table 7/14/11 11:23:42 FSR50101
------------------------------------------------------------------------------
Originating company. DV Test Company - DV
Corporate company... PL Test Company - PL
------------------------------------------------------------------------------
Corporate company Originating company
Account parts Fixed account Account part Sum id part
1 Main................ 1
Grou................ 2
Subg................ 3
Cost................ 4
Pro................. 5
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.
*DV/480B* Account/Sum id part conversion table 7/14/11 11:24:57 FSR50104
------------------------------------------------------------------------------
Originating company. DV Test Company - DV
Corporate company... PL Test Company - PL
------------------------------------------------------------------------------
Originating company Corporate company Copy balance types
Main Main Actual Budget
From account number To account number Amt Cur Qty Amt Cur Qty
______ ______ Y Y Y Y Y Y
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 analyser 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 option ‘Create interface file (originating company)’. Note that this must be run from the originating company.
*DV/480B* Company consolidation 7/14/11 11:56:40 FSR51001
------------------------------------------------------------------------------
Originating company. DV Test Company - DV
Corporate company... PL Test Company - PL
-----------------------------------------------------------------------------
Selection
Accounting year..... 12 - 12
Conversion report... Y
Remarks.............
Printer queue....... PRT01
Number of copies.... 1
Hold on spool file.. N
This will create a work file of all analyser 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.
*DV/480B* COMPANY CONSOLIDATION CONVERSION ERROR REPORT
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Originating company. DV Test Company - DV
Corporate company... PL Test Company - PL
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Error codes:
A) Account number does not exist
B) Account number must have an active status
C) Account number must be an entry account
D) Account number must be entered for this combination
E) Account number must not be entered for this combination
F) Account combination not retrieved
Remarks............. SHEILAV
*DV/480B* COMPANY CONSOLIDATION CONVERSION ERROR REPORT
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Originating company. DV Test Company - DV
Corporate company... PL Test Company - PL
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
<------Part 1------> <------Part 2------> <------Part 3------> <------Part 4---
<----Sum id 12--
*** NO RECORDS FOUND ***
No errors found, consolidation can be performed
*** End of list ***
*DV/480B* COMPANY CONSOLIDATION CONVERSION REPORT
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Originating company. DV Test Company - DV
Corporate company... PL Test Company - PL
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
---Part 1----> <----Part 2----> <----Part 3----> <----Part 4--- ---Part 5-
From... 100200
To..... 100200
From... 120000
To..... 120000
From... 122000
To..... 122000
From... 210000
To..... 210000
From... 540000 1000 1500 1510 ***
To..... 540000 1000 1500 1510 ***
From... 580000 1000 1500 1510 ***
To..... 580000 1000 1500 1510 ***
From... 580100 1000 1500 1510 ***
To..... 580100 1000 1500 1510 ***
Select option ‘Update corporate company (corporate company)’. Note that this must be run from the corporate company.
*PL/480B* Update corporate company 7/14/11 12:17:37 FSR51301
------------------------------------------------------------------------------
Corporate company... PL Test Company - PL
------------------------------------------------------------------------------
Co cde Short name Status Errors Included years
DV *DV/480B* New No interface file errors 2012 - 2012
This will list consolations waiting to update. Select one and press enter, or, if only one, just press enter.
*PL/480B* Update corporate company 8/19/11 10:39:22 FSR51304
------------------------------------------------------------------------------
Corporate company... PL Test Company - PL
------------------------------------------------------------------------------
Selection
From Accounting year 12
Update despite error N Conversion report... N
Balances
Consolidate balances Y Current exch rate... M M 1108
Average exch rate... M M 1108
Historic exch rate.. M M
Rebuild all G/L bals Y Select voucher types
Budgets
Consolidate budgets. N Budget exch rate....
Remarks.............
Printer queue....... PRT01
Number of copies.... 1
Hold on spool file.. N
The bolded fields must be entered to process correctly.
The file created in the previous step will be used to recalculate the analyser totals in the corporate company. Issues
It appears that the custom summary levels are not correct in the Analyser opening balance file. See Problems / Finance / G/L Balances do not Roll Over in this manual for a description, and how to fix them. Programming Notes
Note – in the RPG programs, 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 - differences
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
ANLR820 – Delete opening balances (ANOBOB)
ANLR822 – Delete balances (ANOBAL)
ANLR850 – Rebuild opening balances (ANOBOB)
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
ANLR900 – Update opening balances
FSR524 – Print balance report
ANLR818 – Delete summary levels for a balance group
ANLR819 – Create summary levels from a list