Detail Subtask
Use this subtask to review and modify the individual transaction lines that comprise each bill line.
You cannot modify transaction lines unless the Allow User to Edit Bills check box is selected on the Manage Project Billing Information screen. Any modifications made in this subtask are reflected in the summary amount of the bill line on the main screen.
Table Window
Use this table window to view or modify details for individual transaction lines.
If you are not licensed for multicurrency, the functional currency amount fields are editable, while billing currency amount fields are non-editable and not shown.
If you are licensed for multicurrency, these conditions apply:
- If the billing currency is the same as the functional currency, functional currency amounts are editable.
- If the billing currency is not the same as the functional currency and there are no values on the Hold Amount and Write Off Amount fields, only the billing currency amounts are editable.
- If the billing currency is not the same as the functional currency, there are values on the Hold Amount and Write Off Amount fields, the billing currency is the same as the transactional currency, and the Use Transactional Currency Billing check box is selected on the Manage Project Billing Information screen, the billing on hold and write off amounts are editable and are saved to MU_TRN_HOLD_AMT and MU_TRN_WRITEOF_AMT, respectively. Functional currency amounts, on the other hand, are non-editable.
- If the billing currency is not the same as the functional currency, there are values on the Hold Amount and Write Off Amount fields, and the billing currency is different from the transactional currency, the functional on hold and write off amounts are editable, while billing currency amounts are disabled. This applies whether the Use Transactional Currency Billing check box is selected or not.
Cost Detail
The following detail fields are used only by the Cost line type.
Field | Description |
---|---|
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 Number |
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 the System Administration menu. |
Sales Tax Amount |
This field is the result of multiplying the sales tax percent for the selected sales tax code times the Amount to Bill or Billing Currency Amount to Bill. You can modify 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 Amount |
This field is the result of multiplying the sales tax percent for the selected sales tax code times the Amount to Bill or Billing Currency Amount to Bill. You can modify this amount to adjust for rounding amounts in tax calculation in both your company's functional currency and this invoice's billing currency. |
Amount To Bill |
This field displays the amount of the transaction that is billed. This field can be modified. |
Billing Currency Amount to Bill |
This field displays the amount, in billing currency, of the transaction that is billed. This field can be modified. |
Hold Amount |
This field displays, in your functional currency, the amount, of cost of the Amount 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 modified via the Amount To Bill field. Changing this field automatically modifies the Amount To Bill. The transactions placed on hold retain that status, and appear in the Amount on Hold field until they are manually modified on the Manage Open Billing Detail screen. If a transaction is partially placed on hold and then subsequently billed, note that the transaction appear more than once on the supporting schedules; once for each portion that has been billed. |
Billing Currency Hold Amount |
This field displays, in the invoice's billing currency, the amount of cost of the Amount 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 modified via the Amount To Bill field. Modifying this field automatically modifies the Amount To Bill. The transactions placed on hold retain that status, and appear in the Amount on Hold field until they are manually modified on the Manage Open Billing Detail screen. If a transaction is partially placed on hold and then subsequently billed, note that the transaction appears more than once on the supporting schedules; once for each portion that has been billed. |
Write Off Amount |
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 do not appear on any subsequent bills. Rows that contain burden or fee cannot be held or written off, but can be modified via the Amount To Bill field. Modifying this field automatically modifies the Amount To Bill. |
Billing Currency Write Off Amount |
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 do not appear on any subsequent bills. Rows that contain burden or fee cannot be held or written-off, but can be modified via the Amount To Bill field. Modifying this field automatically modifies the Amount To Bill. |
Previously Billed Amount |
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 Previously Billed Amount |
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 Amount |
This field is not currently used. |
Retainage/Withhold/Release Amt |
|
Billing Currency Retainage/Withhold/Release Amt |
|
Over Total Ceiling Amount |
This field displays, in your company's functional currency, the amount that caused the total project ceiling to be exceeded. This amount is excluded from the bill. |
Billing Currency Over Total Ceiling Amount |
This field displays, in the invoice's billing currency, the amount that caused the total project ceiling to be exceeded. This amount is excluded from the bill. |
Over Fee Ceiling Amount |
This field displays, in your company's functional currency, the fee that caused the total fee ceiling to be exceeded. This amount is excluded from the bill. |
Billing Currency Over Fee Ceiling Amount |
This field displays, in the invoice's billing currency, the fee that caused the total fee ceiling to be exceeded. This amount is excluded from the bill. |
Over Cost Ceiling Amount |
This field displays, in your company's functional currency, the cost that caused the total cost ceiling to be exceeded. This amount is excluded from the bill. |
Billing Currency Over Cost Ceiling Amount |
This field displays, in the invoice's billing currency, the cost that caused the total cost ceiling to be exceeded. This amount is excluded from the bill. |
Discount Amount |
This field displays the discount amount applied to the bill. This amount is excluded from the bill. |
Billing Currency Discount Amount |
This field displays, in the invoice's billing currency, the discount amount applied to the bill. This amount is 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 is System. If you entered the transaction manually on the Manage Open Billing Detail screen, which means it cannot be traced back to the General Ledger, the source is User. |
Description |
This field displays the description of the transaction as it was entered. |
Fiscal Year |
This field displays the fiscal year to which the transaction was posted. |
Period |
This field displays the period to which the transaction was posted. |
Subperiod |
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 Voucher Number |
This field displays the voucher number if the transaction was entered in Costpoint Accounts Payable. |
A/P Invoice Number |
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 Number |
This field displays the journal entry number if the transaction was entered via journal entry. |
Cash Receipt Number |
This field displays the cash receipt number if a cash receipt has been entered. |
Reason For Hold Amount |
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. |
Bill Edit Key |
This exposed field is used by Costpoint web services to connect a third party application to your Costpoint Billing tables. |
Hours Detail
The following detail fields are used only by the Hours line type.
Field | Description |
---|---|
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. |
Amount To Bill |
This field displays the amount of the transaction that is billed. This field is the result of multiplying the Hours To Bill field by the Billing Rate field. You cannot modify this field; you can modify this field only by modifying one of the two fields used to calculate the Amount To Bill. |
Billing Currency Amount to Bill |
This field displays the amount, in billing currency, of the transaction that is billed. This field is the result of multiplying the Hours To Bill field by the Billing Currency Billing Rate field. You cannot modify this field; you can modify this field only by modifying one of the two fields used to calculate the Amount To Bill. |
Billing Currency Write Off Amount |
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 amounts from Hold to Write Off, you can ensure that the transactions do not display on any subsequent bills. Rows that contain burden or fee cannot be held or written-off, but can be edited via the Amount To Bill field. Changing this field automatically changes the Amount To Bill field. |
Previously Billed Amount |
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 Previously Billed Amount |
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. |
Billing Currency Retainage Amount |
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 field. Changing the retainage amount does not affect the Amount To Bill, and affects only the total amount due. If you are billing for retainage, make this field negative for the amount of the retainage that you want to bill. The total amount due is then adjusted by the amount entered. |
Billing Currency Over Total Ceiling Amount |
This field displays, in the invoice's billing currency, the amount that caused the total project ceiling to be exceeded. This amount is excluded from the bill. If the ceiling is increased, you can enter a negative amount in this field and the total amount due for the bill is increased by that amount. |
Billing Currency Over Fee Ceiling Amount |
This field displays, in the invoice's billing currency, the amount that caused the total project fee ceiling to be exceeded. This amount is excluded from the bill. If the fee ceiling is increased, you can enter a negative amount in this field and this amount is included in the total amount due for the invoice. |
Billing Currency Over Cost Ceiling Amount |
This field displays, in the invoice's billing currency, the cost that caused the total cost ceiling to be exceeded. This amount is excluded from the bill. If the cost ceiling is increased, you can enter a negative amount in this field and this amount is included in the total amount due for the invoice. |
Discount Amount |
This field displays the discount amount applied to the bill. This amount is excluded from the bill. |
Billing Currency Discount Amount |
This field displays, in the invoice's billing currency, the discount amount applied to the bill. This amount is excluded from the bill. |
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 is System. If you entered the transaction manually on the Manage Open Billing Detail screen, which means it cannot be traced back to the General Ledger, the source is User. |
Description |
This field displays the description of the transaction as it was entered. |
Fiscal Year |
This field displays the fiscal year to which the transaction was posted. |
Period |
This field displays the period to which the transaction was posted. |
Subperiod |
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. |
A/P Voucher Number |
This field displays the voucher number if the transaction was entered in Costpoint Accounts Payable. |
A/P Invoice Number |
This field displays the A/P invoice number if the transaction was entered in Costpoint Accounts Payable. |
JE Number |
This field displays the journal entry number if the transaction was entered via journal entry. |
Cash Receipt Number |
This field displays the cash receipt number if a cash receipt has been entered. |
Reason For Hold Amount |
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. |
PLC |
This field displays the PLC (Project Labor Category) of the transaction. |
PLC Description |
This field displays the description of the PLC. |
Hours To Bill |
This editable field displays the number of hours that are billed for this transaction. |
Billing Rate |
This editable field displays, in your company's functional currency, the rate that is multiplied by the Hours To Bill to arrive at the Amount To Bill. |
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 on the Labor tab of the Manage Open Billing Detail screen. |
Hold Hrs |
This field displays the amount of hours of the Amount To Bill that you would like to place on hold and exclude from the bill. Changing this field modifies the Hours To Bill, which, in turn, modifies the Amount To Bill. The transactions placed on hold retain that status, and appear in the Hours on Hold field on the Manage Open Billing Detail screen until you manually modify them. If a transaction is partially placed on hold and then subsequently billed, note that the transaction 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 do not appear on any subsequent bills. Rows that contain burden or fee cannot be held or written-off, but can be modified via the Amt To Bill field. Modifying this field modifies the Hours To Bill, which, in turn, modifies the Amount To Bill. |
Hours Previously Billed |
This non-editable field displays the billing history hours for previously billed transactions. Hours previously billed are summarized on a separate line. |
Ceiling Hrs |
This field is not currently used. |
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. |
Timesheet Date |
This field displays the timesheet date of the transaction. |
Usage Date |
This non-editable field displays the usage date used for transactions that were entered on the Manage Unit Usage screen. |
Billing Currency Billing Rate |
This editable field displays, in the invoice's billing currency, the rate that is multiplied by the Hours To Bill to arrive at the Amount To Bill. |
Bill Edit Key |
This exposed field is used by Costpoint web services to connect a third party application to your Costpoint Billing tables. |
Units Detail
The following detail fields are used only by the Units line type.
Field | Description |
---|---|
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. |
Sales Tax |
This field displays the sales tax code for this transaction. |
Sales Tax Amount |
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. |
Amount To Bill |
This field displays, in your company's functional currency, the amount of the transaction that is billed. This field is the result of multiplying the Units To Bill field by the Unit Price field. You cannot modify this field; you can modify this field only by modifying one of the two fields used to calculate the Amount To Bill. |
Billing Currency Amount to Bill |
This field displays, in the invoice's billing currency, the amount of the transaction that is billed. This field is the result of multiplying the Units To Bill field by the Billing Crncy Unit Price field. You cannot modify this field; you can modify this field only by modifying one of the two fields used to calculate the Billing Currency Amount To Bill. |
Billing Currency Write Off Amount |
This field displays, in the invoice's billing currency, the cost that was previously placed on hold and which is now determined to be unbillable at any time. By transferring amounts from Hold to Write Off, you can ensure that the transactions do not display on any subsequent bills. Rows that contain burden or fee cannot be held or written-off, but can be edited via the Amount To Bill field. Changing this field automatically changes the Amount To Bill field. |
Previously Billed Amount |
This field displays, in your functional currency, the billing history amount for previously billed transactions. |
Billing Currency Previously Billed Amount |
This field displays, in the invoice's billing currency, the billing history amount for previously billed transactions. |
Billing Currency Retainage Amount |
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 field. Changing the retainage amount does not affect the Amount To Bill, and affects only the total amount due. If you are billing for retainage, make this field negative for the amount of the retainage that you want to bill. The total amount due is then adjusted by the amount entered. |
Billing Currency Over Total Ceiling Amount |
This field displays, in the invoice's billing currency, the amount that caused the total project ceiling to be exceeded. This amount is excluded from the bill. If the ceiling is increased, you can enter a negative amount in this field and the total amount due for the bill is increased by that amount. |
Billing Currency Over Fee Ceiling Amount |
This field displays, in the invoice's billing currency, the amount that caused the total project fee ceiling to be exceeded. This amount is excluded from the bill. If the fee ceiling is increased, you can enter a negative amount in this field and this amount is included in the total amount due for the invoice. |
Billing Currency Over Cost Ceiling Amount |
This field displays, in the invoice's billing currency, the cost that caused the total cost ceiling to be exceeded. This amount is excluded from the bill. If the cost ceiling is increased, you can enter a negative amount in this field and this amount is included in the total amount due for the invoice. |
Discount Amount |
This field displays the discount amount applied to the bill. This amount is excluded from the bill. |
Billing Currency Discount Amount |
This field displays, in the invoice's billing currency, the discount amount applied to the bill. This amount is 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 is System. If you entered the transaction manually on the Manage Open Billing Detail screen, which means it cannot be traced back to the General Ledger, the source is User. Previously billed amounts are summarized on a separate line. |
Description |
This field displays the description of the transaction as it was entered. |
Fiscal Year |
This field displays the fiscal year to which the transaction was posted. |
Period |
This field displays the period to which the transaction was posted. |
Subperiod |
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. |
Cash Receipt Number |
This field displays the cash receipt number if a cash receipt has been entered. |
Reason For Hold Amount |
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. |
Comments |
Use this field to enter comments about this transaction line. |
Units To Bill |
This field displays the number of units that are billed. This field can be modified. |
Unit Price |
This field displays, in your company's functional currency, the unit price that is multiplied by the Units To Bill to arrive at the Amount To Bill for this transaction. This field can be modified. |
Catalog |
This field displays the catalog assigned to this transaction. |
Item No |
This field displays the item number on this transaction. |
Item Revision Number |
This field displays the revision number of the item. |
Item Description |
This field displays the description of the item on this transaction. |
Billing Crncy Unit Price |
This field displays, in the invoice's billing currency, the unit price that is multiplied by the Units To Bill to arrive at the Billing Currency Amount to Bill for this transaction. This field can be modified. |
Hold Units |
This field displays the amount of units of the Amount 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 modified via the Amount To Bill field. Modifying this field modifies the Units To Bill, which, in turn, modifies the Amount To Bill. The transactions placed on hold retain that status, and appear in the Units on Hold field until on the Manage Open Billing Detail screen until you manually modify them. If a transaction is partially placed on hold and then subsequently billed, note that the transaction appears 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 do not appear on any subsequent bills. Rows that contain burden or fee cannot be held or written off, but can be modified via the Amount To Bill field. Modifying this field modifies the Units To Bill, which modifies the Amount To Bill. |
Unit Previously Billed |
This field displays the billing history units for previously billed transactions. Units previously billed are summarized on a separate line. |
Usage Date |
This field displays the units usage date of the transaction. |
Unit Ceiling |
This field is not currently used. |
CLIN |
This field displays the CLIN assigned to this transaction. |
Long Item Description |
This field contains the long item description for this transaction. |
Bill Edit Key |
This exposed field is used by Costpoint web services to connect a third party application to your Costpoint Billing tables. |
Recalculate |
After you have made your modifications to the Detail subtask, click this button to recalculate the bill. This process modifies the Amount Due fields. Note that changing any of the direct amounts on this screen do not automatically modify the burden or fee amounts. You must modify these fields manually in this screen. The optimum method of modifying bills is to make your modifications on the Manage Open Billing Detail screen before calculating bills. This ensures that all calculations are performed. |
Subtask
Subtask | Description |
---|---|
Customs Info | Click this link to record customs and excise information for the customer invoice. |
- Related Topics:
- Detail Subtask FAQ
Use this section to know more about the Detail subtask. - Customs Info Subtask
Use this subtask to record customs and excise information for the customer invoice from the main screen.