Resolution:
The following is a list of the available billing formulas and their calculation:
Cost Incurred Plus Fee On Cost (CPFC): This is a transaction (TRN)-based formula that summarizes the costs incurred by a project and applies burden and fee to those costs. When you calculate bills, the system uses the transactions in the Open Billing Detail (OBD) table to calculate the invoice. The system calculates the burden using the provisional rates in the Pool Rates subtask of the Cost Pools screen (Projects > Cost and Revenue Processing > Cost Pool Setup). The fee is calculated by applying the fee percent entered in this screen to the total of the costs and burden.
Cost Incurred Plus Fee On Hours: This is a transaction-based formula that summarizes the costs incurred by a project and applies burden and fee to those costs. When you calculate bills, the system uses the transactions in the Open Billing Detail table to calculate the invoice. The burden will be calculated using the provisional rates in the Pool Rates subtask of the Cost Pools screen (Projects > Cost and Revenue Processing > Cost Pool Setup). The system calculates the fee by summarizing the hours incurred in the Open Billing Detail screen and applying the fee per hour entered in this screen.
Enter Bill Manually: Use this formula if you will be using the Edit Project Product Bills, Edit Manual Bills, or Edit Milestone/Percent Complete Bills screens (all in Projects > Billing > Edit Billings) to enter your billings. You must set up a record in this screen so that the system will recognize the project as billable. The system cannot calculate the invoice automatically if you use this formula. If you need to use the Pay When Paid functionality, you should select the Manual Bills with Unbilled Detail formula.
Loaded Labor Rate (LLR) W/Fee Plus Non-Labor W/Burden W/Fee: Use this formula to bill hours incurred times a billable rate with a fee on that amount plus non-labor costs and fee on non-labor costs. This is a transaction-based formula. The hours incurred, associated billing rates, and non-labor costs are taken from the Open Billing Detail table. You can set up billing rates in the Project Labor menu in Costpoint Project Setup. You must run the Load Labor Rates screen (Projects > Cost and Revenue Processing > Revenue Processing or Projects > Billing > Prepare Billings) before the bill will calculate properly. The fee percents will be taken from the Labor Fee Percent and Non-Labor Fee Percent fields in this screen. (These fields will appear below the Formula drop-down list when you select this billing formula.)
Labor Cost Times Multiplier Plus Non-Labor Times Multiplier (Cost): Use this formula to bill costs incurred times a multiplier. This is a transaction-based formula. The Labor and Non-labor cost amounts (CA) will be taken from the Open Billing Detail table. The cost amounts will be multiplied times the Labor Multiplier and Non-Labor Multiplier entered in this screen. (These fields will appear below the Formula drop-down list when you select this billing formula.)
Labor Cost times Multiplier Plus Non-Labor times Multiplier (Hours): Use this formula to have a multiplier-based billing computed at actual labor rates. This is a transaction-based billing. It is different from the Labor Cost Times Multiplier Plus Non-Labor Times Multiplier (Cost) formula because it computes using actual hourly rates. Costpoint will calculate the actual hourly rate by dividing the labor cost by the hours incurred. The system will insert this rate into Open Billing Detail when you run the Load Labor Rates screen (Projects > Cost and Revenue Processing > Revenue Processing or Projects > Billing > Prepare Billings). This rate will then be multiplied times the multiplier in this screen and then by the number of hours in Open Billing Detail. The purpose of this formula is to show a multiplier billing with an hours-based format.
Loaded Labor Plus Non-labor Plus Burden On Non-labor: Use this formula to bill hours incurred times a billable rate and burdened non-labor costs. This is a transaction-based billing. The hours incurred, non-labor costs, and the billing rate will be stored in the Open Billing Detail table. The provisional burden rate will be stored in the Pool Rates subtask of the Cost Pools screen (Projects > Cost and Revenue Processing > Cost Pool Setup).
Loaded Labor Plus Non-labor W/Burden W/Fee: Use this formula to bill hours incurred times a billable rate and burdened non-labor costs with a fixed fee. This is a transaction-based billing. The hours incurred, non-labor costs, and the billing rate will be stored in the Open Billing Detail table. The provisional burden rate will be stored in the Pool Rates subtask of the Cost Pools screen (Projects > Cost and Revenue Processing > Cost Pool Setup). You will enter the fee that will be applied to the non-labor costs in this screen.
Loaded Labor Rate: Use this formula to bill hours incurred times a billable rate. This is a transaction-based billing. The hours incurred and the billing rate will be stored in the Open Billing Detail table. No non-labor costs will be billed and no fee or burden will be applied when you use this formula.
Loaded Labor Rate Plus Cost Incurred On Non-labor Time & Materials (T&M): Use this formula to bill hours incurred times a billable rate and non-labor costs at actual. This is a transaction-based billing. The hours incurred, non-labor costs, and the billing rate used in the calculation will be stored in the Open Billing Detail table. This formula is a standard Time and Materials billing.
Loaded Labor w/Burden w/Fee Plus Non-labor w/Burden W/Fee: Use this formula to bill hours incurred times a billable rate with fee and burden, and non-labor costs with fee and burden. This is a transaction-based billing. The hours incurred, non-labor costs, and the billing rate used in the calculation will be stored in the Open Billing Detail table. The provisional burden rate will be stored in the Pool Rates subtask of the Cost Pools screen (Projects > Cost and Revenue Processing > Cost Pool Setup). You enter the fee used in the calculation in this screen.
Manual Bills with Unbilled Detail: Use this formula if you will be entering bills in the Edit Project Product Bills, Edit Manual Bills, or Edit Milestone/Percent Complete Bills screens (all in Projects > Billing > Edit Billings) but wish to use the Pay When Paid functionality. The Pay When Paid functionality restricts payment to subcontractors or consultants until you have billed your customer and have been paid. The Pay When Paid functionality will not work for fixed-price billings unless you select this formula. If you use this formula, the system populates the Open Billing Detail table when you post transactions. Once the bill is posted, the transactions are moved to a transaction history table where they can be flagged as paid or unpaid. No automatic billing calculations are available with this formula.
Progress Payment: Use this formula to bill using Government (GOVT) Form 1443. If you select this formula, the calculated bill will be in the Edit Progress Payment Billings screen (Projects > Billing > Edit Billings) and you can print the bill from the Print Progress Payment Bills screen (Projects > Billing > Print Billings). This is a transaction-based bill. It will use data from the Maintain Open Billing Detail screen (Projects > Billing > Prepare Billings). See Billing Special Topic Base Line (BL)-6, Progress Payment Bills, for more information.
Rate Schedule Times Multiplier Plus Non-Labor Cost Times Multiplier: Use this formula to bill hours using a variety of billing rates types. With this formula, you must use Project Labor Categories (PLC) with all labor transactions. This is a transaction-based formula. You can set up each PLC to use rate types of B, A, or C. This formula effectively allows the labor portion of the billing to be calculated according to who or what group of employees is charging it. The Include Labor Multiplier in Billing Rate check box is available with this formula. Select this check box to allow the labor multiplier to be calculated in addition to the billing rate. The non-labor section is always computed using a multiplier.
Unit Price Transactions Only: Use this billing formula to bill only unit transactions. Selecting this formula will prevent transactions that are posted from Accounts Payable, Journal Entries (JE), and Labor Distribution from populating the Open Billing Detail table. If you select this formula, Open Billing Detail will be populated only if you check the Post to Billings check box in the Enter Unit Usage screen (Projects > Billing > Units Usage). See Billing Special Topic BL-5, Units, for more information on billing units. You should also use this formula if you wish to produce only scheduled bills.
Knowledge Base Reference Number: KBA #52928