Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

FB95


FB95.1 - Budget Analysis

**Form Purpose
Use Budget Analysis (FB95.1) to compare a wide range of account information
for two budgets or two versions of the same budget. You cannot compare two
different companies, only companies with the same account structure. For
example, you could select to compare budgets for two companies within company
LGE, but not budgets for company LGE and company XXX.

**More Information
Run FB295 (Budget Analysis Report) to print budget comparison amounts for
both companies.

You can only compare budget amounts, not actuals. Use GL95.1 (Account
Analysis) to compare actual budget data.

Choose the Account button to view account period totals for both companies
and the difference between the two.

Choose the AcctUnit button to view accounting unit period totals for both
companies and the difference between the two.

Choose the Totals button to view beginning balances, period totals, and
ending balances for both companies and the difference between the two.




Updated Files

    ADDRDATA   -

    RATOTALS   - This file is updated with consolidated budget balances.

    ULTOTALS   - Used to store totals for an accounting unit list and an
                 account range.



Referenced Files

    CUCODES    - Used to validate the existence of currency codes.

    FBDETAIL   - Used to access budget amount balances.

    FBHEADER   - This file is updated with the last calculated budget date.

    FBHISTHDR  - This file stores the budget header information for a version.

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


    GLCGCPY    - Used to access companies associated with a company group.

    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.


    GLCOMMITX  -

    GLCPYGRP   - Used to access companies associated with a company group.

    GLMASTER   - Used to access account descriptions and amounts.

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

    GLSYSTEM   - Used to validate the existence of a company.

    GLTRANS    -

    INSTCTRYCD -

    MLCALMAP   -

    MLCOLEDGER -

    MXLISTHDR  - Used to validate the existence of an object list.

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


    MXVIEWDTL  - Used to access object view detail information.

    MXVIEWHDR  - Used to access object view information.

    RWGRPDET   - Used to validate the existence of level, account, or
                 subaccount groups.


    RWHEADER   - Used to access values for heading data dictionary names.

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


    ULPOST     - Used to access last posting date and time.


FB95.2 - Account, Period

**Form Purpose
Use Account, Period (FB95.2) to view account period totals for both companies
and the difference between the two.

**More Information
Choose the YTD button to view year to date totals for both companies and the
difference between the two.

Choose the AcctUnit button to view accounting unit period totals for both
companies and the difference between the two.

Choose the Totals button to view beginning balances, period totals, and
ending balances for both companies and the difference between the two.




Updated Files

    ADDRDATA   -

    RATOTALS   - This file is updated with consolidated budget balances.

    ULTOTALS   - Used to store totals for an accounting unit list and an
                 account range.



Referenced Files

    CUCODES    - Used to validate the existence of currency codes.

    FBDETAIL   - Used to access budget amount balances.

    FBDTLHIST  - This file stores the budget detail version information.

    FBHEADER   - This file is updated with the last calculated budget date.

    FBHISTHDR  - This file stores the budget header information for a version.

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


    GLCGCPY    - Used to access companies associated with a company group.

    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.


    GLCOMMITX  -

    GLCPYGRP   - Used to access companies associated with a company group.

    GLMASTER   - Used to access account descriptions and amounts.

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

    GLSYSTEM   - Used to validate the existence of a company.

    GLTRANS    -

    INSTCTRYCD -

    MLCALMAP   -

    MLCOLEDGER -

    MXLISTHDR  - Used to validate the existence of an object list.

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


    MXVIEWDTL  - Used to access object view detail information.

    MXVIEWHDR  - Used to access object view information.

    RWGRPDET   - Used to validate the existence of level, account, or
                 subaccount groups.


    RWHEADER   - Used to access values for heading data dictionary names.

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


    ULPOST     - Used to access last posting date and time.


FB95.3 - Account, Year to Date

**Form Purpose
Use Account, Year to Date (FB95.3) to view account year to date totals for
both companies and the difference between the two.

**More Information
Choose the AcctUnit button to view accounting unit period totals for both
companies and the difference between the two.

Choose the Totals button to view beginning balances, period totals, and
ending balances for both companies and the difference between the two.




Updated Files

    ADDRDATA   -

    RATOTALS   - This file is updated with consolidated budget balances.

    ULTOTALS   - Used to store totals for an accounting unit list and an
                 account range.



Referenced Files

    CUCODES    - Used to validate the existence of currency codes.

    FBDETAIL   - Used to access budget amount balances.

    FBDTLHIST  - This file stores the budget detail version information.

    FBHEADER   - This file is updated with the last calculated budget date.


    FBHISTHDR  - This file stores the budget header information for a version.

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


    GLCGCPY    - Used to access companies associated with a company group.

    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.


    GLCOMMITX  -

    GLCPYGRP   - Used to access companies associated with a company group.

    GLMASTER   - Used to access account descriptions and amounts.

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

    GLSYSTEM   - Used to validate the existence of a company.

    GLTRANS    -

    INSTCTRYCD -

    MLCALMAP   -

    MLCOLEDGER -

    MXLISTHDR  - Used to validate the existence of an object list.

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


    MXVIEWDTL  - Used to access object view detail information.

    MXVIEWHDR  - Used to access object view information.

    RWGRPDET   - Used to validate the existence of level, account, or
                 subaccount groups.


    RWHEADER   - Used to access values for heading data dictionary names.


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


    ULPOST     - Used to access last posting date and time.


FB95.4 - Accounting Unit, Period

**Form Purpose
Use Accounting Unit, Period (FB95.4) to view accounting unit period totals
for both companies and the difference between the two.

**More Information
Choose the YTD button to view year to date totals for both companies and the
difference between the two.

Choose the Account button to view account period totals for both companies
and the difference between the two.

Choose the Totals button to view beginning balances, period totals, and the
ending balances for both companies and the difference between the two.




Updated Files

    ADDRDATA   -

    RATOTALS   - This file is updated with consolidated budget balances.

    ULTOTALS   - Used to store totals for an accounting unit list and an
                 account range.



Referenced Files

    CUCODES    - Used to validate the existence of currency codes.

    FBDETAIL   - Used to access budget amount balances.

    FBDTLHIST  - This file stores the budget detail version information.

    FBHEADER   - This file is updated with the last calculated budget date.

    FBHISTHDR  - This file stores the budget header information for a version.

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


    GLCGCPY    - Used to access companies associated with a company group.

    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.


    GLCOMMITX  -

    GLCPYGRP   - Used to access companies associated with a company group.

    GLMASTER   - Used to access account descriptions and amounts.

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

    GLSYSTEM   - Used to validate the existence of a company.

    GLTRANS    -

    INSTCTRYCD -

    MLCALMAP   -

    MLCOLEDGER -

    MXLISTHDR  - Used to validate the existence of an object list.

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


    MXVIEWDTL  - Used to access object view detail information.

    MXVIEWHDR  - Used to access object view information.

    RWGRPDET   - Used to validate the existence of level, account, or
                 subaccount groups.


    RWHEADER   - Used to access values for heading data dictionary names.

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


    ULPOST     - Used to access last posting date and time.



FB95.5 - Accounting Unit, Year to Date

**Form Purpose
Use Accounting Unit, Year to Date (FB95.5) to view accounting unit year to
date totals for both companies and the difference between the two.

**More Information
Choose the Account button to view account period totals for both companies
and the difference between the two.

Choose the Totals button to view beginning balances, period totals, and
ending balances for both companies and the difference between the two.




Updated Files

    ADDRDATA   -

    RATOTALS   - This file is updated with consolidated budget balances.

    ULTOTALS   - Used to store totals for an accounting unit list and an
                 account range.



Referenced Files

    CUCODES    - Used to validate the existence of currency codes.

    FBDETAIL   - Used to access budget amount balances.

    FBDTLHIST  - This file stores the budget detail version information.


    FBHEADER   - This file is updated with the last calculated budget date.

    FBHISTHDR  - This file stores the budget header information for a version.

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


    GLCGCPY    - Used to access companies associated with a company group.

    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.


    GLCOMMITX  -

    GLCPYGRP   - Used to access companies associated with a company group.

    GLMASTER   - Used to access account descriptions and amounts.

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

    GLSYSTEM   - Used to validate the existence of a company.

    GLTRANS    -

    INSTCTRYCD -

    MLCALMAP   -

    MLCOLEDGER -

    MXLISTHDR  - Used to validate the existence of an object list.

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


    MXVIEWDTL  - Used to access object view detail information.

    MXVIEWHDR  - Used to access object view information.

    RWGRPDET   - Used to validate the existence of level, account, or
                 subaccount groups.


    RWHEADER   - Used to access values for heading data dictionary names.

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


    ULPOST     - Used to access last posting date and time.


FB95.6 - Totals

**Form Purpose
Use Totals (FB95.6) to compare budget totals for two companies based on the
parameters you select.

**Processing Effect
The difference between the two is calculated by subtracting company one from
company two. If the number is positive, company one has a greater balance, if
the number is negative, company two has a greater balance.




Updated Files

    ADDRDATA   -

    RATOTALS   - This file is updated with consolidated budget balances.

    ULTOTALS   - Used to store totals for an accounting unit list and an
                 account range.



Referenced Files

    CUCODES    - Used to validate the existence of currency codes.

    FBDETAIL   - Used to access budget amount balances.

    FBDTLHIST  - This file stores the budget detail version information.

    FBHEADER   - This file is updated with the last calculated budget date.

    FBHISTHDR  - This file stores the budget header information for a version.

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


    GLCGCPY    - Used to access companies associated with a company group.

    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.


    GLCOMMITX  -

    GLCPYGRP   - Used to access companies associated with a company group.

    GLMASTER   - Used to access account descriptions and amounts.

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

    GLSYSTEM   - Used to validate the existence of a company.

    GLTRANS    -

    INSTCTRYCD -

    MLCALMAP   -

    MLCOLEDGER -

    MXLISTHDR  - Used to validate the existence of an object list.

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


    MXVIEWDTL  - Used to access object view detail information.

    MXVIEWHDR  - Used to access object view information.

    RWGRPDET   - Used to validate the existence of level, account, or
                 subaccount groups.


    RWHEADER   - Used to access values for heading data dictionary names.

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


    ULPOST     - Used to access last posting date and time.


INVOKED Programs

    GLAC
    GLBL
    IFUP
    GLRV
    IFOB
    IFSG
    MLRV