to select, the project number to which
the billing was posted. It must be set up as a posting project number
in the Project Billing Info screen (Projects
» Billing » Billing Master or Projects
» Project Setup » Revenue Setup). Use this screen to display billing transactions that have already been billed. You can use these transactions to compute retroactive billings. You must set up a project number in the Project Billing Info screen (Projects » Billing » Billing Master or Projects » Project Setup » Revenue Setup) as the posting project number before you can enter it and its lower levels transactions into this screen. Normally no data entry is needed in this screen. Find is not available due to the lack of any primary key in this table. Use Query to select records with which you want to work. Narrow your selection sufficiently, or it may take a while to retrieve your query. In general, it is better to work with smaller sets than large ones. You can also add user transactions in this screen, and they will be treated just like any system transactions.
The system updates this screen when you post the billing journal to the general ledger. If you have already computed and posted bills outside of Costpoint, you will need to update the Billing History and optionally the Closed Billing Detail. If you allow for partially billed transactions, a transaction can be in the closed billing detail and in the open billing detail at the same time.
Enter, or use to select, the project number to which
the billing was posted. It must be set up as a posting project number
in the Project Billing Info screen (Projects
» Billing » Billing Master or Projects
» Project Setup » Revenue Setup).
If you want to enter additional records, enter a project number or use
to select a valid project number. As you move to the
next field, the system will validate that this project is a posting project
number. If you want to view records previously posted, use Query to retrieve
them.
This field displays either System or User, depending on whether the system created the record during posting or whether the record was added manually in this screen. Note that you cannot change the audit trail information if the transaction is a System transaction.
Use the drop-down list to select the transaction type. The transaction type identifies the purpose of the transaction in regard to the billing. Valid transaction types are as follows:
Burden - Use this type for showing burden on allowed cost.
Cost - Use this type for billing transactions based on incurred cost.
Fee - Use this type for showing fee on incurred cost and burden.
Fee on Hours - Use this type for showing fee based on hours incurred.
Hours - Use this type for billing transactions based on loaded labor rates (T&M).
Retainage - Use this type for showing retainage or withholding on a bill.
Units - Use this type for billing transactions based on CLIN, Item, Revision #, and Quantity.
Cost of Money - Use this type for showing Cost of Money amounts, when applicable.
Over Fee Ceiling - Use this type for showing amounts in excess of the fee ceiling.
Over Cost Ceiling - Use this type for showing amounts in excess of the cost ceiling.
Over Total Ceiling - Use this type for showing amounts in excess of the total ceiling for a given project/task.
Schedule - Use this type for billing scheduled amounts entered in the Billings From Schedule subtask of the Project Billing Info screen (Projects » Billing » Billing Master or Projects » Project Setup » Revenue Setup).
Fee on Labor - Use this type for showing fee on incurred labor costs.
Labor Discount - Use this type for a labor discount.
Non-Labor Discount - Use this type for a non-labor discount.
Enter, or use to
select, a transaction project number that uses transactions to calculate
billings. As you move to the next field, the system will validate that
this project level allows charging. If this project and level do not allow
charging, you will receive an error and must correct this before you continue.
When the transaction is saved, the system will validate the transaction
project in accordance with the information in the charging criteria group
box of the Maintain Project Master screen (Projects
» Project Setup » Project Master).
This field displays the journal code that identifies from where the transaction was posted. If the transaction was added manually, or the transaction type is Fee, Burden, or Retainage, it will not have a journal code.
This field displays the fiscal year in which the transaction was posted or occurred (if entered manually). The system uses this date to determine which burden rate should be applied to the transaction's costs.
This field displays the period in which the transaction was posted or occurred (if entered manually). The system uses this date to determine which burden rate should be applied to the transaction's costs.
This field displays the subperiod in which the transaction was posted or occurred (if entered manually).
Enter, or use to select, an account that is related
to the transaction. As you move to the next field, the system will validate
that the account number is not a summary account, the account is active,
and that the account allows charging for the fiscal year, period and subperiod
on this transaction. You will receive a message if the account fails any
of the preceding validations, and you should correct the account. When
the transaction is saved, the system will verify that the account is valid
for the organization and for the project entered.
Enter an organization number or use to select one. As
you move to the next field, the system will validate that the organization
is active and allows charging for the fiscal year, period, and subperiod
on this transaction. You will receive a message if the organization fails
any of the preceding validations, and you should correct the organization.
When the transaction is saved the system will verify that the organization
is valid for use with the account. If organizations are restricted to
specific projects, it will check to see if that organization is allowed
to charge that account for that project.
This non-editable field displays your company's functional currency.
This field displays the schedule number, which is used to relate many transactions together to one project bill. The only time the schedule number is different than the invoice number is when there is more than one customer sharing a project. Then the schedule number will be the lowest invoice number assigned for that billing posting.
Enter a description up to 30 characters for this transaction. This can be used on supporting schedules as an explanation of the charges.
This non-editable field indicates whether the transaction was included in an Inter-Company Work Order (IWO) Transfer. This field displays Y (Yes) if this line was included in an IWO, N (No) if this line was not included in an IWO.
This group box contains information related to the cost portion of the transaction. The fields in the Cost group box should be used for cost, burden, fee, and retainage transactions. For the transaction types of burden, fee, and retainage, the only fields that should be filled in are the Tran Amount and the Amount Billed. These fields should be equal to each other for these transaction types. The only exception is the Amount Billed field, which is used by all of the transaction types. The sum of the Amount Billed field for all transactions belonging to a specific schedule number should equal the project receivable total for all customers sharing that project.
This field displays the cost amount of transaction that was used for billing. If the Tran Type is Hours, you can enter the cost, but it will not be used for billing recalculation. You will also have cost amounts for Fee, Burden, and Retainage transactions.
This field displays the amount of the transaction that was written off from being billed. It is stored in the closed billing detail so that reports can show what was written off and the reason for the write-off. Normally you would not enter write-off transactions into the closed billing detail. We suggest that you enter a reason for writing off the amount in the Reason subtask.
This field displays the amount of this transaction that has previously been billed. We do not recommend that you change this amount. The only time a transaction has an amount in Amt Prev Billed is when the transaction was partially billed by putting a portion of the transaction on hold.
This field displays the amount billed for this transaction for this schedule number. All transaction types use the Amount Billed field. An amount billed for 4 hours times the billing rate of 100.00 would be $400.00.
If the Tran Type is Labor Discount or Non-Labor Discount, this field displays the discount amount.
This group box contains information related to the hours portion of the transaction. Hours transactions can come from Costpoint Labor, Costpoint Accounts Payable, and Journal Entries.
This field displays the number of hours related to this transaction that were used for billing. If the project is a T&M project and the transaction is a labor transaction, the cost will be displayed but is not used for calculating the billing. All billings using hours require additional information relating to employee and labor category. Enter this additional information in the Labor subtask.
This field displays the number of hours of the transaction that were written off from being billed. It is stored in the closed billing detail so that reports can show what was written off and the reason for the write off. Normally you would not enter write-off transactions into the closed billing detail. We suggest that you enter a reason for writing off the hours in the Reason subtask.
This field displays the number of hours of this transaction that were previously billed. We recommend that you do not change this amount. The only time a transaction has an amount in the Hrs Prev Billed field is when the transaction was partially billed by putting a portion of the transaction hours on hold.
This field displays the hours billed for this transaction for this schedule number. If a transaction has had a partial billing because hours were placed on hold, you will not be able to subtract the total of the Write Off Hrs plus the Hrs Prev Billed from the Tran Hrs to arrive at the Hours Billed. At no time should the sum of the Write Off Hrs plus the Hrs Prev Billed plus the Hours Billed exceed the Tran Hrs.
This group box contains the information related to the units portion of the transaction. Units transactions come from Unit Usage. You can enter information in the Units group box or subtask only if the Transaction Type is Units.
This field displays the number of units related to this transaction that were used for billing. All unit based transactions require additional information relating to CLIN and item number. Enter this additional information in the Units subtask.
This field displays the number of units of the transaction that were written off from being billed. It is stored in the closed billing detail so that reports can show what was written off and the reason for the write off. Normally you would not enter write-off transactions into the closed billing detail. We suggest that you enter a reason for writing off the units in the Reason subtask.
This field displays the number of units that were previously billed. We do not recommend that you change this amount. Unit transactions can be partially billed because they have been placed on hold or have a quantity discount.
This field displays the units billed for this transaction for this schedule number. If a transaction has had a partial billing because units were placed on hold, you will not be able to subtract the total of the Write Off Units plus the Units Prev Billed from the Tran Units to arrive at the Units Billed. At no time should the sum of the Write Off Units plus the Units Prev Billed plus the Units Billed exceed the Tran Units.
Use this group box to review information on billing currency codes and amounts.
This field displays the code for the currency used to bill this project. Once the project has been billed in one currency, changing the billing currency will cause incorrect retainage and tax amounts to print on invoices. If you need to change the Billing Currency of a project that has been previously billed, use the Update Billing Currency Amounts toolkit in the Miscellaneous Toolkits screen (Projects » Billing » Utilities).
This field displays, in the billing currency, the amount previously billed for this project.
This field displays, in the billing currency, the total amount billed for this project.
If this Transaction Type is Labor Discount or Non-Labor Discount, this field displays the discount amount.
Click this button to open the Comments subtask.
Click this button to open the Reason subtask.
Click this button to open the Labor subtask.
Click this button to open the Units subtask.
Click this button to open the Sales Tax subtask.
Click this button to open the Other subtask.
Changes to this screen update the BILLING_DETL_HIST table.