The Posting Process
The posting process in Costpoint Billing involves updating the general ledger, creating accounts receivable records, and inserting appropriate data into the billing history tables.
This topic should assist you in analyzing the process of posting bills and in understanding the tables involved. After you understand the posting process, you can more easily analyze posting problems and resolve setup issues.
There are two types of bills in Costpoint: transaction-based bills and manual bills. Costpoint calculates transaction-based bills using the transactions that are posted to the project. It calculates manual bills using a predetermined schedule, percent complete, units, or a variety of other methods. You can enter and modify manual bills on the Manage Manual Bills, Manage Project Product Bills, Manage Customer Product Bills, and Manage Milestone Percent Complete Bills screens. Only the transaction-based bills collect data in the OPEN_BILLING_DETL table and have transaction history stored in the BILL_INVC_HDR_HS and BILL_DETL_HIST tables. Manual bills have their own history tables and generally do not insert data into the OPEN_BILLING_DETL table. This topic outlines the general procedure that Costpoint uses to post billings. This topic covers details specific to manual or transaction-based bills as necessary.
- Related Topics:
- Posting to the General Ledger
Whether you are posting manual or transaction-based bills, the posting process requires receivable and unbilled accounts. - Update Accounts Receivable Tables
Regardless of which type of bill being posted, Costpoint inserts records into both the AR_HDR_HS and AR_DETL_HS tables during the posting process. - Update Billing History Summary
Once the General Ledger has been updated, Costpoint updates the Manage Billing History screen. - Update Billing History Detail
The Billing Detail History table (BILL_DETL_HIST) is updated next. Only transaction-based bills update this table. - Update Header History Tables
Next, Costpoint updates the header history tables. - Update Billing Master Table
In the final step, the posting process updates the Project Billing Info table (PROJ_BILL_INFO) with the bill number. - Table Information for the Posting Process
The posting process updates several tables.