DETAIL

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.

Invoice Project

This non-editable field defaults from the main screen. The non-editable field to the right displays the description of the invoice-level project.

Group Description

This non-editable field displays the group description from the main screen.

Line

This non-editable field displays the line from the main screen.

Line Type

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.

Table Window

Cost Detail

The following detail fields are used only by the Cost line type.

Project

This field displays the project to which the transaction was posted.

Account

This field displays the account to which the transaction was posted.

Organization

This field displays the organization to which the transaction was posted.

Pool No

This field displays the pool number that is burdening the transaction. This field is applicable only to bill lines that contain pool costs.

Type

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.

Sales Tax

This field displays the sales tax code for this transaction. You can maintain tax codes in Costpoint System Administration.

Sales Tax Amt

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.

Billing Currency Sales Tax Amt

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.

Amt To Bill

This field displays the amount of the transaction that will be billed. This field can be edited.

Billing Crncy Amt to Bill

This field displays the amount, in billing currency, of the transaction that will be billed. This field can be edited.

Hold Amt

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.

Billing Crncy Hold Amt

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.

Write Off Amt

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.

Billing Crncy Write Off Amt

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.

Prev Billed Amt

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.

Billing Currency Prev Billed Amt

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.

Ceiling Amt

This field is not currently used.

Retainage Amount

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.

Billing Currency Retainage Amt

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.

Over Total Ceiling Amt

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.

Billing Currency Over Total Ceiling Amt

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.

Over Fee Ceiling Amt

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.

Billing Currency Over Fee Ceiling Amt

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.

Over Cost Ceiling Amt

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.

Billing Currency Over Cost Ceiling Amt

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.

Discount Amt

This field displays the discount amount applied to the bill. This amount will be excluded from the bill.

Billing Currency Discount Amt

This field displays, in the invoice's billing currency, the discount amount applied to the bill. This amount will be excluded from the bill.

Source

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.

Description

This field displays the description of the transaction as it was entered.

Fiscal Yr

This field displays the fiscal year to which the transaction was posted.

Period

This field displays the period to which the transaction was posted.

Subpd

This field displays the subperiod to which the transaction was posted.

Journal

This field displays the journal that was used to enter and post the transaction.

ID Type

This field displays the ID type for labor transactions. The ID type can be Employee, Vendor, Vendor Employee, or None.

ID

This field displays the employee, vendor, or vendor employee ID for those transactions with an ID Type other than None.

Name

This field displays the full employee, vendor, or vendor employee name for the selected ID.

A/P Vchr No

This field displays the voucher number if the transaction was entered in Costpoint Accounts Payable.

A/P Invoice No

This field displays the invoice number if the transaction was entered in Costpoint Accounts Payable.

Pool Rate

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."

JE No

This field displays the journal entry number if the transaction was entered via journal entry.

CR No

This field displays the cash receipt number if a cash receipt has been entered.

Reason For Hold Amt

Use this field to record the reason any amounts have been placed on hold.

Reason For Write Off

Use this field to record the reason any amounts have been written off.

Ref 1

This is the reference number 1 to which the transaction was posted, if applicable.

Ref 2

This is the reference number 2 to which the transaction was posted, if applicable.

Hours Detail

The following detail fields are used only by the Hours line type.

Project

This field displays the project to which the transaction was posted.

PLC

This field displays the PLC (Project Labor Category) of the transaction.

PLC Description

This field displays the description of the PLC.

Hrs To Bill

This editable field displays the number of hours that will be billed for this transaction.

Billing Rate

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.

Rate Before Discount

This editable field displays, in your company's functional currency, the rate before discount.

Billing Currency Billing Rate

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.

Billing Currency Billing Rate Before Discount

This editable field displays, in the invoice's billing currency, the rate before discount.

Bill Rate Type

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).

Amt To Bill

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.

Billing Crncy 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.

Hold Hrs

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.

Write Off Hrs

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.

Hrs Prev Billed

This non-editable field displays the billing history hours for previously billed transactions. Hours previously billed are summarized on a separate line.

Prev Billed Amt

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.

Billing Currency Prev Billed Amt

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.

Discount Amt

This field displays the discount amount applied to the bill. This amount will be excluded from the bill.

Billing Currency Discount Amt

This field displays, in the invoice's billing currency, the discount amount applied to the bill. This amount will be excluded from the bill.

Account

This field displays the account to which the transaction was posted.

Organization

This field displays the organization to which the transaction was posted.

Ceiling Hrs

This field is not currently used.

Source

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.

Description

This field displays the description of the transaction as it was entered.

GLC

This is the General Labor Category (GLC) assigned to the employee on this transaction.

GLC Description

This is the description of the GLC assigned to the employee on this transaction.

Effective Bill Date

This field displays the date on which this bill was effective.

Fiscal Yr

This field displays the fiscal year to which the transaction was posted.

Period

This field displays the period to which the transaction was posted.

Subpd

This field displays the subperiod to which the transaction was posted.

Journal

This field displays the journal that was used to enter and post the transaction.

ID Type

This field displays the ID type, either Employee, Vendor, Vendor Employee, or None, for labor transactions.

ID

This field displays the employee, vendor or vendor employee ID for those transactions with an ID Type other than None.

Name

This field displays the full employee, vendor, or vendor employee name.

T/S Date

This field displays the timesheet date of the transaction.

A/P Vchr No

This field displays the voucher number if the transaction was entered in Costpoint Accounts Payable.

A/P Invoice No

This field displays the A/P invoice number if the transaction was entered in Costpoint Accounts Payable.

JE No

This field displays the journal entry number if the transaction was entered via journal entry.

CR No

This field displays the cash receipt number if a cash receipt has been entered.

Reason For Hold Amt

Use this field to record a reason for any amounts that have been placed on hold.

Reason For Write Off

Use this field to record a reason for any amounts that have been written off.

Ref 1

This is the reference number 1 to which the transaction was posted, if applicable.

Ref 2

This is the reference number 2 to which the transaction was posted, if applicable.

Units Detail

The following detail fields are used only by the Units line type.

Project

This field displays the project to which the transaction was posted.

CLIN

This field displays the CLIN assigned to this transaction.

Catalog

This field displays the catalog assigned to this transaction.

Item No

This field displays the item number on this transaction.

Rev No       

This field displays the revision number of the item.

Item Description

This field displays the description of the item on this transaction.

Sales Tax

This field displays the sales tax code for this transaction.

Sales Tax Amt

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.

Billing Currency Sales Tax Amt

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.

Units To Bill

This field displays the number of units that will be billed. This field can be edited.

Unit Price

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.

Billing Crncy Unit Price

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.

Amt To Bill

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.

Billing Crncy 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.

Hold Units

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.

Write Off Units

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.

Unit Prev Billed

This field displays the billing history units for previously billed transactions. Units previously billed are summarized on a separate line.

Prev Billed Amt

This field displays, in your functional currency, the billing history amount for previously billed transactions.

Billing Currency Prev Billed Amt

This field displays, in the invoice's billing currency, the billing history amount for previously billed transactions.

Discount Amt

This field displays the discount amount applied to the bill. This amount will be excluded from the bill.

Billing Currency Discount Amt

This field displays, in the invoice's billing currency, the discount amount applied to the bill. This amount will be excluded from the bill.

Unit Ceiling

This field is not currently used.

Source

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.

Account

This field displays the account to which the transaction was posted.

Organization

This field displays the organization to which the transaction was posted.

Description

This field displays the description of the transaction as it was entered.

Fiscal Yr

This field displays the fiscal year to which the transaction was posted.

Period

This field displays the period to which the transaction was posted.

Subpd

This field displays the subperiod to which the transaction was posted.

Journal

This field displays the journal that was used to enter and post the transaction.

Usage Date

This field displays the units usage date of the transaction.

CR NO

This field displays the cash receipt number if a cash receipt has been entered.

Reason For Hold Amt

Use this field to record the reason for any amounts that have been placed on hold.

Reason For Write Off

Use this field to record the reason for any amounts that have been written off.

Ref 1

This is the reference number 1 to which the transaction was posted, if applicable.

Ref 2

This is the reference number 2 to which the transaction was posted, if applicable.

Long Item Description

This field contains the long item description for this transaction.

Comments

Use this field to enter comments about this transaction line.

Recalculate

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.

Customs Info

Click this button to record customs and excise information for the customer invoice.