Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

FB195


FB195 - Translation Calculation

**Form Purpose
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.1 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 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

    ADDRDATA   -

    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.

    INSTCTRYCD -

    TRCODES    - Used to validate the existence of translation codes.

    WFSETUP    -


INVOKED Programs

    GLCT
    IFCU
    IFAC
    ACAC
    ACCL
    ACTA
    API4
    IFLU
    IFOB
    IFAU
    IFSG
    SLSE
    SLSU