AC165 – Percent Complete Calculation
- System
- Activity Management (AC)
- Type
- Batch program
- Updates
- 6 tables
- References
- 35 tables
AC165 (Percent Complete Calculation) is a Lawson Activity Management batch program. It updates ACASNROLE, ACPERCCMPL, ACPERCMPLX, CKPOINT, MXLISTHDR and MXLISTMBR and references ACACCTCAT, ACACCTCATX, ACACTGRP, ACACTIVITY, ACACTMXVAL, ACADDLCNTR, ACAMCODE, ACASNROLE and 27 more.
About AC165
Run Percent Complete Calculation (AC165) to calculate percentage complete for activities. You can measure activity progress by calculating thepercentage of budget completed to date. Using Activity Percentage of Completion (AC65.1), you can store the percentage of completion and revise it when actualconditions deviate from the plan. Revising the percentage of completion also revises the completion amount, or cost to complete. **Processing Effect No means do not use the revenue parameters. Calculate percent complete as an informational measurement of activity progress. When running thisprogram to measure activity progress, enter a posting-level activity. The program calculates percent complete based on the total budgeted amount for theactivity compared to actual costs to date. Yes means use the revenue parameters established on Activity Revenue (AC14.1). Calculate percent complete or gross margin to be used for revenue calculation. When running this program to calculate activity percentage of completion or gross margin, enter the activity for which the revenueestablished on AC14.1 to determine which method to use for the calculation: percentcomplete, gross margin, segment, non-segment, account category group, or total costs. Percent complete is calculated as follows: Percent Complete % = Cost to Date / Life to Date Budget Gross Margin is calculated as folows: Gross Margin % = Gross profit / Contract Amount
Updated files (6)
| Table | Description | System |
|---|---|---|
| ACASNROLE | The Assignment Role file will store the roles associated with a resource assignment. | AC |
| ACPERCCMPL | Activity Percent Complete | AC |
| ACPERCMPLX | Activity Percent Complete Dtl | AC |
| CKPOINT | No description in the Lawson data dictionary | — |
| MXLISTHDR | Attribute List Header | IF |
| MXLISTMBR | Attribute List | IF |
Referenced files (35)
| Table | Description | System |
|---|---|---|
| ACACCTCAT | Activity Account Categories | AC |
| ACACCTCATX | Account Category Detail | AC |
| ACACTGRP | Activity Group | AC |
| ACACTIVITY | Activity | AC |
| ACACTMXVAL | Activity List Attribute Values | AC |
| ACADDLCNTR | Additional Contract Info | BR |
| ACAMCODE | Activity Asset | AC |
| ACASNROLE | The Assignment Role file will store the roles associated with a resource assignment. | AC |
| ACASSIGN | Activity Resource Assignment | AC |
| ACBILL | Activity Billing | BR |
| ACBILLX | Activity Billing Detail | BR |
| ACBUDDTL | Activity Budget | AC |
| ACBUDHDR | Activity Budget Header | AC |
| ACCAL | Activity Calendar | AC |
| ACCALX | Activity Calendar Detail | AC |
| ACCATGRP | Account Category Group | AC |
| ACCATGRPX | Account Category Group Detail | AC |
| ACCATMXVAL | No description in the Lawson data dictionary | AC |
| ACCATSUM | Account Category Summary | AC |
| ACCATSUMX | Account Category Summ Detail | AC |
| ACCNTRACT | Activity Contract | BR |
| ACCONSOL | Activity Consolidation | AC |
| ACCTRCATGX | Contract Category Group Dtl | BR |
| ACGRPMXVAL | The ACGRPMXVAL file is the primary file updated by AC13. | AC |
| ACIFACTV | This file contains activity import information from AC500 (Activity Import). | AC |
| ACMASTER | Activity Balances | AC |
| ACROLE | The Activity Management Role file stores resource roles and descriptions. | AC |
| ACSTATUS | Activity Status | AC |
| GMAWARD | Grant Management Award | GM |
| MXCATDEF | Attribute Definition | IF |
| MXELEMENT | Attribute Element | IF |
| MXLISTDTL | Attribute List Detail | IF |
| MXOBJCAT | Attribute Object | IF |
| STRUCTURE | Category Structure | AC |
| WFSETUP | No description in the Lawson data dictionary | WF |
Program calls
Invoked programs (1)
ACSR