Lawson Insight Technical Documentation

AC90.1 - Activity Analysis

**Form Purpose
Use Activity Analysis (AC90.1) to identify the Activity Management parameters
you want to view activity data for.




Updated Files

    MXLISTHDR  -

    MXLISTMBR  -


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.

    ACACTMXVAL -

    ACADDLCNTR -

    ACAMCODE   -

    ACASSIGN   -

    ACBILL     -

    ACBILLX    -

    ACCAL      - References this file to validate the calendar.

    ACCATGRP   -

    ACCATGRPX  -

    ACCNTRACT  -

    ACCOLGRP   -

    ACCOLGRPX  -

    ACIFACTV   -

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

    ACSTATUS   -

    MXCATDEF   -

    MXELEMENT  -

    MXLISTDTL  -

    MXOBJCAT   -


AC90.2 - Actual, Commit, Budget

**Form Purpose
Use Actual, Commit, Budget (AC90.2) to view actual, commitment, and budget
balances by activity.




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.

    ACBILL     -

    ACBILLX    -

    ACCAL      - References this file to validate the calendar.

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


    ACCATGRP   -

    ACCATGRPX  -

    ACCNTRACT  -

    ACCOLGRP   -

    ACCOLGRPX  -

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

    ACIFACTV   -

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

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

    MXLISTHDR  -

    MXLISTMBR  -

    SYSTEMCODE -


AC90.4 - Profit and Loss

**Form Purpose
Use Profit and Loss (AC90.4) to view revenue, cost, actual, and net amounts
by activity.

Important If the parameters you identified on Activity Analysis (AC90.1)
contain activities from multiple address level in the same structure, you may
receive incorrect totals.




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.

    ACBILL     -

    ACBILLX    -

    ACCAL      - References this file to validate the calendar.

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


    ACCATGRP   -

    ACCATGRPX  -

    ACCNTRACT  -

    ACCOLGRP   -

    ACCOLGRPX  -

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

    ACIFACTV   -

    ACLEVEL    - References this file to retrieve period-to-date budget and
                 actual amounts for posting-level activities in activity
                 (non-base) currency.

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

    MXLISTHDR  -

    MXLISTMBR  -

    SYSTEMCODE -


AC90.6 - Account Category

**Form Purpose
Use Account Category (AC90.6) to view activity balances by account category.




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.

    ACBILL     -

    ACBILLX    -

    ACCAL      - References this file to validate the calendar.

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


    ACCATGRP   -

    ACCATGRPX  -

    ACCNTRACT  -

    ACCOLGRP   -

    ACCOLGRPX  -

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

    ACIFACTV   -

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

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

    MXLISTHDR  -

    MXLISTMBR  -

    SYSTEMCODE -


AC90.8 - Period

**Form Purpose
Use Period (AC90.8) to view actual, commitment, and budget amounts by period
and fiscal year.




Updated Files

    None.


Referenced Files

    ACACCTCAT  -

    ACACCTCATX -

    ACACTGRP   -

    ACACTIVITY -

    ACBILL     -

    ACBILLX    -

    ACCAL      -

    ACCALX     -

    ACCATGRP   -

    ACCATGRPX  -

    ACCNTRACT  -

    ACCOLGRP   -

    ACCOLGRPX  -

    ACCOMMIT   -

    ACIFACTV   -

    ACLEVEL    -

    ACTRANS    -

    MXLISTHDR  -

    MXLISTMBR  -

    SYSTEMCODE -


INVOKED Programs

    IFCU
    IFSG
    ACTA