Lawson Insight Technical Documentation


ERDs Tables Elements Libraries App Forms

AC20

AC20.1 - Activity Group Budget

Use AC20.1 (Activity Group Budget) to define activity group budget
information for the life of the activity group or for individual years or
periods. You can define a budget with amount values only, unit values only, or
amount, rate, and units.

If the Budget line has two values, the program calculates the third using the
formula: Amount = Rate * Units. If the budget has all three values, the
program recalculates the amount as Rate * Units and rounds the amount and
units.

Choose the Comments button to define comments for this budget.

Choose the Compute button to define a compute statement for computing budgets.

In the Budget field, you can select Attachments and define URL links or
comments.

Updated Files

    ACACTGRP   - Updates this file with the active budget for the activity
                 group.

    ACBUDDTL   - This is one of the primary files maintained by this program.
                 Maintains annual budget and previous years budget balances for
                 activity and activity group
                 budgets.

    ACBUDDTLX  - This is one of the primary files maintained by this program.
                 Maintains period budget balances for the activity or activity
                 group budget. Maintained by account category for activity
                 budgets.

    ACBUDHDR   - This is one of the primary files maintained by this program.
                 Maintains budget header information and total budget balance
                 for the activity or activity
                 group budget.

    ACCHGORDER - Deletes budget change order records on a Delete action.

    ACCHGORDX  - Deletes budget change order detail records on a Delete action.

    ACCONSOL   - References this file to validate last year's actuals on file
                 for the activity group for budget action code Copy Last Year's
                 Actuals.

    ACCONSOLX  - References this file to validate last year's actuals on file
                 for the activity group for budget action code Copy Last Year's
                 Actuals.

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

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

    ACSUMBUD   -

    MXLISTHDR  - References this file to validate the list.

    MXLISTMBR  - References this file to validate list members.

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

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


Referenced Files

    ACACCTCAT  - References this file to validate the account category.

    ACACCTCATX - References this file to validate that the account category is
                 assigned to the activity group or activity.

    ACACTIVITY - Validates the activity and identifies the active budget.

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

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

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

    ACCAL      - References this file to validate the calendar and to ensure
                 that calendar records exist for the complete date range
                 established on the budget header.

    ACCALX     - References this file to ensure that calendar records exist for
                 the full date range defined on the budget header.

    ACCOMMENTS - References this file to validate activity group budget
                 comments.

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

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

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

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

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

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

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

    ACRPTGRP   - References this file to validate the account category group.

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

    ACSPREAD   - References this file to validate the spread code.

    ACSPREADX  - References this file to validate spread code detail.

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

    CMPUTE     - References this file to validate that the compute exists in
                 the Lawson Report Writer system.

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

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

    FBFACTOR   - References this file to validate the factor code.

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

    GLCGCPY    - References this file to validate that the company group exists
                 in the Lawson General Ledger system.

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

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

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

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

    GLMASTER   - References this file to validate last year's actuals on file
                 for the account for budget action code Copy Last Year's
                 Actuals.

    GLNAMES    - References this file to validate the accounting unit in the
                 Lawson General ledger system.

    GLSYSTEM   - References this file to validate that the company exists in
                 the Lawson General Ledger system.

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

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

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

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

    RWGRPDET   - References this file to validate that the account group exists
                 in the Lawson General Ledger system.

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

    RWROWDET   - References this file to validate that the account group exists
                 in the Lawson General Ledger system.

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


AC20.2 - Activity Budget

Use AC20.2 (Activity Budget) to define activity budget information for the
life of the activity or for individual years or periods. You can define a
budget with amount values only, unit values only, or amount, rate, and units.

If the Budget line has two values, the program calculates the third using the
formula: Amount = Rate * Units. If the budget has all three values, the
program recalculates the amount as Rate * Units and rounds the amount and
units.

Choose the Comments button to define comments for this budget.

Choose the Compute button to define a compute statement for computing the
budget.

In the Budget field, you can select Attachments and define URL links or
comments.

Updated Files

    ACACTGRP   - This file holds the total of the active amount (not unit)
                 budgets for all activities within the activity group.

    ACBUDDTL   - This is one of the primary files maintained by this program.
                 Maintains annual budget and future years budget balances for
                 activity budgets.

    ACBUDDTLX  - This is one of the primary files maintained by this program.
                 Maintains period budget amounts for the activity budget.

    ACBUDHDR   - This is one of the primary files maintained by this program.
                 Maintains budget header information and total budget balance
                 for the activity budget.

    ACCHGORDER - Deletes budget change order records on a Delete action.

    ACCHGORDX  - Deletes budget change order detail records on a Delete action.

    ACCONSOL   - This is one of the primary files maintained by this program.
                 Maintains annual budget and future years' budget consolidation
                 balances for activity budgets.

    ACCONSOLX  - This is one of the primary files maintained by this program.
                 Maintains period budget consolidation balances for the activity
                 or activity group budget. Maintained by account category for
                 activity budgets.

    ACCUAMT    - This file is maintained by this program for budgets with a
                 non-base currency. Maintains annual budget and future years
                 budget balances for activity and activity group budgets.

    ACCUAMTX   - This file is maintained by this program for budgets with a
                 non-base currency. Maintains period budget balances for the
                 activity or activity group budget. Maintained by account
                 category for activity budgets.

    ACSUMBUD   -

    MXLISTHDR  - References this file to validate the list.

    MXLISTMBR  - References this file to validate the accounting unit list.

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

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


Referenced Files

    ACACCTCAT  - References this file to validate the account category.

    ACACCTCATX - References this file to validate that the account category is
                 assigned to the activity group or activity.

    ACACTIVITY - References this file to validate the activity and identify the
                 active budget.

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

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

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

    ACCAL      - References this file to validate the calendar and to ensure
                 that calendar records exist for the complete date range
                 established on the budget header.

    ACCALX     - References this file to ensure that calendar records exist for
                 the full date range defined on the budget header.

    ACCOMMENTS - References this file to valid activity budget comments.

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

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

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

    ACLEVEL    - References this file to determine if the activity is summary
                 level or posting.

    ACMASTER   - References this file to validate last year's actuals on file
                 for the activity for budget action code Copy Last Year's
                 Actuals.

    ACMASTERX  - References this file to validate last year's actuals on file
                 for the activity for budget action code Copy Last Year's
                 Actuals.

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

    ACRPTGRP   - References this file to validate the account category group.

    ACRPTGRPX  - References this file in a common routine.

    ACSPREAD   - References this file to validate the spread code and compute
                 the spread amounts.

    ACSPREADX  - References this file to calculate the spread code period
                 amounts.

    ACSTATUS   - Validates that the activity allows budgeting

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

    CMPUTE     - References this file to validate that the compute exists in
                 the Lawson Report Writer system.

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

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

    FBFACTOR   - References this file to validate the factor code.

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

    GLCGCPY    - References this file to validate that the company group exists
                 in the Lawson General Ledger system.

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

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

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

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

    GLMASTER   - References this file to validate last year's actuals on file
                 for the account for budget action code Copy Last Year's
                 Actuals.

    GLNAMES    - References this file to validate the accounting unit in the
                 Lawson General Ledger system.

    GLSYSTEM   - References this file to validate that the company exists in
                 the Lawson General Ledger system.

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

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

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

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

    RWGRPDET   - References this file to validate that the account group exists
                 in the Lawson General Ledger system.

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

    RWROWDET   - References this file to validate that the account group exists
                 in the Lawson General Ledger system.

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


AC20.3 - Activity Budgets By Activity

Use AC20.3 (Activity Budgets By Activity) to define and maintain activity
budgets by activity. For each account category of the activity, you can add,
change, or delete the budget amount, factor, rate, or units. You can define a
budget with amount values only, unit values only, or amount, rate, and units.

If the Budget line has two values, the program calculates the third using the
formula: Amount = Rate * Units. If the budget has all three values, the
program recalculates the amount as Rate * Units and rounds the amount and
units.

In the Budget field, you can select Attachments and define URL links or
comments.

Updated Files

    ACACTGRP   - Maintains the budget balance of all of the activity group's
                 active activity amount budgets.

    ACBUDDTL   - This is one of the primary files maintained by this program.
                 Maintains annual budget and previous years budget balances for
                 an activity.

    ACBUDDTLX  - This is one of the primary files maintained by this program.
                 Maintains period budget balances for the activity budget.
                 Maintained by account category for activity budgets.

    ACBUDHDR   - This is one of the primary files maintained by this program.
                 Maintains budget header information and total budget balance
                 for the activity.

    ACCHGORDER - Deletes budget change order records on a Delete action.

    ACCHGORDX  - Deletes budget change order detail records on a Delete action.

    ACCONSOL   - This is one of the primary files maintained by this program.
                 Maintains annual budget and future years' budget consolidation
                 balances for an activity.

    ACCONSOLX  - This is one of the primary files maintained by this program.
                 Maintains period budget consolidation balances for the
                 activity. Maintained by account category for activity budgets.

    ACCUAMT    - This file is maintained by this program for budgets with a
                 non-base currency. Maintains annual budget and previous years
                 budget balances for the activity.

    ACCUAMTX   - This file is maintained by this program for budgets with a
                 non-base currency. Maintains period budget balances for the
                 activity. Maintained by account category for activity budgets.

    ACSUMBUD   -

    MXLISTHDR  - References this file to validate the list.

    MXLISTMBR  - References this file to validate the list detail.

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

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


Referenced Files

    ACACCTCAT  - References this file to validate the account category.

    ACACCTCATX - References this file to validate account category assignment
                 for the activity.

    ACACTIVITY - References this file to validate the activity.

    ACACTMXVAL - References this file to validate the activity attributes.

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

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

    ACCAL      - References this file to validate the activity group calendar.

    ACCALX     - References this file to validate years and periods defined for
                 the calendar.

    ACCOMMENTS - References this file to valid activity budget comments.

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

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

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

    ACLEVEL    - References this file to determine if the activity is summary
                 level or posting.

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

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

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

    ACRPTGRP   - References this file to validate the account category group.

    ACRPTGRPX  - References this file to validate the account categories in the
                 group.

    ACSPREAD   - References this file to validate the spread code.

    ACSPREADX  - References this file to retrieve the spread code percents.

    ACSTATUS   - References this file to validate that the status is valid for
                 budgeting.

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

    CMPUTE     - References this file to validate the compute.

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

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

    FBFACTOR   - References this file to validate the factor code.

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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


AC20.4 - Activity Budgets By Account Category

Use AC20.4 (Activity Budgets By Account Category) to define and maintain
activity budgets by account category. For each account category you select,
you can add, change, or delete the activity budget amount, factor, rate, or
units. You can define a budget with amount values only, unit values only, or
amount, rate, and units.

If the Budget line has two values, the program calculates the third using the
formula: Amount = Rate * Units. If the budget has all three values, the
program recalculates the amount as Rate * Units and rounds the amount and
units.

In the Budget field, you can select Attachments and define URL links or
comments.

Updated Files

    ACACTGRP   - The budget balance is maintained on this file for all of the
                 activity group's active activity amount budgets.

    ACBUDDTL   - This is one of the primary files maintained by this program.
                 Maintains annual budget and previous years budget balances for
                 activity budgets.

    ACBUDDTLX  - This is one of the primary files maintained by this program.
                 Maintains period budget balances for the activity budget.
                 Maintained by account category for activity budgets.

    ACBUDHDR   - This is one of the primary files maintained by this program.
                 Maintains  header information and total budget balance for the
                 activity budget.

    ACCHGORDER - Deletes budget change order records on a Delete action.

    ACCHGORDX  - Deletes budget change order detail records on a Delete action.

    ACCONSOL   - This is one of the primary files maintained by this program.
                 Maintains annual budget and future years' budget consolidation
                 balances for activity budgets.

    ACCONSOLX  - This is one of the primary files maintained by this program.
                 Maintains period budget consolidation balances for the activity
                 budget. Maintained by account category for activity budgets.

    ACCUAMT    - This file is maintained by this program for budgets with a
                 non-base currency. Maintains annual budget and previous years
                 budget balances for activity.

    ACCUAMTX   - This file is maintained by this program for budgets with a
                 non-base currency. Maintains period budget balances for the
                 activity. Maintained by account category for activity budgets.

    ACSUMBUD   -

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

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

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

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


Referenced Files

    ACACCTCAT  - References this file to validate the account category.

    ACACCTCATX - References this file to validate that the account category is
                 assigned to the activity.

    ACACTIVITY - References this file to validate the activity.

    ACACTMXVAL - References this file to validate the activity attributes.

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

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

    ACCAL      - References this file to validate the calendar for the activity
                 group.

    ACCALX     - References this file to validate years and periods defined for
                 the calendar.

    ACCOMMENTS - References this file to valid activity budget comments.

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

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

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

    ACLEVEL    - References this file to validate if the activity is posting or
                 summary.

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

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

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

    ACRPTGRP   - References this file to validate the account category group.

    ACRPTGRPX  - References this file to validate account categories in the
                 group.

    ACSPREAD   - References this file to validate the spread code.

    ACSPREADX  - References this file to retrieve the percents for each period.

    ACSTATUS   - References this file to determine if the activity is in a
                 budget status.

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

    CMPUTE     - References this file to validate the compute.

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

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

    FBFACTOR   - References this file to validate the factor code.

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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


AC20.5 - Activity Group Budget Header

Use AC20.5 (Activity Group Budget Header) to define an activity group budget
header. In the Budget field, you can select Attachments and define URL links
or comments.

Updated Files

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

    ACBUDDTL   - Deletes annual budget records on a Delete action.

    ACBUDDTLX  - Deletes period budget amounts on a Delete action.

    ACBUDHDR   - This is the primary file maintained by this program. Maintains
                 budget header information.

    ACCHGORDER - Deletes budget change order records on a Delete action.

    ACCHGORDX  - Deletes budget change order detail records on a Delete action.

    ACSUMBUD   -


Referenced Files

    None.


AC20.6 - Activity Budget Header

Use AC20.6 (Activity Budget Header) to define an activity budget header. The
header defines the budget number and description, budget date range, currency
and exchange rate information, amount and unit round types, whether it is a
life only budget, and whether it is the active budget. You must add the budget
header before you can add budget amounts and units.

An asterisk (*) next to the Budget field indicates that there is a lock on
this activity budget and it cannot be changed or deleted. To see more
information about the lock, or to change what is defined for the budget,
choose the Lock button. Use AC20.7 (Budget Lock) to unlock the budget. Use
AC21 (Budget Change Orders) to change the budget and provide an audit trail of
your changes.

In the Budget field, you can select Attachments and define URL links or
comments.

Updated Files

    ACACTGRP   - Updates this file with the active budget for the activity
                 group.

    ACACTIVITY - References this file to validate the activity.

    ACBUDDTL   - Deletes the annual budget files on a Delete
                 action.

    ACBUDDTLX  - Deletes the period budget amounts on a Delete
                 action.

    ACBUDHDR   - This is the primary file maintained by this program. Maintains
                 budget header information.

    ACCHGORDER - Deletes budget change order records on a Delete action.

    ACCHGORDX  - Deletes budget change order detail records on a Delete action.

    ACCONSOL   - This is one of the primary files maintained by this program.
                 Maintains annual budget and future years' budget consolidation
                 balances for activity budgets.

    ACCONSOLX  - This is one of the primary files maintained by this program.
                 Maintains period budget consolidation balances for the activity
                 budget. Maintained by account category for activity budgets.

    ACCUAMT    - This file is maintained by this program for budgets with a
                 non-base currency. Maintains annual budget and previous years
                 budget balances for activity.

    ACCUAMTX   - This file is maintained by this program for budgets with a
                 non-base currency. Maintains period budget balances for the
                 activity. Maintained by account category for activity budgets.

    ACSUMBUD   -


Referenced Files

    ACLEVEL    - References this file to validate if the activity is posting or
                 summary.

    ACSTATUS   - References this file to validate if the activity is in a
                 budget status.

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


AC20.7 - Budget Lock

Use AC20.7 (Budget Lock) to lock or unlock a budget. Locking prevents
deletion of the budget or changes to it. Use AC21 (Budget Change Orders) to
change budgets and provide an audit trail of your changes.

In the Budget field, you can select Attachments and define URL links or
comments.

Updated Files

    ACBUDHDR   - This is one of the primary files maintained by this program.
                 Maintains budget header information and total budget balance
                 for the activity budget.


Referenced Files

    ACACTGRP   - This file holds the total of the active amount (not unit)
                 budgets for all activities within the activity group.

    ACACTIVITY - References this file to validate the activity and identify the
                 active budget.


INVOKED Programs

    GLBL
    IFUP
    GLRV
    IFAU
    IFCC
    IFSG
    IFCR