|
|
FB195 - Translation Calculation
**Form Purpose
Run Translation Calculation (FB195) to transfer budget amounts from one
company to another for reporting and consolidation.
Important The fiscal year you are running this program in must be the same
fiscal year defined in CU20.1 (Currency Table Translation Rates).
**Processing Effect
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.
**More Information
After you run FB195, use the following programs to complete the translation
process.
- 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.
- Run FB165 (Budget Interface) to load the translated budgets.
- Use FB20 (Budget Entry) to verify information is correct.
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
|
