Update Header History Tables

Next, Costpoint updates the header history tables.  

The following tables are updated by each billing posting:

Posting Screen Table
Post Standard Bills BILL_INVC_HDR_HS
Post Customer Product Bills CUST_PROD_HDR_HS
Post Project Product Bills PROJ_PROD_HDR_HS
Post Manual Bills MANUAL BILL_HS
Post Milestone/Percent Complete Bills MILESTONE_HDR_HS
Post Progress Payment Bills PRG_PMT_HDR_HS

The invoice header in each type of billing is copied to the respective header history table. When you post standard bills, Costpoint creates a record in the invoice header history table for the project level to which the bills are posted and any detail levels that are listed on the Detail Levels subtask of the Manage Project Billing Information screen. For all the manual bill types, only one record is inserted to the header history tables. 

Flexibility to reprint summary and detail exists in the event that invoices are posted before invoices are printed. To allow this flexibility of printing detail billings, a record exists in the Billing Edit Invoice Header table at the invoice posting level, and at the required detail level. 

Only records at the invoice posting level are copied to the Billing Invoice Header History table, if the billing is a manual billing or no detail bills are required.

Each record is assigned a supporting schedule number in the Billing Invoice Header History. This number is also stored in the Billing Detail History. 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.