Use this subtask to review and edit the individual transaction lines that comprise each bill line. You cannot change transaction lines unless the Allow User to Edit Bills check box is selected in the Project Billing Info screen (Projects » Billing » Billing Master or Projects » Project Setup » Revenue Setup). Any changes made in this subtask will be reflected in the summary amount of the bill line on the main screen.
This non-editable field defaults from the main screen. The non-editable field to the right displays the description of the invoice-level project.
This non-editable field displays the group description from the main screen.
This non-editable field displays the line from the main screen.
This non-editable field displays the line type from the main screen. There are three different detail formats available to accommodate the three line types: Cost, Hours, and Units. Each line type is documented separately.
The following detail fields are used only by the Cost line type.
This field displays the project to which the transaction was posted.
This field displays the account to which the transaction was posted.
This field displays the organization to which the transaction was posted.
This field displays the pool number that is burdening the transaction. This field is applicable only to bill lines that contain pool costs.
This field describes the type of transaction. Possible types are C (Cost), F (Fee), B (Burden), COM (Cost of Money), R (Retainage), OF (Over Fee Ceiling), OT (Over Total Ceiling), DOL (Labor Discount), or DNL (Non-Labor Discount). Depending on the transaction type, certain other fields on this screen may not contain data.
This field displays the sales tax code for this transaction. You can maintain tax codes in Costpoint System Administration.
This field is the result of multiplying the sales tax percent for the selected sales tax code times the Amt to Bill or Billing Crncy Amt to Bill. You can edit this amount to adjust for rounding amounts in tax calculation in both your company's functional currency and this invoice's billing currency.
This field is the result of multiplying the sales tax percent for the selected sales tax code times the Amt to Bill or Billing Crncy Amt to Bill. You can edit this amount to adjust for rounding amounts in tax calculation in both your company's functional currency and this invoice's billing currency.
This field displays the amount of the transaction that will be billed. This field can be edited.
This field displays the amount, in billing currency, of the transaction that will be billed. This field can be edited.
This field displays, in your functional currency, the amount, of cost of the Amt To Bill that you would like to place on hold and exclude from the bill. Rows that contain burden or fee cannot be held or written-off, but can be edited via the Amt To Bill field. Changing this field will automatically change the Amt To Bill.
The transactions placed on hold will retain that status, and will appear in the Amt on Hold field until they are manually changed in the Maintain Open Billing Detail screen. If a transaction is partially placed on hold and then subsequently billed, note that the transaction will appear more than once on the supporting schedules; once for each portion that has been billed.
This field displays, in the invoice's billing currency, the amount of cost of the Amt To Bill that you would like to place on hold and exclude from the bill. Rows that contain burden or fee cannot be held or written-off, but can be edited via the Amt To Bill field. Changing this field will automatically change the Amt To Bill.
The transactions placed on hold will retain that status, and will appear in the Amt on Hold field until they are manually changed in the Maintain Open Billing Detail screen. If a transaction is partially placed on hold and then subsequently billed, note that the transaction will appear more than once on the supporting schedules; once for each portion that has been billed.
This field displays, in your functional currency, the cost that has been previously placed on hold and that has now been determined to be unbillable at any time. By transferring them from Hold to Write Off, you can ensure that the transactions will not appear on any subsequent bills. Rows that contain burden or fee cannot be held or written off, but can be edited via the Amt To Bill field. Changing this field will automatically change the Amt To Bill.
This field displays, in the invoice's billing currency, the cost that has been previously placed on hold and which has now been determined to be unbillable at any time. By transferring them from Hold to Write Off, you can ensure that the transactions will not appear on any subsequent bills. Rows that contain burden or fee cannot be held or written-off, but can be edited via the Amt To Bill field. Changing this field will automatically change the Amt To Bill.
This field displays the billing history amount for previously billed transactions in your company's functional currency. Previously billed amounts are summarized on a separate line.
This field displays the billing history amount for previously billed transactions in the invoice's billing currency. Previously billed amounts are summarized on a separate line.
This field is not currently used.
This field displays the retainage amount of the bill in your company's functional currency. Retainage amounts cannot be held or written off, but can be edited in this column. Changing the retainage amount will not affect the Amt To Bill.
This field displays the retainage amount of the bill in the invoice's billing currency. Retainage amounts cannot be held or written off, but can be edited in this column. Changing the retainage amount will not affect the Amt To Bill.
This field displays, in your company's functional currency, the amount that caused the total project ceiling to be exceeded. This amount will be excluded from the bill.
This field displays, in the invoice's billing currency, the amount that caused the total project ceiling to be exceeded. This amount will be excluded from the bill.
This field displays, in your company's functional currency, the fee that caused the total fee ceiling to be exceeded. This amount will be excluded from the bill.
This field displays, in the invoice's billing currency, the fee that caused the total fee ceiling to be exceeded. This amount will be excluded from the bill.
This field displays, in your company's functional currency, the cost that caused the total cost ceiling to be exceeded. This amount will be excluded from the bill.
This field displays, in the invoice's billing currency, the cost that caused the total cost ceiling to be exceeded. This amount will be excluded from the bill.
This field displays the discount amount applied to the bill. This amount will be excluded from the bill.
This field displays, in the invoice's billing currency, the discount amount applied to the bill. This amount will be excluded from the bill.
This field describes the source of the transaction. If the transaction is an auditable record, meaning that it was added to Open Billing Detail by a system posting process, the source will be System. If you entered the transaction manually in the Maintain Open Billing Detail screen (Projects » Billing » Prepare Billings), which means it cannot be traced back to the General Ledger, the source will be User.
This field displays the description of the transaction as it was entered.
This field displays the fiscal year to which the transaction was posted.
This field displays the period to which the transaction was posted.
This field displays the subperiod to which the transaction was posted.
This field displays the journal that was used to enter and post the transaction.
This field displays the ID type for labor transactions. The ID type can be Employee, Vendor, Vendor Employee, or None.
This field displays the employee, vendor, or vendor employee ID for those transactions with an ID Type other than None.
This field displays the full employee, vendor, or vendor employee name for the selected ID.
This field displays the voucher number if the transaction was entered in Costpoint Accounts Payable.
This field displays the invoice number if the transaction was entered in Costpoint Accounts Payable.
For transactions with a type of B (Burden), this field displays the applicable pool rate as a real number. For example, an amount of $1.50 for an hours-based pool displays as "1.5000," and a rate of 13% for a cost-based pool displays as "0.130000."
This field displays the journal entry number if the transaction was entered via journal entry.
This field displays the cash receipt number if a cash receipt has been entered.
Use this field to record the reason any amounts have been placed on hold.
Use this field to record the reason any amounts have been written off.
This is the reference number 1 to which the transaction was posted, if applicable.
This is the reference number 2 to which the transaction was posted, if applicable.
The following detail fields are used only by the Hours line type.
This field displays the project to which the transaction was posted.
This field displays the PLC (Project Labor Category) of the transaction.
This field displays the description of the PLC.
This editable field displays the number of hours that will be billed for this transaction.
This editable field displays, in your company's functional currency, the rate that will be multiplied by the Hours To Bill to arrive at the Amount To Bill.
This editable field displays, in your company's functional currency, the rate before discount.
This editable field displays, in the invoice's billing currency, the rate that will be multiplied by the Hours To Bill to arrive at the Amount To Bill.
This editable field displays, in the invoice's billing currency, the rate before discount.
This field displays the rate type for those billing rates that include loaded labor in their formulas. This field displays either A (Actual), B (Billing), C (Ceiling), S (Standard), or None, and is defined under the Labor subtask of the Maintain Open Billing Detail screen (Projects » Billing » Prepare Billings).
This field displays the amount of the transaction that will be billed. This field is the result of multiplying the Hrs To Bill field by the Billing Rate field. You cannot edit this field; you can change this field only by editing one of the two fields used to calculate the Amt To Bill.
This field displays the amount, in billing currency, of the transaction that will be billed. This field is the result of multiplying the Hrs To Bill field by the Billing Currency Billing Rate field. You cannot edit this field; you can change this field only by editing one of the two fields used to calculate the Amt To Bill.
This field displays the amount of hours of the Amt To Bill that you would like to place on hold and exclude from the bill. Changing this field changes the Hrs To Bill, which, in turn, changes the Amt To Bill.
The transactions placed on hold will retain that status, and will appear in the Hrs on Hold field in the Maintain Open Billing Detail screen (Projects » Billing » Prepare Billings) until your manually change them. If a transaction is partially placed on hold and then subsequently billed, note that the transaction will appear more than once on the supporting schedules; once for each portion that has been billed.
This field displays the hours that have been previously placed on hold and that have now been determined to be unbillable at any time. By transferring them from Hold to Write Off, you ensure that the transactions will not appear on any subsequent bills. Rows that contain burden or fee cannot be held or written-off, but can be edited via the Amt To Bill field. Changing this field changes the Hrs To Bill, which, in turn, changes the Amt To Bill.
This non-editable field displays the billing history hours for previously billed transactions. Hours previously billed are summarized on a separate line.
This non-editable field displays, in your company's functional currency, the billing history amount for previously billed transactions. Previously billed amounts are summarized on a separate line.
This non-editable field displays, in the invoice's billing currency, the billing history amount for previously billed transactions. Previously billed amounts are summarized on a separate line.
This field displays the discount amount applied to the bill. This amount will be excluded from the bill.
This field displays, in the invoice's billing currency, the discount amount applied to the bill. This amount will be excluded from the bill.
This field displays the account to which the transaction was posted.
This field displays the organization to which the transaction was posted.
This field is not currently used.
This field displays the source of the transaction. If the transaction is an auditable record, meaning that it was added to Open Billing Detail by a system posting process, the source will be System. If you entered the transaction manually in the Maintain Open Billing Detail screen (Projects » Billing » Prepare Billings), which means it cannot be traced back to the General Ledger, the source will be User.
This field displays the description of the transaction as it was entered.
This is the General Labor Category (GLC) assigned to the employee on this transaction.
This is the description of the GLC assigned to the employee on this transaction.
This field displays the date on which this bill was effective.
This field displays the fiscal year to which the transaction was posted.
This field displays the period to which the transaction was posted.
This field displays the subperiod to which the transaction was posted.
This field displays the journal that was used to enter and post the transaction.
This field displays the ID type, either Employee, Vendor, Vendor Employee, or None, for labor transactions.
This field displays the employee, vendor or vendor employee ID for those transactions with an ID Type other than None.
This field displays the full employee, vendor, or vendor employee name.
This field displays the timesheet date of the transaction.
This field displays the voucher number if the transaction was entered in Costpoint Accounts Payable.
This field displays the A/P invoice number if the transaction was entered in Costpoint Accounts Payable.
This field displays the journal entry number if the transaction was entered via journal entry.
This field displays the cash receipt number if a cash receipt has been entered.
Use this field to record a reason for any amounts that have been placed on hold.
Use this field to record a reason for any amounts that have been written off.
This is the reference number 1 to which the transaction was posted, if applicable.
This is the reference number 2 to which the transaction was posted, if applicable.
The following detail fields are used only by the Units line type.
This field displays the project to which the transaction was posted.
This field displays the CLIN assigned to this transaction.
This field displays the catalog assigned to this transaction.
This field displays the item number on this transaction.
This field displays the revision number of the item.
This field displays the description of the item on this transaction.
This field displays the sales tax code for this transaction.
This field is the result, in your functional currency, of multiplying the sales tax percent for the selected sales tax code times the Unit Price times the Quantity.
This field is the result, in the invoice's billing currency, of multiplying the sales tax percent for the selected sales tax code times the Billing Currency Unit Price times the Quantity.
This field displays the number of units that will be billed. This field can be edited.
This field displays, in your company's functional currency, the unit price that will be multiplied by the Units To Bill to arrive at the Amount To Bill for this transaction. This field can be edited.
This field displays, in the invoice's billing currency, the unit price that will be multiplied by the Units To Bill to arrive at the Billing Crncy Amt to Bill for this transaction. This field can be edited.
This field displays, in your company's functional currency, the amount of the transaction that will be billed. This field is the result of multiplying the Units To Bill field by the Unit Price field. You cannot edit this field; you can change this field only by editing one of the two fields used to calculate the Amt To Bill.
This field displays, in the invoice's billing currency, the amount of the transaction that will be billed. This field is the result of multiplying the Units To Bill field by the Billing Crncy Unit Price field. You cannot edit this field; you can change this field only by editing one of the two fields used to calculate the Billing Crncy Amt To Bill.
This field displays the amount of units of the Amt To Bill that you would like to place on hold and exclude from the bill. Rows that contain burden or fee cannot be held or written off, but can be edited via the Amt To Bill field. Changing this field changes the Units To Bill, which, in turn, changes the Amt To Bill.
The transactions placed on hold will retain that status, and will appear in the Units on Hold field until in the Maintain Open Billing Detail screen (Projects » Billing » Prepare Billings) until your manually change them. If a transaction is partially placed on hold and then subsequently billed, note that the transaction will appear more than once on the supporting schedules; once for each portion that has been billed.
This field is used for the units that have been previously placed on hold and which have now been determined to be unbillable at any time. By transferring them from Hold to Write Off, you ensure that the transactions will not appear on any subsequent bills. Rows that contain burden or fee cannot be held or written off, but can be edited via the Amt To Bill field. Changing this field changes the Units To Bill, which will change the Amt To Bill.
This field displays the billing history units for previously billed transactions. Units previously billed are summarized on a separate line.
This field displays, in your functional currency, the billing history amount for previously billed transactions.
This field displays, in the invoice's billing currency, the billing history amount for previously billed transactions.
This field displays the discount amount applied to the bill. This amount will be excluded from the bill.
This field displays, in the invoice's billing currency, the discount amount applied to the bill. This amount will be excluded from the bill.
This field is not currently used.
This field describes the source of the transaction. If the transaction is an auditable record, meaning that it was added to Open Billing Detail by a system posting process, the source will be System. If you entered the transaction manually in the Maintain Open Billing Detail screen (Projects » Billing » Prepare Billings), which means it cannot be traced back to the General Ledger, the source will be User.
Previously billed amounts are summarized on a separate line.
This field displays the account to which the transaction was posted.
This field displays the organization to which the transaction was posted.
This field displays the description of the transaction as it was entered.
This field displays the fiscal year to which the transaction was posted.
This field displays the period to which the transaction was posted.
This field displays the subperiod to which the transaction was posted.
This field displays the journal that was used to enter and post the transaction.
This field displays the units usage date of the transaction.
This field displays the cash receipt number if a cash receipt has been entered.
Use this field to record the reason for any amounts that have been placed on hold.
Use this field to record the reason for any amounts that have been written off.
This is the reference number 1 to which the transaction was posted, if applicable.
This is the reference number 2 to which the transaction was posted, if applicable.
This field contains the long item description for this transaction.
Use this field to enter comments about this transaction line.
After you have made your changes to the Detail subtask, click this button to recalculate the bill. This process will change the Amount Due fields. Note that changing any of the direct amounts on this screen will not automatically change the burden or fee amounts. You must change these fields manually in this screen. The optimum method of editing bills is to make your changes in the Maintain Open Billing Detail screen (Projects » Billing » Prepare Billings) before calculating bills. This will ensure that all calculations are performed.
Click this button to record customs and excise information for the customer invoice.