FB195 – Translation Calculation
- System
- General Ledger (GL)
- Type
- Batch program
- Updates
- 3 tables
- References
- 17 tables
FB195 (Translation Calculation) is a Lawson General Ledger batch program. It updates ADDRDATA, CKPOINT and FBUDGETREL and references CUCONV, CURELAT, CUTRANSL, FBDETAIL, FBHEADER, GLACCTREL, GLADDRESS, GLCHART and 9 more.
About FB195
Run Translation Calculation (FB195) to transfer budget amounts from one company to another, or to translate from one currency to another within the same company. FB195 functionality is generally used for reporting and consolidation. NOTE To transfer within the same company, you must enter a new budget number and enter the same company in both the To Company and From Company fields. IMPORTANT The fiscal year you are running this program in must be the same fiscal year defined on Currency Table Translation Rates (CU20.1). **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 on Currency Table Translation Rates (CU20.1) and the translation code defined on Translation Code (CU05.1). 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 aretranslated.
More information: After you run FB195, use the following programs to complete the translation process. - Run Budget Interface Maintenance (FB65.1) to display and maintain budget information you are translating. In the type field, "A YTD - Amounts" displays for balance sheet budgets, and "P Period" displays for income statement budgets. NOTE In the type field, "A YTD - Amounts" displays for balance sheet budgets, and "P Period" displays for income statement budgets. - Run Budget Interface (FB165) to load the translated budgets. - Use Budget Entry (FB20) to verify information is correct.
Updated files (3)
| Table | Description | System |
|---|---|---|
| ADDRDATA | Address Code | IF |
| CKPOINT | No description in the Lawson data dictionary | — |
| FBUDGETREL | Budgeting Relationships | GL |
Referenced files (17)
| Table | Description | System |
|---|---|---|
| CUCONV | Currency Exhange Rate | IF |
| CURELAT | Currency Relationships | IF |
| CUTRANSL | Currency Translation | IF |
| FBDETAIL | Budget Detail | GL |
| FBHEADER | Budget Header | GL |
| GLACCTREL | GL Account Relationships | IF |
| GLADDRESS | General Ledger Company Address | IF |
| GLCHART | General Ledger Chart | IF |
| GLCHARTDTL | General Ledger Chart Detail | IF |
| GLCOMPREL | GL Organization Relationships | IF |
| GLCONSOL | General Ledger Consolidation | GL |
| GLMASTER | General Ledger Account Master | IF |
| GLNAMES | General Ledger Names | IF |
| GLSYSTEM | General Ledger Company | IF |
| INSTCTRYCD | Intrastat Country Codes | TX |
| TRCODES | Translation Codes | IF |
| WFSETUP | No description in the Lawson data dictionary | WF |
Program calls
Invoked programs (12)
ACAC, ACTA, API4, GLCT, IFAC, IFCU, IFLU, IFOB, IFSG, IFUP, SLSE, SLSU