Lawson Insight Technical Documentation


ERDs Tables Elements Libraries App Forms

FB165

FB165 - Budget Interface

Run FB165 (Budget Interface) to convert 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).

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.

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.

    GLMASTER   - Used to validate the existence of a posting account.  This
                 file is updated if dynamic account generation is used.


Referenced Files

    CUCODES    - Used to validate the existence of a currency code.

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

    GLACCTREL  - Used to validate the existence of account relationships.

    GLACCTVLD  - Used to validate detail account/system code relationship.

    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.

    GLCHARTSUM - This file is accessed by a common routine used by this
                 program.  This file is not used by this program.

    GLCOMPREL  - Used to validate the existence of organization relationships.

    GLNAMES    - Used to validate the existence of an accounting unit.

    GLSYSTEM   - Used to validate  the existence of a company.

    JBKACCT    - Used to validate a journal book/detail account relationship.

    JBOOKHDR   - Used to validate the existence of a journal book.

    MXLISTMBR  - Used to access accounting units associated to an accounting
                 unit list.


INVOKED Programs

    ACAC
    IFCR
    IFSG
    IFCU
    IFAC
    IFAU
    SLSE
    SLSU