Calculating Percent Complete

Percent complete milestone billing is calculated based on the percentage of the activity that has been completed. Percent complete milestones calculate the percent complete or gross margin based on the contract parameters defined on the contract activity. You can calculate percent complete online or in batch mode.

Note: This procedure is required only for percent complete milestone billing.

To calculate percent complete

  1. Access Percent Complete by Contract (BR65.1).
  2. To calculate percent complete online, use the following guidelines to enter field values:
    Activity

    Select a posting or summary level activity for which you want to calculate percent complete.

    Date

    Type the date as of when you want to calculate percent complete or gross margin.

    Budget Number

    Type the budget number for the activity you want to include in the percent complete calculation.

    Note: You must enter a budget number if billing parameters were defined at the summary level. Leave this field blank if you want to use the active budget when billing parameters are defined at the posting level.
    Budget Type

    Select amount or units for the budget.

    Calculate Over 100 Pct (Percent)

    Select whether or not to calculate percent complete over 100% for the activity. The default is No.

    Cost Account Category Group

    Select an account category group to restrict the account categories used in the percent complete calculation.

    Note: Use the Special Actions form action to add the calculation. When the calculation is added, the following fields are updated. You can edit those fields as needed.
    Cost to Complete and Percent Complete

    When no costs have been posted to the activity, but you want to generate billing, you can manually enter an amount in the Cost to Complete field or a percent in the Percent Complete field.

    Gross Margin

    Leave this field blank for billing purposes.

  3. If you want to calculate percent complete by activity, click the Posting Activities button to open Percent Complete by Activity (BR65.2).
  4. If you want to calculate percent complete by account category, click the Account Categories button to access Percent Complete by Account Category (BR65.3).
  5. To calculate percent complete for multiple activities, or when no edits to the calculated amounts are anticipated, access Percent Complete Calculation (BR165). Use the following guidelines to enter field values
    Activity Group List / Activity Group / Activities / Activity List

    Select the activity group, up to six activities, or an activity or activity group list for which you want to calculate percent complete.

    As of Date

    Type the date through which you want to calculate percent complete.

    Budget

    Select the budget number for the activity you want to include in the percent complete calculation.

    Budget Type

    Select whether the budget is calculated as an Amount (A) or in Units (U).

    Account Category Group

    Select an account category group to restrict the account categories used in the percent complete calculation.

    Account Categories

    Select the range of account categories for which you want to calculate percent complete.

    Calculate Over 100 Pct (Percent)

    Select whether or not to calculate percent complete over 100% for the activity (activities). The default is No.

    Calculation Level

    Select the level at which revenue will be calculated. Valid options are:

    • Posting (P)

    • Contract (C)

    • Posting/Acct Cat (1)

    • Contract /Acct Cat (2)

    Update

    Select whether to update the activities you selected with the percent complete calculations or to view a report of the changes that will occur when you choose to update.

    Select Yes (Y) to update. Select No (N) to get a report instead of updating. The default is No.

Related topics