Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

AC165


AC165 - Percent Complete Calculation

**Form Purpose
Run Percent Complete Calculation (AC165) to calculate percentage complete for
activity groups, activities, and account categories. You can measure activity
progress by calculating the percentage of budget completed to date. Using
AC65.1 (Activity Percentage of Completion), you can store the percentage of
completion and revise it when actual conditions deviate from the plan.
Revising the percentage of completion also revises the completion amount, or
cost to complete.

**Processing Effect
Calculate percent complete as an informational measurement of activity
progress. When running this program to measure activity progress, enter a
posting-level activity. The program calculates percent complete based on the
total budgeted amount for the activity compared to actual costs to date.

Percent complete is calculated as follows:

Percent Complete = Cost to Date / Life to Date Budget




Updated Files

    ACPERCCMPL - This is the primary file maintained by this program. Maintains
                 percent complete records by activity.

    ACPERCMPLX - This is the primary file maintained by this program. Maintains
                 percent complete records by account category.

    CKPOINT    - Used for restart capability.

    MXLISTHDR  - Updates the Last Build Time and Last Build Date fields on this
                 file.

    MXLISTMBR  - Updates the new activities included in the list.


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.

    ACACTGRP   - References this file to validate the activity group.

    ACACTIVITY - References this file to validate the activity.

    ACACTMXVAL - References this file to validate activity attributes and
                 values.

    ACADDLCNTR -

    ACAMCODE   - References this file to validate the activity asset.

    ACASNROLE  -

    ACASSIGN   - References this file to validate resources assigned to an
                 activity.

    ACBILL     -

    ACBILLX    -

    ACBUDDTL   - References this file to retrieve annual budget and future
                 years budget balances for activity budgets.

    ACBUDHDR   - References this file to retrieve the total budget balance for
                 the activity budget.

    ACCATGRP   -

    ACCATGRPX  -

    ACCATSUMX  -

    ACCNTRACT  -

    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.

    ACCTRCATGX -

    ACGRPMXVAL -

    ACIFACTV   -

    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.

    ACROLE     -

    ACSTATUS   - References this file to validate the processing status for the
                 activity.

    GMAWARD    -

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

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

    MXLISTDTL  - References this file to validate list parameters.

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

    WFSETUP    -


INVOKED Programs

    ACCL
    ACSR