Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

FB165


FB165 - Budget Interface

**Form Purpose
Run Budget Interface (FB165) to import non-Lawson budget data and create
budget header and detail records. You can create up to 999 budgets for each
company for each fiscal year.

Use this program after you review your interface options in FB65.1 (Budget
Interface  Maintenance).

**Processing Effect
When you convert data, the system searches the organization relationship
table to find a relationship between the old company field in the table and
the old company field in the FBUDGETREL file. If a relationship exists, the
old company field is translated to the Lawson company and accounting unit.

If a relationship does not exist:

- If you select the Accounting Unit conversion method, the old company field
in the FBUDGETREL file is formatted so the first 4 characters are numeric and
represent the company number and the next 15 characters are alphanumeric.

- If you select the Level conversion method, the first 4 characters represent
the company number and the next 30 are used to locate the variable level that
is converted to its corresponding accounting unit.

**More Information
Run FB265 (Budget Interface Listing) to list data in the budgeting interface
file before running FB165.

Use FB20 (Budget Entry) to display and maintain converted information after
you run this program.




Updated Files

    CKPOINT    - Used for restart capability.

    FBDETAIL   - This file stores the posting account budget balances converted
                 by this program.

    FBHEADER   - This file is updated with the budget's last maintained date
                 and time.

    FBUDGETREL - This file is accessed to create posting account budget balance
                 records.  These records are deleted as they are processed.

    GLCONSOL   - This file is updated with consolidated account budget
                 balances.


Referenced Files

    FBFACTOR   - Used to validate the existence of a global factor.

    FBUDGETREL - This file is accessed to create posting account budget balance
                 records.  These records are deleted as they are processed.

    GLACCTREL  - Used to validate the existence of account relationships.

    GLCHARTDTL - Used to validate the existence of a detail account.

    GLCOMPREL  - Used to validate the existence of organization relationships.

    GLSYSTEM   - Used to validate  the existence of a company.

    WFSETUP    -


INVOKED Programs

    IFAC
    ACAC
    ACCL
    API4
    IFCU
    IFSG
    SLSE
    SLSU
    IFAU