JC transaction detials are kept in the JC3 table. The type 3 record captures cost by cost code but only has a 'Billed' flag. This request is to capture the amount that was billed against the cost code (for appropriate JC types) at the time the invoice is generated.

If you run the Job Transaction Detail Report and select 'Bill Amount' for the Data to Print, the report will show you the detail transaction records including a Billed Amount column. The billed amount column is dynamically generated in the report by multiplying the units times the billing rate stored in the JC2 (or JCC) tables. If the billing rate changes over the life of the contract, the number displayed on the report will be wrong for some of the records. Government auditors don't like that.

The JC3 table captures billed amounts in the type 2 records but it does not capture the data by cost code.

by: John W. | over a year ago | Payroll / Job Cost