Costpoint Online Help

Using the Help Search
Using the Help Search
  • Phrase:Returns all topics that contain the exact phrase in the search criteria. Use quotation marks around the phrase.
    Ex."system administration"
  • And:Returns all topics that contain all the words in the search criteria, in any combination. Insert a plus sign between all words in the search criteria.
    Ex.system + administration
  • Or:Returns all topics with any combination of words in the search criteria. This is the default.
    Ex.system administration
For more information:Searching Online Help

Update Billing History Detail

The Billing Detail History table (BILL_DETL_HIST) is updated next. Only transaction-based bills update this table.

The Billing Detail History is updated with current transactions billed. The Billing Detail History table stores billing history at the transaction level. Supporting information, including timesheet date, journal entry number, and voucher number, is stored for each transaction. Previously billed transactions and portions of transactions that have been written off are updated at this level as well. Non-transaction billed amounts (burdens, fee, retainage, fee over ceiling, cost over ceiling) are stored by account/org and pool for burden amounts.

Manual Bills do not have detail tables. All information for manual type bills is stored in the header tables outlined in the next section.

  • The transactions are entered in this table at the level of the project for which they were originally posted. The level at which the bill was posted is also recorded. Each record is assigned a supporting schedule number in the Billing Detail History table. This number is also stored in the Billing Invoice Header History table. If you need to recreate invoices, Costpoint uses this field to link the header record to the detail that was billed on a given project and invoice. 
  • Additionally, billing format information is stored in this table. Billing format information includes the group and line number on which this transaction was billed. This allows you to gather and roll up transactions by the groups and lines on which they were billed. If you need to recreate invoices in the same format in which they were originally submitted, these fields can be used to summarize costs.
  • Once the transactions have been fully billed, they are deleted from the Open Billing Detail table. The Open Billing Detail table is updated by journal postings. It contains all transactions recorded but not yet billed. The Calculate Standard Bills screen uses the Open Billing Detail table to arrive at current billable amounts; however, once the total amounts are billed, they must be removed from Open Billing Detail to prevent future billing.
  • You can partially bill transactions if the Allow Transactions To Be Partially Billed check box is selected on the Controls tab of the Manage Project Billing Information screen. Partial billings are needed only when there is some type of ceiling on the project. To make this option possible, only fully billed transactions are deleted from Open Billing Detail. If a transaction has been partially billed, it exists in both Open Billing Detail and Billing Detail History. The Calculate Standard Bills program recognizes and bills only the unbilled portion of transactions; however, a record for this transaction exists in both tables.