Lawson Insight Technical Documentation


ERDs Tables Elements Libraries App Forms

AC90

AC90.1 - Activity Group Analysis

Use this form to inquire on activity group life-to-date information. You can
view life-to-date actuals, commitments, budgets, and percents of budget by
activity. Percent of budget is calculated by dividing the actual amount plus
commitments by the budgeted amount and multiplying the result by 100.

Commitments are activity transactions released in any originating subsystem
but not yet posted to Activity Management. They include purchase orders and
payables not yet distributed among general ledger accounts, unposted general
ledger and subledger transactions, and unposted Activity Management
transactions, among others. Commitment information is available in the
Commitments field of each Activity Group Analysis and Activity Analysis form.

Updated Files

    None.


Referenced Files

    ACACCTCAT  -

    ACACCTCATX - References this file to validate that the account category is
                 assigned to the activity group or activity. Determines which
                 account categories to display for the inquiry.

    ACACTGRP   - References this file to validate the activity group.

    ACACTIVITY - References this file to validate the activity.

    ACBUDDTL   - References this file to retrieve year-to-date budget amounts
                 and calculate life-to-date budget amounts in activity group
                 currency.

    ACBUDDTLX  - References this file to retrieve period-to-date budget amounts
                 in activity group currency.

    ACBUDHDR   - References this file to validate the activity group budget
                 header. References this file to retrieve life-to-date budget
                 amounts by activity in activity group currency.

    ACCAL      - References this file to validate the calendar.

    ACCALX     - References this file to validate period and period end dates
                 for the calendar.

    ACCOMMIT   - References this file to retrieve activity group commitments
                 amounts by activity.

    ACCONSOL   - References this file to retrieve year-to-date budget and
                 actual amounts and calculate life-to-date budget and actual
                 amounts for summary-level activities in activity group
                 currency.

    ACCONSOLX  - References this file to retrieve period-to-date budget and
                 actual amounts for summary-level activities in activity group
                 currency.

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

    ACMASTER   - References this file to retrieve year-to-date actual amounts
                 and calculate life-to-date actual amounts for posting-level
                 activities in activity group currency.

    ACMASTERX  - References this file to retrieve period-to-date actual amounts
                 for posting-level activities in activity group currency.

    ACRPTGRP   -

    ACRPTGRPX  -

    ACTRANS    - References this file to add released (not posted) transactions
                 to the commitment amount.


AC90.2 - Activity Group Totals

This subform displays activity group life-to-date totals for actual amounts,
budgets, commitments, and percents of budget.

Updated Files

    None.


Referenced Files

    ACACCTCAT  -

    ACACCTCATX - References this file to validate that the account category is
                 assigned to the activity group or activity. Determines which
                 account categories to display for the inquiry.

    ACACTGRP   - References this file to validate the activity group.

    ACACTIVITY - References this file to validate the activity.

    ACBUDDTL   - References this file to retrieve year-to-date budget amounts
                 and calculate life-to-date budget amounts in activity group
                 currency.

    ACBUDDTLX  - References this file to retrieve period-to-date budget amounts
                 in activity group currency.

    ACBUDHDR   - References this file to validate the activity group budget
                 header. References this file to retrieve life-to-date budget
                 amounts by activity in activity
                 group currency.

    ACCAL      - References this file to validate the calendar.

    ACCALX     - References this file to validate period and period end dates
                 for the calendar.


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

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

    ACMASTER   - References this file to retrieve year-to-date actual amounts
                 and calculate life-to-date actual amounts for posting-level
                 activities in activity group currency.

    ACMASTERX  - References this file to retrieve period-to-date actual amounts
                 for posting-level activities in activity group currency.

    ACRPTGRPX  -

    ACTRANS    - References this file to add released (not posted) transactions
                 to the commitment amount.


INVOKED Programs

    IFCU
    IFCR
    IFSG