Related topics
This routine performs the actual update of the originating company data into the corporate company, and it can only be reached if you are in a corporate company.
All originating companies connected to the corporate company in which you are working are listed on this panel. You can select one or several originating companies to update by using the Select option for each and one of them. You can also select all by simply clicking Select all.
One accounting period or a period range can be updated at a time. You can perform the update in two ways:
| Automatically (Automatic update on the detail panel is set to YES) | ||||
| This means that the retrieval of G/L transactions and the update of the corporate company is performed immediately and automatically. Note: An automatic update can end up in journal in error, e.g. if the account structure is incomplete. | ||||
| Manually (Automatic update on the detail panel is set to NO) | ||||
This means that the routine must be performed manually in two steps:
|
Options
| Select | Select this option to update an originating company. |
Function keys
| Select all | Select all available originating companies. |
Selection fields
- Company
- This column lists the codes of the originating companies.
- Short name
- This column lists the descriptive short names of the originating companies.
- Year
- This column lists for each related originating company the year when the interface file was latest created.
- Status
- This column lists for each related originating company the status/result of the latest creation of the interface file.
- Period
- This column lists for each related originating company the period for the latest corporate company update.
- Upd
- This column indicates if the latest corporate company update for the related originating company was performed automatically.
- Rev
- This column indicates if an automatic revaluation was performed at the latest automatic corporate company update.
Update corporate company (FSR51304)
On this panel you define the conditions for the consolidation.
Function keys
| Select single period/period range | Toggle between the possibility to select a period range or a single accounting period. |
Selection
- Accounting period
- Select the accounting period for the corporate company in which the balances and/or budgets should be consolidated. Budgets will be consolidated, in one run, from the selected “from” period up to and including year end values. Values are retrieved from the originating company’s consolidation data. The period is defaulted from the oldest previous period for the selected originating company(ies), but can be changed.
Note: Old balances for the corporate company of the selected accounting period are not cleared, but old budget values will be cleared from the requested “from” period and for the rest of the year. Transfer of budget values will immediately update the Budget file (ANOBUD) in the corporate company.
Note: Toggle Select single period/period range to select a period range.
- Conversion report
- Indicate if you want a conversion report printed, with the accounts that have been converted successfully. The report does not show any balances on the accounts.
Balances
- Consolidate period
- Set to YES if you want to consolidate the balances into the corporate company. Set to NO if you want to leave the balances as they are.
- Current exch rate
- Enter the period code for DAY, WEEK, MONTH or YEAR, and the level code for HIGH, MEDIUM, or LOW and the period for the current exchange rate from the corporate company. The rate type to be used is to be defined on main account level in the originating company in Consolidation type in the Chart of accounts.
Note: If other exchange rate parameters have been entered in the Consolidation transfer control file for a specific originating company, then those parameters will be used instead.
- Total period update
- This field allows you to perform multiple updates to the same period in the corporate company. Normally, the transfer from the originating company will only update the corporate company with new transactions, but for whatever reason, it can be necessary to re-run a total update. The default is NO.
- If NO:
The system calculates and updates the interface file (SROIBT) with the difference.
- If YES:
The interface file (SROIBT) is updated with the new transferred values for the selected period and company(ies); all period values are transferred once again (new G/L transactions are created).Note: Old updated values must be eliminated for the selected period(s), if any. You can do this either manually in the Copy/eliminate G/L journals program, or let the system do it automatically by setting Auto elimination on this panel to YES.
- If NO:
- Average exch rate
- Enter the period code for DAY, WEEK, MONTH or YEAR, and the level code for HIGH, MEDIUM, or LOW and the period for the average exchange rate from the corporate company. The rate type to be used is to be defined on main account level in the originating company in Consolidation type.
- Auto elimination
- The default is NO. Indicate if you want to automatically remove all old transactions and balances for the selected originating company(ies) and current period(s) during a new total update. If you enter YES, then Total period update must be YES.
Note: Revaluation performed in the corporate company for transactions transferred from the originating company(ies) will not be removed. Removal of one or several vouchers will cause gaps in the voucher number series. And, it will not be necessary to run the Rebuild balances from transactions routine afterwards.
- Historic exch rate
- Enter the period code for DAY, WEEK, MONTH or YEAR, and the level code for HIGH, MEDIUM, or LOW for the historic exchange rate from the corporate company. The rate type to be used is to be defined on main account level in the originating company in Consolidation type. Note: The exact exchange rates must exist in the Exchange rates table for all selected companies with a foreign system currency.
- Auto revaluation
- This field is defaulted with YES if all the selected originating companies with a foreign system currency were automatically revalued in their latest runs. Note that all of them must have had YES in this field at that time. Otherwise, NO is defaulted.
Indicate if you want the G/L revaluation routine to automatically start after transferring accountings for selected period(s) and originating company(ies) when running an automatic update. Note: This field can only be set to YES if:
- at least one of the selected originating companies has another system currency than the corporate company,
- Automatic update on this panel is YES,
- a code to identify the company is defined for all selected originating companies as a fixed account (in the same account part) in Work with consolidation company hierarchy,
- the account part for the fixed account is defined in the Consolidation transfer control file,
- the voucher type to be used is defined in the Consolidation transfer control file or below on this panel, and
- no journals in error exist for any originating company. If transactions exist in journal in error, an automatic revaluation will only be performed if Auto elimination on this panel is YES.
- Voucher type
- Enter a voucher type to be used in the Automatic revaluation routine (Auto revaluation on this panel must be YES) for all selected valid originating companies at update. Mandatory entry if a voucher type is not entered for all selected originating companies with a foreign system currency in the Consolidation transfer control file.
- Automatic update
- Indicate if you want to update financial transactions in the corporate company immediately. YES is defaulted if all the selected originating companies were automatically updated in their latest runs (all of them must have had YES in this field at that time). You can perform the update in two ways:
Automatically (set this field to YES) This means that the retrieval of G/L transactions and the update of the corporate company is performed immediately and automatically. Note: An automatic update can end up in journal in error, e.g. if the account structure is incomplete. Manually (set this field to NO) This means that the routine must be performed manually in two steps: 1 Create interface file for accounting transactions from pre-system in Update corporate company. 2 Manually invoke the Retrieve financial transactions program to run the final update into the transaction and balance files in the corporate company. This could be useful if you want to create a break between the two routines, for any reason.
Budgets
- Consolidate from per
- Set to YES if you want to consolidate the budgets into the corporate company. This will clear and re-create all budgets, from the selected period up to and including year end, in the corporate company. Set to NO if you want to leave the budgets as they are.
- Budget exch rate
- Enter the period code for DAY, WEEK, MONTH or YEAR, and the level code for HIGH, MEDIUM, or LOW and the period for the budget exchange rate from the corporate company.