Billing Requirement Includes Mapping and PROJ_MAP_FL is Y - FIFO

Use this section to see examples of calculations for ACRN Only with Mapping and PROJ_MAP_FL = Y and ACRN/Line Item with Mapping and PROJ_MAP_FL = Y using the First In First Out (FIFO) methodology.

Transaction project level projects are used to calculate ACRN allocation amounts. Enter, or use to select, a summary or transaction level project in the Project Level At and Below field on the Manage ACRN Bills screen. The project number entered is wildcarded. You can repeat same project number on multiple lines in the child window table, but you cannot enter multiple lines in the child table window that are part of the same project tree branch. For example, you cannot enter project 1000.01 on one line and 1000.01.01 on another. This creates a circular calculation.
PLCs can be mapped to an ACRN or ACRN/Line Item. If a PLC is mapped for a specific line, an Account cannot be mapped to the same line.
Mapping (an Account or PLC record) is NOT required. Many users have their project structures set up to restrict which accounts are eligible to charge a project by using the PAG or the Limit Accounts functionality. It is redundant to require you to re-map the same accounts. If accounts or project labor categories are not mapped for a particular ACRN or ACRN/Line Item sequence number, ALL accounts found in the BILL_EDIT_DETL table are eligible for the allocation calculation. If the same project number is used on multiple lines in the child table window in the Project Level At and Below field on the Manage ACRN Bills screen and you map an account or project labor category for any row, all rows in the table for that specific project require account or project labor mapping. This helps prevent circular calculations. If another row exists in the child table window with a different project number value, accounts or project labor categories do not need to be mapped unless that project number is repeated on multiple lines. Mapping may exist for some lines, but not all.
If mapping is used, overlapping of accounts is not permitted.
Over Ceiling Amounts are calculated by the Calculate Standard Bills screen. The Over Ceiling amounts are stored in new fields added to BILL_EDIT_DETL (WAWF_CST_CEIL_AMT, WAWF_FEE_CEIL_AMT, WAWF_TOT_CEIL_AMT).
Retainage calculation was removed from the Calculate ACRN Bills process and added to the Calculate Standard Bills screen. The retainage amounts are stored a new field added to BILL_EDIT_DETL (WAWF_RTNGE_AMT).
Allocating Schedule Bill amounts require an extra step. When the Use Project Mapping check box is selected, you enter project levels below the invoice level. Schedule Bill amounts are stored at the billing level (INVC_PROJ_ID) in BILL_EDIT_DETL. To allocate the Schedule Bill amount to an ACRN or ACRN/Line Item, use the Include Schedule Bill field in the table window. You can select one row, and only one row, in the child table window to indicate where the Schedule Bill amount, if any, is allocated.

Since the PROJ_MAP_FL = Y, all calculations are performed at the transaction level (TRN_PROJ_ID).

A contract is awarded with the following Accounting Classification data:

Line Item	Subline Item	ACRN	Accounting Appropriation Number	Funding Amt
0001	0001AA	AA	5793400309475A110704040004081572806F503000 F03000	7,000.00
0001	0001AB	AA	5793400309475A110704040004081572806F503000 F03000	11,000.00
0002	0002AA	AB	8893400309475A110704040004081572806F336000 F07700	12,000.00
0002	0002AB	AB	8893400309475A110704040004081572806F336000 F07700	14,000.00
0003	0003AA	AA	5793400309475A110704040004081572806F503000 F03000	20,000.00
0003	0003AB	AB	8893400309475A110704040004081572806F336000 F07700	15,000.00
0004	0004AA	AC	7765658810475A110704040004081572806F336000 C15500	80,000.00
0005	0005AA	AD	4582265450475A110704040004081572806F336000 K17700	25,000.00

Project Setup Data:

Project Number: USN0418

Billing Level: USN0418

Set up the ACRN data as follows on the Manage ACRN Bills screen. Some accounts and PLCs are mapped.

Seq No	ACRN	SLIN/Line Item	Active	Total ACRN Value	Remaining ACRN Allocation Value	Project Level At and Below	Include Schedule Bill
1	AA	0001AA	Y	7,000.00	7,000.00	USN0418.01.01
2	AA	0001AB	Y	11,000.00	11,000.00	USN0418.01.01
3	AA	0003AA	Y	12,000.00	12,000.00	USN0418.01.02
4	AB	0002AA	Y	20,000.00	20,000.00	USN0418.02.01
5	AB	0002AB	Y	14,000.00	14,000.00	USN0418.02.01
6	AB	0003AB	Y	15,000.00	15,000.00	USN0418.02.02
7	AC	0004AA	Y	80,000.00	80,000.00	USN0418.03	Y
8	AD	0005AA	Y	25,000.00	25,000.00	USN0418.04

Furthermore, the ACRN Funding is based upon specific resources. The specific resources can be associated with direct accounts or PLCs. The ACRN, Resource, Account, and PLC breakdown are defined as follows:

ACRN	SLIN/Line Item	Resource	Accounts	PLC Mapping
AA	0001AA	Labor		EN
AA	0001AB	Labor		EN
AA	0003AA	Labor		AD
AB	0002AA	ODCs	05030
AB	0002AB	ODCs	05030
AB	0003AB	ODCs	05030
AC	0004AA	Maintenance Contract	01200-010
AD	0005AA	All Costs	(no mapping)	(no mapping)

Set up the account data as follows on the Accounts subtask of the Manage ACRN Bills screen.

PROJ_ACRN_ACCT

ACRN	SLIN/Line Item	Project Level At and Below	Starting Account	Ending Account
AB	0002AA	USN0418.02.01	05020	05030
AB	0002AB	USN0418.02.01	05020	05030
AB	0003AB	USN0418.02.02	05040	05090
AC	0004AA	USN0418.03	01200-010	01200-010

Set up the PLC (Project Labor Category) data as follows on the PLC Mapping subtask of the Manage ACRN Bills screen.

PROJ_ACRN_PLC

ACRN	SLIN/Line Item	Project Level At and Below	PLC	Description
AA	0001AA	USN0418.01.01	EN	Engineer
AA	0001AB	USN0418.01.01	EN	Engineer
AA	0003AA	USN0418.01.02	AD	Admin Support

A Standard Bill (calculated by the Calculate Standard Bills screen) produces the following invoice amounts for Project USN0418 (SUM(MU_INVC_AMT) in BILL_EDIT_INVC_HDR):

USN0418: 82,077.50

Calculation Logic

For the ACRN/Line Item with Mapping methodology with PROJ_MAP_FL = Y, the TRANSACTION LEVEL project number is used for the calculation. Account and PLC mapping may occur. When mapping occurs, BILL_EDIT_DETL is used to calculate the allocation amounts in addition to the new fields added to BILL_EDIT_DETL (WAWF_CST_CEIL_AMT, WAWF_FEE_CEIL_AMT, WAWF_TOT_CEIL_AMT, WAWF_RTNGE_AMT) for any over ceiling and retainage amounts. Schedule Bill amounts (S_TRN_TYPE = SCH), if any, is allocated to the line where the PROJ_ACRN_DETL.APPLY_RESIDUAL_FL = Y. BILL_EDIT_INVC_HDR is used to determine whether a calculation should occur.

Check PROJ_BILL_ACRN to see if data exists for the project(s).

Project data exists for Project USN0418. Continue calculation.

Verify the Billing Requirement: PROJ_BILL_ACRN.ACRN_BASIS_CD = AL; ACRN/Line Item with Mapping.

Verify the PROJ_MAP_FL value: PROJ_BILL_ACRN.PROJ_MAP_FL = Y.

Check the ACTIVE_FL in PROJ_BILL_ACRN for the project. If the PROJ_BILL_ACRN.ACTIVE_FL = Y, continue calculation. If the PROJ_BILL_ACRN.ACTIVE_FL = N, end calculation for this Project and check for existence of next Project, if any.

The ACTIVE_FL = Y for Project USN0418. Continue calculation.

Check BILL_EDIT_INVC_HDR to verify the Status of the invoice. If the Status is Selected, Reverse, or Void (BILL_EDIT_INVC_HDR.S_BILL_STATUS_CD IN (S, R, V)), store SUM(MU_INVC_AMT) and continue calculation. If the Status is Unselected (BILL_EDIT_INVC_HDR.S_BILL_STATUS_CD = U), end calculation.

The Status of Project USN0418 is Selected. BILL_EDIT_INVC_HDR.S_BILL_STATUS_CD = S. Continue calculation.

Summarize the billable amounts from BILL_EDIT_DETL based upon the TRN_PROJ_ID, ACCT_ID, and Billable Amount.

Billable Amount = SUM(MU_BILL_AMT + MU_SALES_TAX_AMT + MU_RTNGE_AMT + MU_OVRFEE_CL_AMT + MU_OVRTOT_CL_AMT + MU_OVRCST_CL_AMT - MU_DISC_AMT)

If the Billable Amount is 0.00 for each account (where the ACCT_ID is NOT NULL), end calculation. If the Billable Amount does not equal 0.00 for any account, continue calculation. Even if the sum of all the accounts is 0.00, continue the calculation in case costs are moved from one account to another, thus having a possible affect on the ACRN balances.

Invoice #1 produces the following billable amounts:

Table 1: Billable Amount Calculation

ACCT_ID	Billable Amount (1) BILL_EDIT_DETL
05000-010	17,500.00
05000-020	19,250.00
05030	30,000.00
05040	5,000.00
01200-010	10,750.00
NULL	422.50

(1) Billable Amount = SUM(MU_BILL_AMT + MU_SALES_TAX_AMT + MU_RTNGE_AMT + MU_OVRFEE_CL_AMT

+ MU_OVRTOT_CL_AMT + MU_OVRCST_CL_AMT - MU_DISC_AMT)

Billable amount does not equal 0.00 for all accounts; calculation continues.

Check for Retainage and Over Ceiling amounts in BILL_EDIT_DETL (S_TRN_TYPE in (OT, OF, OC, R)). These transactions are stored in BILL_EDIT_DETL without an ACCT_ID so you cannot map retainage or over ceiling amounts via the Accounts subtask in the Manage ACRN Bills screen. New fields have been added to BILL_EDIT_DETL to redistribute these amounts to a transaction project, account, CLIN, PLC level.

Sum and group the Billable Amount (formula above) by S_TRN_TYPE (OT, OF, OC, R) by INVC_PROJ_ID. If any row produces an amount not equal to 0.00, then new BILL_EDIT_DETL fields (WAWF_XXXX) are used. If no rows are returned, or if billable amount for all rows is 0.00, the source of the allocation amounts is the billable amount from BILL_EDIT_DETL.

The calculation produces the following amounts by INVC_PROJ_ID, S_TRN_TYPE.

Table 2: Retainage and Over Ceiling Amounts

S_TRAN_TYPE	Billable Amount (1) BILL_EDIT_DETL
OT	55.00
R	367.50

(1) Billable Amount = SUM(MU_BILL_AMT + MU_SALES_TAX_AMT + MU_RTNGE_AMT + MU_OVRFEE_CL_AMT

+ MU_OVRTOT_CL_AMT + MU_OVRCST_CL_AMT - MU_DISC_AMT)

This produces amounts not equal to 0.00, so the new BILL_EDIT_DETL fields are used to determine the allocation amounts by account. The BILL_EDIT_DETL table displays the following amounts:

Table 3: BILL_EDIT_DETL

INVC_PROJ_ID	TRN_PROJ_ID	ACCT_ID	BILL_LAB_CAT_CD	WAWF_TOT_CEIL_AMT	WAWF_RTNGE_AMT
USN0418	USN0418.01.01	05000-010	EN	0.00	140.00
USN0418	USN0418.01.02	05000-020	AD	0.00	180.00
USN0418	USN0418.02.01	05030		45.83	0.00
USN0418	USN0418.02.02	05040		9.17	0.00
USN0418	USN0418	01200-010		0.00	0.00
USN0418	USN0418.04.01	05000-010	AD	0.00	35.00
USN0418	USN0418.04.02	05000-010	EN	0.00	12.50
USN0418	USN0418.04.03	05030		0.00	0.00

The Retainage and Over Ceiling amounts from the BILL_EDIT_DETL table must be deducted from the original Billing Amounts from BILL_EDIT_DETL grouped by TRN_PROJ_ID/ACCT_ID/ITEM_ID/BILL_LAB_CAT_CD.

Table 4: Adjusted Billable Amount Calculation

INVC_PROJ_ID	TRN_PROJ_ID	ACCT_ID	BILL_LAB_CAT_CD	Billable Amount BILL_EDIT_DETL (A)	Over Ceiling Allocation Amount (B)	Retainage Allocation Amount (C)	Adjusted Billable Amount (A, B, C)
USN0418	USN0418.01.01	05000-010	EN	14,000.00	0.00	140.00	13,860.00
USN0418	USN0418.01.02	05000-020	AD	18,000.00	0.00	180.00	17,820.00
USN0418	USN0418.02.01	05030		25,000.00	45.83	0.00	24,954.17
USN0418	USN0418.02.02	05040		5,000.00	9.17	0.00	4,990.83
USN0418	USN0418	01200-010		10,750.00	0.00	0.00	10,750.00
USN0418	USN0418.04.01	05000-010	AD	3,500.00	0.00	35.00	3,465.00
USN0418	USN0418.04.02	05000-010	EN	1,250.00	0.00	12.50	1,237.50
USN0418	USN0418.04.03	05030		5,000.00	0.00		5,000.00

(A) SELECT ACCT_ID, SUM(MU_BILL_AMT + MU_SALES_TAX_AMT - MU_DISC_AMT) FROM BILL_EDIT_DETL WHERE INVC_PROJ_ID = USN0418 AND ACCT_ID IS NOT NULL GROUP BY ACCT_ID;

(B) Redistributed amount from Table 3.

The billable amounts have been calculated by account, item, project labor category combination.

Next, verify the Calculation Method.

Using FIFO Methodology

Requirement: If there is more than one ACRN within a contract line item, the payment office makes payment in sequential ACRN order within the line item, exhausting all funds in the previous ACRN before paying from the next ACRN.

Using the FIFO method, the ACRN value is compared to each Line Item/Subline Item to determine which ACRN funds to exhaust first. Line Item 0001/ACRN AA is exhausted before using funds from Line Item 0001/ACRN AB. You are responsible for assigning the correct Sequence Number to the ACRN value (that is, you must link Line Item 0001/ACRN AA to sequence number 1 and Line Item 0001/ACRN AB to sequence number 2).

Use the account mapping table (PROJ_ACRN_ACCT), project labor category mapping table (PROJ_ACRN_PLC), and BILL_EDIT_DETL to summarize the like accounts/PLCs to the associated ACRN/Line Item combinations by transaction project number:

Project Level At and Below	Accounts	PLC	ACRN	SLIN/Line Item
USN0418.01.01		EN	AA AA	0001AA 0001AB
USN0418.01.02		AD	AA	0003AA
USN0418.02.01	05030		AB AB	0002AA 0002AB
USN0418.02.02	05040		AB	0003AB
USN0418.03	01200-010		AC	0004AA
USN0418.04	%		AD	0005AA

Note: The USN0418.04 line doesn’t have any accounts or project labor categories mapped in PROJ_ACRN_ACCT or PROJ_ACRN_PLC. When no accounts or project labor categories are mapped for a sequence number, ALL amounts from BILL_EDIT_DETL , for that transaction level and below, are used to compute the allocation amount(s)

Determine the ACRN Linked to smallest ACRN/Line Item Sequence Number value.

Sequence Number 1 exists (SEQ_NO = 1) for ACRN/Line Item AA/0001AA.

Verify the PROJ_ACRN_DETL.ACTIVE_FL value for the Sequence Number. If the PROJ_ACRN_DETL.ACTIVE_FL = Y, continue calculation. If PROJ_ACRN_DETL.ACTIVE_FL = N, end calculation and look for next sequence number.

The PROJ_ACRN_DETL.ACTIVE_FL = Y for SEQ_NO = 1. Continue calculation.

Determine the transaction project level(s) to be used in the calculation. Wildcard the TRN_PROJ_ID value.

The TRN_PROJ_ID value for SEQ_NO = USN0418.01.01. Look for any TRN_PROJ_ID values in BILL_EDIT_DETL that begins with USN0418.01.01 (LIKE ‘USN0418.01.01%’).

Go to PROJ_ACRN_PLC to determine if any rows exist.

Yes. Match any BILL_LAB_CAT_CD values from BILL_EDIT_DETL to PROJ_ACRN_PLC. Continue calculation.
No. Go to PROJ_ACRN_ACCT to determine if any rows exist.
Yes, match any ACCT_ID values from BILL_EDIT_DETL to PROJ_ACRN_ACCT. Reminder: Summary account may be entered into the PROJ_ACRN_ACCT table. Continue calculation.
No, ALL accounts from BILL_EDIT_DETL are used to allocate costs.

The PROJ_ACRN_PLC table has a row for SEQ_NO = 1.

Match any BILL_LAB_CAT_CD values from Table 4 to the PROJ_ACRN_PLC table.

The EN BILL_LAB_CAT_CD value is a match.

Use the Adjusted Billable Amount from Table 4, Adjusted Billable Amount Calculation, for Project USN0418.01.01 for ACRN AA/0001AA:

TRN_PROJ_ID	BILL_LAB_CAT_CD	Adjusted Billable Amount
USN0418.01.01	EN	13,860.00

Go to PROJ_ACRN_DETL.APPLY_RESIDUAL_FL (Include Schedule Bill field) to check the value.

APPLY_RESIDUAL_FL = Y.
Go to BILL_EDIT_DETL to see if any rows exist for the INVC_PROJ_ID for S_TRN_TYPE = SCH with a MU_BILL_AMT <> 0.
Yes. Add the BILL_AMT for the Schedule Bill to the Adjusted Billable amount for the sequence number.
N. Go to next step.
APPLY_RESIDUAL_FL = N. Go to next step.

The PROJ_ACRN_DETL.APPLY_RESIDUAL_FL = N for the sequence number. Continue allocation.

	Amount
Billable Amount for ACRN AA/00001AA:	13,860.00
Subtract any allocation amounts with an ACRN Sequence Number < 1 that contains the same mapping values: None exists.	- 0.00
Amount Remaining to be Allocated for ACRN AA/00001AA:	13,860.00

Determine the available ACRN AA/00001AA remaining allocation value balance.

This amount is calculated by the following formula:

PROJ_ACRN_DETL.ACRN_FUNDED_AMT - PROJ_ACRN_DETL.ACRN_BILLED_AMT

Remaining ACRN Allocation Value amount for ACRN AA/00001AA: 7,000.00

Allocate the smaller of the Remaining ACRN Allocation Value or Amount Remaining to be Allocated.

The Project USN0418 Amount Remaining to be Allocated, 13,860.00, is greater than the Remaining ACRN Allocation Value of 7,000.00 for ACRN AA; so Costpoint allocates 7,000.00 to ACRN AA/00001AA for Project USN0418.

Check for the existence of an ACRN Sequence Number > 1. Sequence Numbers 2 through 8 exist. Use the smallest ACRN Sequence Number remaining for the next step of the calculation.

AA/0001AB is the 2nd ACRN Sequence Number. SEQ_NO = 2.

Verify the PROJ_ACRN_DETL.ACTIVE_FL value for the Sequence Number. If the PROJ_ACRN_DETL.ACTIVE_FL = Y, continue calculation. If PROJ_ACRN_DETL.ACTIVE_FL = N, end calculation.

The PROJ_ACRN_DETL.ACTIVE_FL = Y for SEQ_NO = 2. Continue calculation.

Determine the transaction project level(s) to be used in the calculation. Wildcard the TRN_PROJ_ID value.

The TRN_PROJ_ID value for SEQ_NO = USN0418.01.01. Look for any TRN_PROJ_ID values in BILL_EDIT_DETL that begins with USN0418.01.01 (for example, USN0418.01.01%).

Go to PROJ_ACRN_PLC to determine whether any rows exist.

Yes. Match any BILL_LAB_CAT_CD values from BILL_EDIT_DETL to PROJ_ACRN_PLC. Continue calculation.
No. Go to PROJ_ACRN_ACCT to determine whether any rows exist.
Yes. Match any ACCT_ID values from BILL_EDIT_DETL to PROJ_ACRN_ACCT. Reminder: Summary account may be entered into the PROJ_ACRN_ACCT table. Continue calculation.
No. No calculation is performed for this sequence number. Check for the next sequence number.

The PROJ_ACRN_PLC table does not have any rows for SEQ_NO = 2.

Check PROJ_ACRN_ACCT. PROJ_ACRN_ACCT does have a row for SEQ_NO = 2.

Match any ACCT_ID values from Table 4 to the PROJ_ACRN_ACCT table.

The EN BILL_LAB_CAT_CD value is a match.

Use the Adjusted Billable Amount from Table 4, Adjusted Billable Amount Calculation, for Project USN0418.01.01 for ACRN AA/0001AB:

TRN_PROJ_ID	BILL_LAB_CAT_CD	Adjusted Billable Amount
USN0418.01.01	EN	13,860.00

Go to PROJ_ACRN_DETL.APPLY_RESIDUAL_FL (Include Schedule Bill field) to check the value.

APPLY_RESIDUAL_FL = Y.
Go to BILL_EDIT_DETL to see if any rows exist for the INVC_PROJ_ID for S_TRN_TYPE = SCH with a MU_BILL_AMT <> 0.
Yes. Add the BILL_AMT for the Schedule Bill to the Adjusted Billable amount for the sequence number.
No. Go to next step.
APPLY_RESIDUAL_FL = N. Go to next step.

The PROJ_ACRN_DETL.APPLY_RESIDUAL_FL = N for the sequence number. Continue allocation.

	Amount
Billable Amount forAA/0001AB :	13,860.00
Subtract any allocation amounts with an ACRN Sequence Number < 2 that contains the same mapping values: ACRN AA/0001AA exists.	- 7,000.000
Amount Remaining to be Allocated for AA/0001AB:	6,860.00

Determine the available ACRN AA/0001AB remaining allocation value balance. This amount is calculated by using the following formula:

PROJ_ACRN_DETL.ACRN_FUNDED_AMT - PROJ_ACRN_DETL.ACRN_BILLED_AMT

Remaining ACRN Allocation Value amount for ACRN AA/0001AB: 11,000.00

Allocate the smaller of the Remaining ACRN Allocation Value or Amount Remaining to be Allocated.

The Project USN0418.01.01 Amount Remaining to be Allocated, 6,860.00, is less than the Remaining ACRN Allocation Value of 11,000.00 for ACRN AA/0001AB; allocate 6,860.00 to AA/0001AB for Project USN0418.01.01.

Check for the existence of an ACRN Sequence Number > 2. Sequence Number 3 exists. Use the smallest ACRN Sequence Number remaining for the next step of the calculation.

ACRN AA/0003AA is the 3rd ACRN sequence number. SEQ_NO = 3.

Verify the PROJ_ACRN_DETL.ACTIVE_FL value for the Sequence Number. If the PROJ_ACRN_DETL.ACTIVE_FL = Y, continue calculation. If PROJ_ACRN_DETL.ACTIVE_FL = N, end calculation.

The PROJ_ACRN_DETL.ACTIVE_FL = Y for SEQ_NO = 3. Continue calculation.

Determine the transaction project level(s) to be used in the calculation. Wildcard the TRN_PROJ_ID value.

The TRN_PROJ_ID value for SEQ_NO = USN0418.01.02. Look for any TRN_PROJ_ID values in BILL_EDIT_DETL that begins with USN0418.01.02 (for example, USN0418.01.02%).

Go to PROJ_ACRN_PLC to determine whether any rows exist.

Yes. Match any BILL_LAB_CAT_CD values from BILL_EDIT_DETL to PROJ_ACRN_PLC. Continue calculation.
No. Go to PROJ_ACRN_ACCT to determine whether any rows exist.
Yes. Match any ACCT_ID values from BILL_EDIT_DETL to PROJ_ACRN_ACCT. Reminder: Summary account may be entered into the PROJ_ACRN_ACCT table. Continue calculation.
No. ALL accounts from BILL_EDIT_DETL are used to allocate costs.

The PROJ_ACRN_PLC table does not have any rows for SEQ_NO = 3.

Check PROJ_ACRN_ACCT. PROJ_ACRN_ACCT does have a row for SEQ_NO = 3.

Match any ACCT_ID values from Table 4 to the PROJ_ACRN_ACCT table.

The AD BILL_LAB_CAT_CD value is a match.

Use the Adjusted Billable Amount from Table 4, Adjusted Billable Amount Calculation, for Project USN0418.01.02 for ACRN AA/0003AA:

TRN_PROJ_ID	BILL_LAB_CAT_CD	Adjusted Billable Amount
USN0418.01.02	AD	17,820.00

Go to PROJ_ACRN_DETL.APPLY_RESIDUAL_FL (Include Schedule Bill field) to check the value.

APPLY_RESIDUAL_FL = Y.
Go to BILL_EDIT_DETL to see if any rows exist for the INVC_PROJ_ID for S_TRN_TYPE = SCH with a MU_BILL_AMT <> 0.
Yes. Add the BILL_AMT for the Schedule Bill to the Adjusted Billable amount for the sequence number.
No. Go to next step.
APPLY_RESIDUAL_FL = N. Go to next step.

The PROJ_ACRN_DETL.APPLY_RESIDUAL_FL = N for the sequence number. Continue allocation.

	Amount
Billable Amount for ACRN AA/0003AA:	17,820.00
Subtract any allocation amounts with an ACRN Sequence Number < 3 that contains the same mapping values: None exists.	- 0.00
Amount Remaining to be Allocated for ACRN AA/0003AA:	17,820.00

Determine the available ACRN AA/0003AA remaining allocation value balance.

This amount is calculated using the following formula:

PROJ_ACRN_DETL.ACRN_FUNDED_AMT - PROJ_ACRN_DETL.ACRN_BILLED_AMT

Remaining ACRN Allocation Value amount for ACRN AA/0003AA: 20,000.00

Allocate the smaller of the Remaining ACRN Allocation Value or Amount Remaining to be Allocated.

The Project USN0418.01.02 Amount Remaining to be Allocated, 17,820.00, is less than the Remaining ACRN Allocation Value of 20,000.00 for ACRN AA/0003AA; allocate 17,820.00 to ACRN AA/0003AA for Project USN0418.01.02.

Check for the existence of an ACRN Sequence Number > 3. Sequence Numbers 4 through 8 exists. Use the smallest ACRN Sequence Number remaining for the next step of the calculation.

ACRN AB/0002AA is the 4th ACRN sequence number. SEQ_NO = 4.

The PROJ_ACRN_DETL.ACTIVE_FL = Y for SEQ_NO = 4. Continue calculation.

Determine the transaction project level(s) to be used in the calculation. Wildcard the TRN_PROJ_ID value.

The TRN_PROJ_ID value for SEQ_NO = USN0418.02.01. Look for any TRN_PROJ_ID values in BILL_EDIT_DETL that begins with USN0418.02.01 (for example, USN0418.02.01%).

Go to PROJ_ACRN_PLC to determine whether any rows exist.

Yes. Match any BILL_LAB_CAT_CD values from BILL_EDIT_DETL to PROJ_ACRN_PLC. Continue calculation.
No. Go to PROJ_ACRN_ACCT to determine whether any rows exist.
Yes. Match any ACCT_ID values from BILL_EDIT_DETL to PROJ_ACRN_ACCT. Reminder: Summary account may be entered into the PROJ_ACRN_ACCT table. Continue calculation.
No. ALL accounts from BILL_EDIT_DETL are used to allocate costs.

The PROJ_ACRN_PLC table has rows for SEQ_NO = 4.

Match any BILL_LAB_CAT_CD values from Table 4 to the PROJ_ACRN_PLC table.

Account 05030 matches.

Use the Adjusted Billable Amount from Table 4, Adjusted Billable Amount Calculation, for Project USN0418.02.01 for ACRN AB/0002AA:

TRN_PROJ_ID	ACCT_ID	Adjusted Billable Amount
USN0418.02.01	05030	24,954.17

Go to PROJ_ACRN_DETL.APPLY_RESIDUAL_FL (Include Schedule Bill field) to check the value.

APPLY_RESIDUAL_FL = Y.
Go to BILL_EDIT_DETL to see if any rows exist for the INVC_PROJ_ID for S_TRN_TYPE = SCH with a MU_BILL_AMT <> 0.
Yes. Add the BILL_AMT for the Schedule Bill to the Adjusted Billable amount for the sequence number.
No. Go to next step.
APPLY_RESIDUAL_FL = N. Go to next step.

The PROJ_ACRN_DETL.APPLY_RESIDUAL_FL = N for the sequence number. Continue allocation.

	Amount
Billable Amount for ACRN AB/0002AA:	24,954.17
Subtract any allocation amounts with an ACRN Sequence Number < 4 that contains the same mapping values: None exists.	- 0.00
Amount Remaining to be Allocated for ACRN AB/0002AA:	24,954.17

Determine the available ACRN AB/0002AA remaining allocation value balance.

This amount is calculated by using the following formula:

PROJ_ACRN_DETL.ACRN_FUNDED_AMT - PROJ_ACRN_DETL.ACRN_BILLED_AMT

Remaining ACRN Allocation Value amount for ACRN AB/0002AA: 12,000.00

Allocate the smaller of the Remaining ACRN Allocation Value or Amount Remaining to be Allocated.

The Project USN0418.02.01 Amount Remaining to be Allocated, 24,954.17, is greater than the Remaining ACRN Allocation Value of 12,000.00 for ACRN AB/0002AA; allocate 12,000.00 to ACRN AB/0002AA for Project USN0418.02.01.

Check for the existence of an ACRN Sequence Number > 4. Sequence Numbers 5 through 8 exists. Use the smallest ACRN Sequence Number remaining for the next step of the calculation.

ACRN AB/0002AB is the 5th ACRN sequence number. SEQ_NO = 5.

The PROJ_ACRN_DETL.ACTIVE_FL = Y for SEQ_NO = 5. Continue calculation.

Determine the transaction project level(s) to be used in the calculation. Wildcard the TRN_PROJ_ID value.

The TRN_PROJ_ID value for SEQ_NO = USN0418.02.01. Look for any TRN_PROJ_ID values in BILL_EDIT_DETL that begin with USN0418.02.01 (such as USN0418.02.01%).

Go to PROJ_ACRN_PLC to determine whether any rows exist.

Yes. Match any BILL_LAB_CAT_CD values from BILL_EDIT_DETL to PROJ_ACRN_PLC. Continue calculation.
No. Go to PROJ_ACRN_ACCT to determine whether any rows exist.
Yes. Match any ACCT_ID values from BILL_EDIT_DETL to PROJ_ACRN_ACCT. Reminder: Summary account may be entered into the PROJ_ACRN_ACCT table. Continue calculation.
No. ALL accounts from BILL_EDIT_DETL are used to allocate costs.

The PROJ_ACRN_PLC table does not have any rows for SEQ_NO = 5.

Check PROJ_ACRN_ACCT. PROJ_ACRN_ACCT does have a row for SEQ_NO = 5.

Match any ACCT_ID values from Table 4 to the PROJ_ACRN_ACCT table.

Account 05030 matches.

Use the Adjusted Billable Amount from Table 4, Adjusted Billable Amount Calculation, for Project USN0418.02.01 for ACRN AB/0002AB:

TRN_PROJ_ID	ACCT_ID	Adjusted Billable Amount
USN0418.02.01	05030	24,954.17

Go to PROJ_ACRN_DETL.APPLY_RESIDUAL_FL (Include Schedule Bill field) to check the value.

APPLY_RESIDUAL_FL = Y.
Go to BILL_EDIT_DETL to see if any rows exist for the INVC_PROJ_ID for S_TRN_TYPE = SCH with a MU_BILL_AMT <> 0.
Yes. Add the BILL_AMT for the Schedule Bill to the Adjusted Billable amount for the sequence number.
No. Go to next step.
APPLY_RESIDUAL_FL = N. Go to next step.

The PROJ_ACRN_DETL.APPLY_RESIDUAL_FL = N for the sequence number. Continue allocation.

	Amount
Billable Amount for ACRN AB/0002AB:	24,954.17
Subtract any allocation amounts with an ACRN Sequence Number < 5 that contains the same mapping values: ACRN AB/0002AA exists	- 12,000.00
Amount Remaining to be Allocated for ACRN AB/0002AB:	12,954.17

Determine the available ACRN AB/0002AB remaining allocation value balance.

This amount is calculated by using the following formula:

PROJ_ACRN_DETL.ACRN_FUNDED_AMT - PROJ_ACRN_DETL.ACRN_BILLED_AMT

Remaining ACRN Allocation Value amount for ACRN AB/0002AB: 14,000.00

Allocate the smaller of the Remaining ACRN Allocation Value or Amount Remaining to be Allocated.

The Project USN0418.02.01 Amount Remaining to be Allocated, 12,954.17, is less than the Remaining ACRN Allocation Value of 14,000.00 for ACRN AB/0002AB; allocate 12,954.17 to ACRN AB/0002AB for Project USN0418.02.01.

Check for the existence of an ACRN Sequence Number > 5. Sequence Numbers 6 through 8 exist. Use the smallest ACRN Sequence Number remaining for the next step of the calculation.

ACRN AB/0003AB is the 6th ACRN sequence number. SEQ_NO = 6.

The PROJ_ACRN_DETL.ACTIVE_FL = Y for SEQ_NO = 6. Continue calculation.

Determine the transaction project level(s) to be used in the calculation. Wildcard the TRN_PROJ_ID value.

The TRN_PROJ_ID value for SEQ_NO = USN0418.02.02. Look for any TRN_PROJ_ID values in BILL_EDIT_DETL that begins with USN0418.02.02 (for example, USN0418.02.02%).

Go to PROJ_ACRN_PLC to determine whether any rows exist.

Yes. Match any BILL_LAB_CAT_CD values from BILL_EDIT_DETL to PROJ_ACRN_PLC. Continue calculation.
No. Go to PROJ_ACRN_ACCT to determine whether any rows exist.
Yes. Match any ACCT_ID values from BILL_EDIT_DETL to PROJ_ACRN_ACCT. Reminder: Summary account may be entered into the PROJ_ACRN_ACCT table. Continue calculation.
No. ALL accounts from BILL_EDIT_DETL are used to allocate costs.

The PROJ_ACRN_PLC table does not have any rows for SEQ_NO = 6.

Check PROJ_ACRN_ACCT. PROJ_ACRN_ACCT does have a row for SEQ_NO = 6.

Match any ACCT_ID values from Table 4 to the PROJ_ACRN_ACCT table.

Account 05040 matches.

Use the Adjusted Billable Amount from Table 4, Adjusted Billable Amount Calculation, for Project USN0418.02.02 for ACRN AB/0002AB:

TRN_PROJ_ID	ACCT_ID	Adjusted Billable Amount
USN0418.02.02	05040	4,990.83

Go to PROJ_ACRN_DETL.APPLY_RESIDUAL_FL (Include Schedule Bill field) to check the value.

APPLY_RESIDUAL_FL = Y.
Go to BILL_EDIT_DETL to see if any rows exist for the INVC_PROJ_ID for S_TRN_TYPE = SCH with a MU_BILL_AMT <> 0.
Yes. Add the BILL_AMT for the Schedule Bill to the Adjusted Billable amount for the sequence number.
No. Go to next step.
APPLY_RESIDUAL_FL = N. Go to next step.

The PROJ_ACRN_DETL.APPLY_RESIDUAL_FL = N for the sequence number. Continue allocation.

	Amount
Billable Amount forACRN AB/0003AB:	4,990.83
Subtract any allocation amounts with an ACRN Sequence Number < 6 that contains the same mapping values: None exists	-0.00
Amount Remaining to be Allocated for ACRN AB/0003AB:	4,990.83

Determine the available ACRN AB/0003AB remaining allocation value balance.

This amount is calculated by using the following formula:

PROJ_ACRN_DETL.ACRN_FUNDED_AMT - PROJ_ACRN_DETL.ACRN_BILLED_AMT

Remaining ACRN Allocation Value amount for ACRN AB/0003AB: 15,000.00

Allocate the smaller of the Remaining ACRN Allocation Value or Amount Remaining to be Allocated.

The Project USN0418.02.02 Amount Remaining to be Allocated, 4,990.83, is less than the Remaining ACRN Allocation Value of 15,000.00 for ACRN AB/0003AB; allocate 4,990.83 to ACRN AB/0003AB for Project USN0418.02.02.

Check for the existence of an ACRN Sequence Number > 6. Sequence Numbers 7 and 8 exist. Use the smallest ACRN Sequence Number remaining for the next step of the calculation.

ACRN AC/0004AA is the 7th ACRN sequence number. SEQ_NO = 7.

The PROJ_ACRN_DETL.ACTIVE_FL = Y for SEQ_NO = 7. Continue calculation.

Determine the transaction project level(s) to be used in the calculation. Wildcard the TRN_PROJ_ID value.

The TRN_PROJ_ID value for SEQ_NO = USN0418.03. Look for any TRN_PROJ_ID values in BILL_EDIT_DETL that begins with USN0418.03 (LIKE ‘USN0418.03%’).

Go to PROJ_ACRN_PLC to determine whether any rows exist.

Yes. Match any BILL_LAB_CAT_CD values from BILL_EDIT_DETL to PROJ_ACRN_PLC. Continue calculation.
No. Go to PROJ_ACRN_ACCT to determine whether any rows exist.
Yes. Match any ACCT_ID values from BILL_EDIT_DETL to PROJ_ACRN_ACCT. Reminder: Summary account may be entered into the PROJ_ACRN_ACCT table. Continue calculation.
No. ALL accounts from BILL_EDIT_DETL are used to allocate costs.

The PROJ_ACRN_PLC table does not have any rows for SEQ_NO = 7.

Check PROJ_ACRN_ACCT. PROJ_ACRN_ACCT does not have any rows for SEQ_NO = 7.

If there are no rows in PROJ_ACRN_PLC or PROJ_ACRN_ACCT, ALL rows from Table 4 for the TRN_PROJ_ID (USN0418.03%) are used to calculate the allocation amount(s).

There are no Adjusted Billable Amounts from Table 4, Adjusted Billable Amount Calculation, for Project USN0418.03:

Go to PROJ_ACRN_DETL.APPLY_RESIDUAL_FL (Include Schedule Bill field) to check the value.

APPLY_RESIDUAL_FL = Y.
Go to BILL_EDIT_DETL to see if any rows exist for the INVC_PROJ_ID for S_TRN_TYPE = SCH with a MU_BILL_AMT <> 0.
Yes. Add the BILL_AMT for the Schedule Bill to the Adjusted Billable amount for the sequence number.
No. Go to next step.
APPLY_RESIDUAL_FL = N. Go to next step.

The PROJ_ACRN_DETL.APPLY_RESIDUAL_FL = Y for the sequence number. Continue allocation.

Combine the Adjusted Billable Amount from Table 4, plus the BILL_AMT from BILL_EDIT_DETL for the S_TRN_TYPE = SCH rows. When looking for the S_TRN_TYPE = SCH rows, ignore the TRN_PROJ_ID value. INVC_PROJ_ID is used because the Schedule Bill records are computed at the invoice level project.

ACCT_ID	BILL_LAB_CAT_CD	Adjusted Billable Amount	Schedule Bill Amount	Revised Adjusted Billable Amount
		0.00	10,750.00	10,750.00

	Amount
Billable Amount for ACRN AC/0004AA:	10,750.00
Subtract any allocation amounts with an ACRN Sequence Number < 7 that contains the same mapping values: None exists	-0.00
Amount Remaining to be Allocated for ACRN AC/0004AA:	10,750.00

Determine the available ACRN AC/0004AA remaining allocation value balance.

This amount is calculated by using the following formula:

PROJ_ACRN_DETL.ACRN_FUNDED_AMT - PROJ_ACRN_DETL.ACRN_BILLED_AMT

Remaining ACRN Allocation Value amount for ACRN AC/0004AA: 80,000.00

Allocate the smaller of the Remaining ACRN Allocation Value or Amount Remaining to be Allocated.

The Project USN0418.03 Amount Remaining to be Allocated, 10,750.00, is less than the Remaining ACRN Allocation Value of 80,000.00 for ACRN AC/0004AA; allocate 10,750.00 to ACRN AC/0004AA for Project USN0418.03.

Check for the existence of an ACRN Sequence Number > 7. Sequence Number 8 exists. Use the smallest ACRN Sequence Number remaining for the next step of the calculation.

ACRN AD/0005AA is the 8th ACRN sequence number. SEQ_NO = 8.

The PROJ_ACRN_DETL.ACTIVE_FL = Y for SEQ_NO = 8. Continue calculation.

Determine the transaction project level(s) to be used in the calculation. Wildcard the TRN_PROJ_ID value.

The TRN_PROJ_ID value for SEQ_NO = USN0418.04. Look for any TRN_PROJ_ID values in BILL_EDIT_DETL that begins with USN0418.04 (for example, USN0418.04%).

Go to PROJ_ACRN_PLC to determine whether any rows exist.

Yes. Match any BILL_LAB_CAT_CD values from BILL_EDIT_DETL to PROJ_ACRN_PLC. Continue calculation.
No. Go to PROJ_ACRN_ACCT to determine whether any rows exist.
Yes. Match any ACCT_ID values from BILL_EDIT_DETL to PROJ_ACRN_ACCT. Reminder: Summary account may be entered into the PROJ_ACRN_ACCT table. Continue calculation.
No. ALL accounts from BILL_EDIT_DETL are used to allocate costs.

The PROJ_ACRN_PLC table does not have any rows for SEQ_NO = 8.

Check PROJ_ACRN_ACCT. PROJ_ACRN_ACCT does not have any rows for SEQ_NO = 8.

If there are no rows in PROJ_ACRN_PLC or PROJ_ACRN_ACCT, ALL rows from BILL_EDIT_DETL for the TRN_PROJ_ID (USN0418.04%) are used to calculate the allocation amount(s).

Use the Adjusted Billable Amount from Table 4, Adjusted Billable Amount Calculation, for Project USN0418.04 for ACRN AD/0005AA:

TRN_PROJ_ID	ACCT_ID	Adjusted Billable Amount
USN0418.04.01	05000-010	3,465.00
USN0418.04.02	05000-010	1,237.50
USN0418.04.03	05030	5,000.00
TOTAL		9,702.50

Go to PROJ_ACRN_DETL.APPLY_RESIDUAL_FL (Include Schedule Bill field) to check the value.

APPLY_RESIDUAL_FL = Y.
Go to BILL_EDIT_DETL to see if any rows exist for the INVC_PROJ_ID for S_TRN_TYPE = SCH with a MU_BILL_AMT <> 0.
Yes. Add the BILL_AMT for the Schedule Bill to the Adjusted Billable amount for the sequence number.
No. Go to next step.
APPLY_RESIDUAL_FL = N. Go to next step.

The PROJ_ACRN_DETL.APPLY_RESIDUAL_FL = N for the sequence number. Continue allocation.

	Amount
Billable Amount for ACRN AD/0005AA :	9,702.50
Subtract any allocation amounts with an ACRN Sequence Number < 8 that contains the same mapping values: None exists	-0.00
Amount Remaining to be Allocated for ACRN AD/0005AA:	9,702.50

Determine the available ACRN AD/0005AA remaining allocation value balance.

This amount is calculated by using the following formula:

PROJ_ACRN_DETL.ACRN_FUNDED_AMT - PROJ_ACRN_DETL.ACRN_BILLED_AMT

Remaining ACRN Allocation Value amount for ACRN AD/0005AA: 25,000.00

Allocate the smaller of the Remaining ACRN Allocation Value or Amount Remaining to be Allocated.

The Project USN0418.04 Amount Remaining to be Allocated, 9,702.50, is less than the Remaining ACRN Allocation Value of 25,000.00 for ACRN AD/0005AA; allocate 9,702.50 to ACRN AD/0005AA for Project USN0418.04.

Check for the existence of an ACRN Sequence Number > 8. None exists. Calculation ends.

Summary of ACRN Allocation Amounts:

ACRN	SLIN/Line Item	Allocation Amount
AA	0001AA	7,000.00
AA	0001AB	6,860.00
AA	0003AA	17,820.00
AB	0002AA	12,000.00
AB	0002AB	12,954.17
AB	0003AB	4,990.83
AC	0004AA	10,750.00
AD	0005AA	9,702.50
Total Allocation:		82,077.50

Upon completion of the calculation, the following amounts are updated in the PROJ_BILL_ACRN and PROJ_ACRN_DETL tables:

Table	Field	PROJ_BILL_ACRN Amount	PROJ_ACRN_DETL ACRN	PROJ_ACRN_DETL Line Item	PROJ_ACRN_DETL Amount
PROJ_BILL_ACRN	ACRN_INVC_AMT	82,077.50
PROJ_BILL_ACRN	ACRN_ALLOC_AMT	82,077.50
PROJ_ACRN_DETL	ACRN_CUR_ALLOC_AMT		AA	0001AA	7,000.00
			AA	0001AB	6,860.00
			AA	0003AA	17,820.00
			AB	0002AA	12,000.00
			AB	0002AB	12,954.17
			AB	0003AB	4,990.83
			AC	0004AA	10,750.00
			AD	0005AA	9,720.50
PROJ_ACRN_DETL	ACRN_TOT_ALLOC_AMT		AA	0001AA	7,000.00
			AA	0001AB	6,860.00
			AA	0003AA	17,820.00
			AB	0002AA	12,000.00
			AB	0002AB	12,954.17
			AB	0003AB	4,990.83
			AC	0004AA	10,750.00
			AD	0005AA	9,720.50
PROJ_ACRN_DETL	AVAIL_ACRN_AMT		AA	0001AA	0.00
			AA	0001AB	4,140.00
			AA	0003AA	2,180.00
			AB	0002AA	0.00
			AB	0002AB	1,045.83
			AB	0003AB	10,009.17
			AC	0004AA	69,250.00
			AD	0005AA	15,297.50

Costpoint Online Help

Billing Requirement Includes Mapping and PROJ_MAP_FL is Y - FIFO

Using FIFO Methodology