FB195 - Translation Calculation
Run FB195 (Translation Calculation) to transfer budget amounts from one
company to another for reporting and consolidation. Information is transferred
based on the From Company parameters. If the company base currencies are
different, the budget balances are translated to the consolidations company's
base currency based on the translation rate defined in CU20.1 (Currency Table
Translation Rates) and the translation code defined in CU05.1 (Translation
Code). When you run this program for balance sheet budgets, the Year-to-Date
budgets are translated. When you run it for income statement budgets, the
Period budgets are translated.
The Rate Type you select for the translation code in CU05.1 affects how the
budgets are translated. If you select Ending or Historical, Year to Date
budgets are translated. If you select Average, Period amounts are translated.
After you run FB195, use the following programs to complete the translation
process.
1. Run FB65.1 (Budget Interface Maintenance) to display and maintain budget
information you are translating. NOTE: In the type field, "A YTD - Amounts"
displays for balance sheet budgets, and "P Period" displays for income
statement budgets.
2. Run FB165 (Budget Interface) to load the translated budgets.
3. Use FB20 (Budget Entry) to verify information is correct.
Important: The fiscal year you are running this program in must be the same
fiscal year defined in CU20.1 (Currency Table Translation Rates).
Updated Files
CKPOINT - Used for restart capability.
FBUDGETREL - This file is updated with translated budget balances.
Referenced Files
CUCONV -
CURELAT - Used to validate currency relationships.
CUTRANSL - Used to access currency translation rates.
FBDETAIL - Used to access posting account budget balances.
FBHEADER - Used to validate the existence of a budget.
GLACCTREL - Used to validate the existence of account relationships.
GLADDRESS - This file is accessed by a common routine used by this
program. This file is not used by this program.
GLCHART - This file is accessed by a common routine used by this
program. This file is not used by this program.
GLCHARTDTL - Used to validate the existence of a detail account.
GLCOMPREL - Used to validate the existence of organization relationships.
GLCONSOL - Used to access consolidated account budget balances.
GLMASTER - Used to validate the existence of a posting account. This
file is updated if dynamic account generation is used.
GLNAMES - Used to validate the existence of an accounting unit.
GLSYSTEM - Used to validate the existence of a company.
TRCODES - Used to validate the existence of translation codes.
WFSETUP -
INVOKED Programs
IFCU
IFSG
|
