Contents of the Manage Milestone Percent Complete Bills Screen

Use the fields and options to configure the Manage Milestone Percent Complete Bills screen.

Identification

Field Description
Project

Enter, or click to select, the project being invoiced. The non-editable field to the right displays the project description.

Line Subtotal

This field displays the sum of the Current Amount Due column.

Retainage

This field displays the sum of the total Retainage Amount for this bill.

Miscellaneous Charges

This field displays the sum of the miscellaneous charges from the Misc Charges tab. Note that this field also displays any sales/VAT tax that may have been applied on the Misc Charges tab.

Invoice Amount Due

This field displays the result of adding the Line Subtotal and the Miscellaneous Charges, then subtracting the Retainage.

Unallocated Value

This field displays the result of subtracting the total Scheduled Value column from the total contract value/ceiling for this project. You can enter ceilings, and their value methods, on the Manage Total Ceilings screen. The ceiling can be on either the Contract Value or the Funded Value method. Costpoint uses the lower of the two values if ceilings exist on both values.

Recalculate

Click this button to recalculate all values.

Table Window

Use this table window to enter the lines of the bill. The line numbers are filled in automatically as you add lines to this table. Based on the Retainage code selected, either TOTAL or LINE ITEM, different columns are displayed.

Field Description
Line

This non-editable column displays the line number for the various lines in the table window. Note that a subtotal line is printed on the bill wherever there is a T (Text) line type that follows a D (Detail) line type or a group of Detail lines. A line text type is a line that displays ONLY a description and line number; no other fields are completed for a text line. This subtotal line includes the amounts of all Detail lines since the last subtotal.

This column displays for both Retainage code selections, LINE ITEM and TOTAL.

Description

Enter a maximum of 60 alphanumeric characters to describe this billing line. You can enter a line that displays only a description, with no values, by entering in the description and proceeding to the next line. This is helpful for adding text, such as section headings, that further explains the bill.

This column displays for both Retainage code selections, LINE ITEM and TOTAL.

Scheduled Value

Enter the scheduled contract value amount for this billing line. This column displays for both Retainage code selections, LINE ITEM and TOTAL.

Percent Complete

Enter the percent complete value for this billing line. This column displays for both Retainage code selections, LINE ITEM and TOTAL.

Amount Billable

If you entered a value in the Percent Complete field, Costpoint calculates the Amount Billable by multiplying the Scheduled Value by the Percent Complete. If you modify the Amount Billable, the Percent Complete column recomputes to the new percent. Also, you can modify the Amount Billable by changing the Percent Complete field.

This column displays for both Retainage code selections, LINE ITEM and TOTAL.

Retainage Percentage

The retainage percentage for this line displays in this column. This percentage was entered on the Manage Project Billing Information screen. You can modify this number, but any adjustment modifies the Retainage Amount, Current Retainage Due, and Total Amount Due columns.

This column displays for only the Retainage code selection LINE ITEM.

Retainage Amount

The retainage amount for this line displays in this column. This number is the product of the Amount Billable and the Retainage Percentage columns. You can modify this number, but any adjustments modify the Current Retainage Due and Retainage Percentage.

This column will display for only the Retainage code selection LINE ITEM.

Previous Amount Billed

If you have posted a bill for this project, this column displays the amount previously billed. This column is editable. This column displays for both Retainage code selections, LINE ITEM and TOTAL.

Previous Retainage Billed

This column displays any previously billed retainage amounts for this line. This column is editable. This column displays for only the Retainage code selection LINE ITEM.

Current Amount Due

This amount is the result of subtracting the Previous Amount Billed field from the Amount Billable amount. If you modify this value, the Percent Complete and the Amount Billable fields change.

This column displays for both Retainage code selections, LINE ITEM and TOTAL.

Current Retainage Due

This amount is the result of subtracting the Previous Retainage Billed from the Retainage Amount. This column can be modified, but the Retainage Amount and the Retainage Percentage field change.

This column displays for only the Retainage code selection LINE ITEM.

Total Amount Due

This amount is the result of subtracting the Current Retainage Due from the Current Amount Due. This field is not editable.

This column displays for only the Retainage code selection LINE ITEM.

Print

Enter a Y (Yes) to print this billing line or N (No) to suppress it.

This column displays for both Retainage code selections, LINE ITEM and TOTAL.

Type

This column indicates whether the line is a T (Text) line or a D (Detail) line. Text lines contain only information in the Description field. They are used to format and explain the bill. Detail lines contain values in all fields of the billing line. All lines are initially assigned a type of T. If any of the value fields are completed, the line changes to a D when the line is complete.

This column will display for both Retainage code selections, LINE ITEM and TOTAL.

Subtasks

Subtask Description
Exchange Rates Click this link to open the Exchange Rates subtask and review or modify billing transactions that occur in a currency other than your company's functional currency.
Standard Text Click this link to enter standard text codes to be printed at the bottom of milestone/percent complete bills.
Customs Info Click this link to open the Customs Info subtask, where you can view and modify customs information for the selected bill row. Included modifications are destination country, delivery terms, mode of transportation, and supply date.
Currency Line Click this link to access the Currency Line Info subtask, where you can view any selected invoice line in both the billing currency and your company's functional currency. In addition, you can view the exchange rate for the billing currency.