Translating budgets

Budget translation is the process of translating and consolidating budgets for multiple companies into one budget using period translation rates. This procedure translates budgets in the From company and puts the data in the FBUDGETREL (UNIX/Windows) or DBGLFBR (IBM i) file for the consolidation company.

You must have a consolidation company defined with Consolidation selected in the Status field on the Main form tab of GL10.1. Each source company must have Yes selected in the Currency Translation field on the Currency form tab of GL10.1. You must also have budget translation rates defined on Currency Table Translation Rates (CU02.1) or Company Translation Rates (CU20.3).

See the information about creating and processing budgets in the General Ledger Budgeting User Guide.

Access Translation Calculation (FB195).
Run the program. Use these guidelines to specify the field values:

Translation Level

This field determines the consolidated level of the From company to translate. For example, if 0 (company level) is selected, then specify a To accounting unit where you can store the amounts.

The account balances in the budget are multiplied or divided by the period translation rates defined for the budget to arrive at the translated account balances.

Follow-up task

You must run Budget Conversion (FB165) to update the To company budgets. See the General Ledger Budgeting User Guide.