Defining activity group templates

Use this procedure to create templates for activity group information. You can use the templates to add or import new activity groups in Project Accounting.

  1. Specify a name and description for the template you are creating.
  2. Access Activity Group Template (AC70.1).
  3. On the Main tab, use these guidelines to specify the field values:
    Category Structure

    Specify or select the account category structure for the activity group. The account category structure determines which account categories are available for the activity group.

    Note: You can set up specific posting activity/account category assignments on Override Account Categories (AC06.1) if necessary. Any relationships set up on AC06.1 override the parameters of the account category structure that you select here.
    Base Currency

    Specify or select the operating currency for the activity group. This is the currency used for reporting and inquiries at the activity group level. The activity group base currency determines the currency you must assign to summary and contract level activities within the activity group.

    Calendar

    Specify or select the calendar that you want to assign to the activity group.

    Date Range

    Specify the dates that identify the valid time period (dates of operation) for the activity group. You can use any dates you want, as long as they are supported by the years and periods in the calendar that you assign to the activity group.

    Security

    To enable the security for the activity group, specify a 4-digit number.

    If there is a one-to-one relationship between the activity group and a General Ledger company, then you can use the General Ledger company number. If there is no one-to-one relationship between the activity group and the General Ledger company, then use a unique number to identify the activity group in Lawson security.

    Activities act as process levels in Lawson security. To set security on specific activities within the group, name the activities carefully and set security on a range of activities. For more information on security, see your Lawson security administrator.

    Status

    Select the activity group status. The default status is Open. If you are using activities as a subset of General Ledger, then select GL Only.

    Output Measure

    Specify a numeric activity group output measure and a description. The output measure is used on Activity Group Output Measure Analysis (AC93.1 and AC493) to calculate a per unit cost for the activity group. For example, if the activity group is for construction of a new store, you can use the store's number of square feet as the output measure to get a cost per square foot.

    Invoice Audit

    If you use the Lawson Billing and Revenue Management application, select Yes (Y) to keep an audit trail of invoice changes. The default is No (N).

    Note: You do not have to select Yes to edit invoice amounts.
    Change Order Audit

    Select whether to keep an audit trail of budget change orders. The default is No. You do not have to set this to Yes to use change orders.

  4. On the Process tab, specify activity group process parameters to determine how amounts in activities are summarized, and how various validations are performed for data entered in activities associated with the activity group. Use these guidelines to specify the field values:
    Balances
    Summary Activity

    Select Yes to consolidate activity amounts in summary level activities and at the activity group level. It is recommended that you accept the default, which is Yes. To preserve data integrity, you cannot change this parameter from No to Yes.

    Summary Acct Cat

    Select Yes to consolidate activity amounts in the lowest level summary account categories (not all levels). It is recommended that you accept the default, which is Yes. To preserve data integrity, you cannot change this parameter from No to Yes.

    Accounting Unit

    Select Yes to maintain balances in activities by account category, company, and accounting unit. You can acquire company and accounting unit balances without building them into your activity structure. To preserve data integrity, you cannot change this parameter from No to Yes.

    If you set this option to Yes, run Accounting Unit Balance Post (AC191) after you post transactions using Activity Posting (AC190) or run Activity Posting (AC190) with the Post Acct Unit Balances field set to Yes.

    Billing LTD

    If you select Yes, you can include this information on customer invoices.

    Resource

    Select Yes to maintain resource balances in activities. If you selected Yes in the Acct Unit Balances field, balances are maintained by activity, account category, company, accounting unit, and resource. If you selected No in the Acct Unit Balances field, balances are maintained by activity, account category, and resource.

    To preserve data integrity, you cannot change this parameter from No to Yes.

    If you set this option to Yes, you need to run Accounting Unit Balance Post (AC191) after you post transactions using Activity Posting (AC190) or run Activity Posting (AC190) with the Post Acct Unit Balances field set to Yes.

    Validation
    Employee

    If you use the Lawson Human Resources application, then this field determines how employees used in transactions are validated during data entry.

    If you select Yes, then you must assign employee resources to activities in order to enter transactions containing an employee and an activity. You can specify resources on HR Employee Assignment (AC03.3).

    Date

    Transactions posted to activities must fall within a date range assigned to the activity. Select whether you want the system to use the posting date or transaction date in the transaction record when the validation is performed. For example, you used time on an activity on June 7 (transaction date), but the time falls within the pay period ending June 15 (posting date).

    • Select Posting Date (P) to use the posting date for the transaction. If the posting date is before the activity begin date or later than the activity's end date, the transaction is not permitted.

    • To use the date when the transaction was made, select Transaction Date (T). If the transaction date is before the activity begin date or later than the activity's end date, then the transaction is not allowed.

    Note: If you are using period of performance dates, then the transaction or post date is compared against the POP dates for a system code, rather than the activity dates.
    Resource

    Select whether you want to validate AC person and equipment resources in transactions.

    Bill Rate Calc

    If you use the Lawson Billing and Revenue Management application, then select Posting (P) or Transaction (T) date to determine which date to use to calculate billing when you run Activity Posting (AC190). The date type you select determines which date on the ACTRANS record is used to compare against the effective date on resource rates, assigned resource rates, or billing category rates for the T&M billing method.

    Vendor

    If you use the Lawson Accounts Payable application, then this determines how vendors used in transactions are validated during data entry.

    • Select Yes (Y), and assign vendor resources to activities.

      If you select Yes, then you must assign vendor resources to activities on Vendor Assignment (AC03.4) in order to enter transactions containing a vendor and an activity (including requisitions and purchase orders).

    • Select No (N), and no need to assign vendor resources to activities.

    Burden Date

    Select whether to use the activity posting date (P) or transaction date (T) to find the burden rate when burden transactions are created.

    Asset

    If you use the Lawson Asset Management application and plan to capitalize activities, then this field determines whether users are required to enter an asset Location and Division on the Defaults tab in Activity (AC10.1). When the location and division are known at the time the activity is created, select Yes.

    POP Date

    Select Yes to allow the application to search for period of performance dates for the activity group.

    If you selected Yes, and a system code has period of performance dates, then the period of performance dates are used for the date edit. See Period of performance.

    GL Acct Assignment

    Select the level of GL account validation for the activity group. These are the available options:

    • GL Only Activity Group

    • No

    • Yes-Substitute error suspense when assignment is not valid on Account Assignment (AC07.1)

    • Yes-Require valid assignment on Account Assignment (AC07.1)

    Other
    Calculate Burdens

    Select Yes (Y) to process burdens for activities in the activity group.

    Burdens are transactions generated automatically during Activity Posting (AC190) to track additional costs associated with activities.

    PR Commitment

    Select Yes (Y) to create Payroll commitments.

  5. Use these guidelines to specify the field values:

    Budget Checking

    Select one of these options to determine the budget time frame to use for budget edits:

    • Use Period Edit (2) to perform the edit using the active period-to-date budget.

    • Use Annual Edit (3) to perform the edit using the active year-to-date budget.

    • Use Total Edit (4) to perform the edit using the active life-to-date budget.

    • Use No Edit (1), the default, if you do not wish to enable budget edits.

    If budget amounts are validated, the system validates whether actuals plus commitments are less than or equal to the budget plus the budget tolerance. The edits are performed in the applications that you select on System Codes (GL01.4).

    Note: Period Edit and Annual Edit options are not valid with a Life Only budget.
    Level

    Select one of these options to determine the budget level to use for budget edits:

    • Use Activity-Acct Cat (1) to perform the edit using the budget for the activity and account category specified in the transaction.

    • Use Activity Group (2) to perform the edit using the activity group budget. The system uses the budget for the activity group associated with the activity in the transaction.

    • Use Activity (3) to perform the edit using the total budgets for all account categories in the activity specified in the transaction.

    • Use Activity-Summary Account Cat (4) to perform the edit using the budget for the summary account category in the activity specified in the transaction.

    • Use Contract Funding (5) for Grant Billing Activity Groups. The contract funding budget edit compares project costs to the contract budget amount stored on the Multi-Funded Contract (GM20.1). This edit allows you to define a budget at the Project/contract level. Other budget edits require the entry of budgets at the posting activity account category level and are maintained in Activity Budget (AC20.1). If the contract funding budget edit is selected at the Activity Group level (AC00.1), then you cannot override it at the posting level Activity (AC10.1).

    Tolerance

    Specify the percentage by which the budget can be exceeded. For example, to allow budgets to exceed by 5 percent, enter 5.00.

    Estimated Maximum

    Specify the maximum budget allowed for the activity group. This amount includes the budget amounts for each activity within the activity group. The Allocated field displays the amount used from the budget.

    This is informational only, and shows a message during activity budget entry when the total activity budgets exceed the maximum. The warning message shows on Activity Budget (AC20.2) to indicate that the total activity budget exceeds the maximum amount. It does not prevent you from exceeding the budget.

  6. If you use Databasics TimeSite or ExpenseSite web-based time and expense entry systems with Project Accounting, specify the activity group time and expense parameters on the Time and Expense tab.
  7. On the Levels tab, specify the activity group levels to identify the rules for structuring activities. Use these guidelines to specify the field values:
    Name

    Specify a description of the activity levels you want in the activity group. Examples of levels are project, phase, task, contract, etc. You can specify up to five levels of activities.

    Size

    Specify the size of each level, which determines the maximum number of activities you can set at that level.

    Note: You can change a level's description at a later date, but you cannot change its size. Ensure there is enough room for all the activities you need at a given level.
  8. To use multiple reporting currencies in activities, specify the activity group currency parameters on the Currency tab. Use these guidelines to specify the field values:
    Currency Table

    Select a currency table. The currency table stores currency relationships and exchange rates that are used to convert transaction amounts to the activity group currency, the activity group's report currencies, and the posting activity currency.

    Report Currency

    Specify up to two currency names and associate each with a currency code from the Lawson Currency application. You can inquire and report on activity amounts using the base currency or report currencies.

    The report currencies you select in the activity group determine the report currencies you can have in activities. You cannot specify a different report currency in activities.

    Note: If you are using Billing and Revenue Management, Lawson recommends that you assign one of your reporting currencies or base currency to match the Invoice Currency on Contract Parameters (BR10.1). This lets you see balance amounts, such as cost and revenue, in the contract currency.
  9. To keep an audit trail of changes or deletions made to specific activity-related parameters, specify the activity group history parameters on the History tab. Use these guidelines to specify the field values:
    Activity

    Select whether changes made to activities are tracked. The default is No. To view the changes, run Activity Listing (AC210) or Activity Group Listing (AC200).

    Asset

    Select whether changes made to activity assets are tracked. The default is No.

    Resource Assignment

    Select whether changes made to resource assignments are tracked. The default is No.

    Attribute

    Select whether changes made to activity attributes are tracked. The default is No.

    Billing

    Select whether billing changes are tracked. The default is No.

    Contract

    To maintain an audit trail of changes to contract information in the application, select Yes.

    Ceiling

    Select whether changes made to ceiling amounts are tracked. The default is No.

    Note: History details are erased when you run Activity Group Purge (AC300) for the activity group.