Enter, or click to select, a valid project for which ACRN billings are calculated. This field is required. The field to the right displays the project name.

The project must be exist on the Manage Project Billing Information screen and must be transaction-based. A transaction-based billing formula is one that is billed according to the transactions that were charged to the project and used by the Calculate Standard Bills screen. The transactions-based billing formulas include all the formulas except Enter Bill Manually and Manual Bills with Unbilled Detail. You cannot use a Progress Payment formula with ACRN bills.

The level of the project in this field defines the level at which the project ACRN allocation amounts are calculated. All transactions at this level and below are included in the calculations.

Select this check box if the project is active. This check box is selected by default when a project is set up, but can be modified.

Use this check box to enable ACRN billing calculations. During initialization, you can clear the check box to prevent ACRN allocation amounts from being computed until all data has been entered and verified. You can also clear the check box after a project lifespan is over to prevent future calculations.

If you select this check box, you can modify the Project Level At and Below field in the table window. This check box is available only when the Billing Requirement is ACRN Only with Mapping or ACRN/Line Item with Mapping.

Select this option to invoice an ACRN and dollar amount. If you select this option, there is no restriction on how costs are allocated to the funding pools (ACRNs); Labor and Other Direct Costs can be paid by any active ACRN with available funds.

Example:

ACRN data exists as follows:

If a Standard Bill is calculated and results in the following amounts:

The ACRN allocation on the standard bill looks as follows:

Select this option to invoice an ACRN and dollar amount and require direct accounts or PLCs to be linked to each ACRN. If you select this option, no restriction exists on how costs are allocated to the funding pools (ACRNs).  

Example #1:

• ACRN AA has been funded in the amount of $2,500.00 for Direct Labor. 
• ACRN AB has been funded in the amount of $3,500.00 for Other Direct Costs.

The mapping of Accounts provides a mechanism to associate direct costs to specific funding pools. In the Accounts subtask for ACRN AA, enter Direct Labor accounts. On the Accounts subtask for ACRN AB, enter Other Direct Cost accounts.

ACRN data exists as follows:

If a Standard Bill is calculated and results in the following amounts:

The ACRN allocation on the Standard Bill looks as follows:

If you select this option and the Project Account Group is not specific to the ACRN row(s), you must link accounts or PLCs to each ACRN line.

Example #2:

Assuming the project has a Loaded Labor Rate billing formula, you could use the PLC Mapping subtask to assign the Engineering Labor PLC (ENG) to ACRN AA, and the Tech Support PLC (TECH) to ACRN AB. For ACRN AC, you could use the Accounts subtask to map the applicable material general ledger accounts.

Select this option to invoice an ACRN, an associated line item, and dollar amount. If you select this option, no restriction exists on how costs are allocated to the funding pools (ACRNs); Labor and Other Direct Costs can be paid by any active ACRN/Line Item with available funds.

Example:

ACRN data exists as follows:

If a Standard Bill is calculated and results in the following amounts:

The ACRN allocation on the Standard Bill looks as follows:

Select this option to invoice an ACRN, an associated Line Item, and dollar amount, and to require direct accounts or PLCs to be linked to each ACRN/Line Item. If you select this option, no restriction exists on how the costs are allocated to the funding pools (ACRNs).

Example #1:

• ACRN/Line Item AA/0001AA has been funded in the amount of $2,500.00 for Direct Labor.
• ACRN/Line Item AA/0001AB has been funded in the amount of $1,500.00 for Direct Labor.
• ACRN/Line Item AB/0002 has been funded in the amount of $3,500.00 for Other Direct Costs.

  On the Accounts subtask for ACRN/Line Item AA/0001AA, enter Direct Labor accounts. On the Accounts subtask for ACRN/Line Item AA/0001AB, enter Direct Labor accounts. On the Accounts subtask for ACRN/Line Item AB/0002, enter Other Direct Cost accounts.

  If a Standard Bill is calculated and results in the following amounts:

  	Amount
  Direct Labor	$3,500.00
  Other Direct Costs	$1,500.00
  Total Invoice Amount	$5,000.00

  The ACRN Allocation on the Standard Bill looks as follows:

  ACRN	Line Item	Amount
  AA	0001AA	$2,500.00
  AA	0001AB	$1,000.00
  AB	0002	$1,500.00

  If you select this option and the Project Account Group is not specific to the ACRN row(s), you must link accounts or PLCs to each ACRN line.

  Example #2:

  ACRN	Line Item	Amount	ACRN Obligation
  AA	0001AA	$1,500.00	Engineering Labor
  AA	0001AB	$2,500.00	Tech Support Labor
  AB	0002	$4,000.00	Travel

  Assuming the project has a Loaded Labor Rate billing formula, you could use the PLC Mapping subtask to assign the Engineering Labor PLC (ENG) to ACRN AA/Line Item 0001AA, and the Tech Support PLC (TECH) to ACRN AA/0001AB. For ACRN AB/Line Item 0002, you could use the Accounts subtask to map the applicable travel general ledger accounts.

Select this option to allocate ACRN amounts using a "First In, First Out" methodology (ACRN AA funds are used before ACRN AB funds.) The Sequence Number linked to each ACRN and/or Line Item determines the order of funds used.

Example:

ACRN data exists as follows:

If a Standard Bill is calculated and results in the following amounts:

The ACRN allocation on the Standard Bill looks as follows:

Select this option to allocate ACRN amounts using a "Last In, First Out" methodology (ACRN AB funds are used before ACRN AA funds.)  The Sequence Number linked to each ACRN and/or Line Item determines the order of funds used.

Example:

ACRN data exists as follows:

If a Standard Bill is calculated and results in the following amounts:

The ACRN Allocation on the Standard Bill looks as follows:

Select this option to use a ratio of available funds for each ACRN and/or ACRN/Line Item to the total remaining funds for all ACRNs. Costpoint applies the resulting ratio to the total amount(s). 

Example:

ACRN data exists as follows:

If a Standard Bill is calculated and results in the following amounts:

The ACRN allocation on the Standard Bill looks as follows:

The calculations for the proration are as follows:

Select this option to allocate ACRN amounts based on the expiration date of the funds. When you select this method, you must enter a date in the Expiration Date field in every ACRN line in the Project ACRN Details table. When the record is saved, the Seq No fields in the table window will be reordered based on the value in the Expiration Date field, with the earliest date with the lowest Seq No value.

Costpoint uses the FIFO calculation method when this option is selected since the allocation of amounts will be the same as FIFO after the sequence numbers are reordered from the earliest to the latest expiration date. If multiple entries have the same expiration date, the rows will be reordered based on the original sequence number.

Example 1: Multiple ACRNs with the same expiration date

When the record is saved, the rows will be reordered based on the original sequence number:

Example 2: ACRN with multiple SLIN/Line Items having the same expiration date

When the record is saved, the rows will be reordered based on the original sequence number:

This field displays the total of all funding applicable to the project levels at and to which the Manage ACRN Bills screen is linked. The amount is derived from the total funded values (PROJ_F_TOT_AMT) in PROJ. Regardless of whether or not the Use Project Mapping check box is selected, this field will be equal to the total funding at and below the ACRN project level.

This field displays the sum of the Total ACRN Value amounts in the table window.

This field displays the sum of the Current ACRN Allocation Value amounts in the table window.

This field displays the sum of the Previous ACRN Allocation Value amounts in the table window.

This field displays the sum of the Remaining ACRN Allocation Value amounts in the table window.

This field displays the calculated invoice amount for this project. The invoice amount is derived from the Manage Standard Bills screen. If an invoice has not been calculated for the project, 0.00 displays in the field.

Enter a sequence number in this required field to specify the order in which the ACRN or ACRN/Line Item is evaluated when Costpoint allocates ACRN amounts. If the Calculation Method is FIFO, Costpoint first evaluates the line with a sequence number of "1," followed by "2," and so on. If the Calculation Method is LIFO, Costpoint first evaluates the line with the maximum sequence number, followed by the next maximum number, and so on. If the Calculation Method is Proration, Costpoint uses the sequence number only for rounding issues. If rounding issues exist, the amount is allocated to the line with the smallest active sequence number with available funds.

Enter the code that is used as the Accounting Classification Reference Number. This is a required field.

Select this check box if the ACRN or ACRN/Line Item is active. This check box is selected by default when a new line is added to the table window, but you can modify it.

Use this check box to enable ACRN billing calculations. If you select this check box, the line is eligible for ACRN allocation amounts. If the check box is cleared, the line is not eligible for ACRN allocation amounts; this can be helpful when the period of performance of an ACRN or ACRN/Line Item has expired.

Enter a maximum of six-characters to identify the Contract Line Item (CLIN), Subcontract Line Item (SLIN), or Exhibit Line Item (ELIN). This field is visible and required when the Billing Requirement is ACRN/Line Item or ACRN/Line Item w/Account Mapping. 

Enter an amount for the ACRN or ACRN/line item.

This field displays either a user-supplied value for the project, or a Costpoint-calculated value that is updated by the Post Standard Bills application. You can edit this field.

This field displays a Costpoint-calculated value updated by the Calculate ACRN Bills screen. 

You can edit this field if a standard bill exists on the Manage Standard Bills screen. If you modify this field, be careful to ensure the total amount of the Current ACRN Allocation Value field reconciles to the invoice amount of the standard bill. If the two amounts are different, future ACRN billing allocation amounts may be incorrect.

Costpoint calculates in this field by adding the Previous ACRN Allocation Value and the Current ACRN Allocation Value fields.

Costpoint calculates in this field by subtracting the Total ACRN Allocation Value field from the Total ACRN Value field.

Enter the SDN for the ACRN.

You can edit this field only when the Billing Requirement is ACRN Only with Mapping or ACRN/Line Item with Mapping and the Use Project Mapping check box is selected. If these requirements are not met, this field displays the billing level project number.

If you are upgrading from 6.0, you cannot modify the Project Level At and Below field (PROJ_ACRN_DETL.TRN_PROJ_ID) for existing rows in the table. This rule preserves the integrity of the data and the previously billed amounts. If you upgrade and need to calculate allocation amounts at a level below the billing project number, you must add a new line (or multiple lines) to add the new lower level transaction data and then delete the original line.

Enter, or click to select, a child of the billing level project number. The project number entered must exist in the project tree and be at or below the invoice project number (PROJ_BILL_ACRN.PROJ_ID). All tasks below the entered project number are used for that row’s calculation (essentially wildcarding all project data at and below the entered project). You cannot stack the project data for any part of the project tree on multiple lines. This is a required field.

Since stacking is not allowed, a problem may arise if you are using schedule bill amounts. A schedule bill amount is a fixed amount invoiced on a standard bill that is calculated at the billing level. If you use project mapping, the stacking restriction prevents you from locating and allocating the schedule bill amount. You must indicate where the schedule bill amount is mapped by selecting the Include Schedule Bill check box for a row. You can select the Include Schedule Bill check box for only one row.

An Example of Wildcarding in the Project Level At and Below field:

The following data exists for a project:

ACRN AA is funded for all Labor, Engineering Labor, and Support Labor. However, a contract requirement specifies that the labor must be invoiced on separate tasks. ACRN AB is funded for all computer purchases and ACRN AC for the maintenance contracts on the computer purchases.

ACRN AA is funded for $15,000.00, which encompasses all labor, but the funding is not broken down by Engineering versus Support Labor. You might try to enter the data in the table window for ACRN AA as follows:

As you can see, there is no way to break out the $15,000.00 funding amount accurately. If you enter $15,000.00 as the Total ACRN Value for sequence number 1, you would have to enter 0.00 for sequence number 2, which is not correct. You cannot enter $15,000.00 as the Total ACRN Value for both sequence numbers 1 and 2 because this overstates the funded value. Since the labor isn't funded by project labor category, there is no way to detail the $15,000.00 funding amount.

Using wildcards, you could set up the data as follows:

Select this check box to include schedule bill amounts for this ACRN or ACRN/Line Item. You can edit this check box only when the Billing Requirement is ACRN Only with Mapping or ACRN/Line Item with Mapping and the Use Project Mapping check box is selected.

Use this field to enter a sequence number to reorder the records in the table window. When you save the record, the number in the Seq No Change column becomes the number in the Seq No column, and the rows are reordered to reflect the changed number. This field allows you to assign a sequence number to new ACRN/Line Item rows that need to be inserted with a sequence number different from the system-generated number. In a table with many records, you can use the Query function in the table window to return limited records, and then insert Seq No Change values for those records. Upon saving, Costpoint rearranges ALL rows based on the values you specified. Seq No Change remains populated until the invoice is posted.

You can edit this field unless the calculation method is Earliest Expiring Funds.

Enter, or click to select, an expiration date for the ACRN or ACRN/Line Item. If you select the Earliest Expiring Funds calculation method, this field is required and is used to reorder the Seq No column based on the expiration date when the record is saved. This field is available but is not used in the other calculation methods.

This check box is enabled only when the Track ACRN Change History option is selected on the Configure Billing Settings screen. If you make changes to a line in the table window, this check box is automatically selected when you save the record, and it remains selected until the invoice is posted. This option allows you to see which ACRN lines had changes made until the invoice is posted. After the invoice is posted, the check box will be cleared.

This field is enabled only when the Track ACRN Change History option is selected on the Configure Billing Settings screen. If you make changes to a line in the table window, this is populated with your user ID and remains populated until the invoice is posted. This field allows you to see which ACRN lines were changed and by whom. Although only the user ID of the last user is displayed in the table window, all users who made changes to an ACRN line are listed in the Change History table. After the invoice is posted, the User field becomes blank.

This check box is enabled only when the Track ACRN Change History option is selected on the Configure Billing Settings screen. If you make changes to a line in the table window, this check box is automatically selected when you save the record. After records are inserted into the Change History table, the Change History check box will remain selected and you can no longer edit this check box or the other fields in the Change History table. Furthermore, you will not be able to delete any line in the table window where this check box is selected and if that line exists in the PROJ_ACRN_DETL_HS table.