Job Costing - Transaction Detail Log

Screenshot of Transaction Detail Log.

Pgm: JCDETAIL_LOG - JC Transaction Detail Log; standard Treeview path: Job Costing > Queries > Transaction Detail

The Job Costing Transaction Detail Log displays posted and unposted cost code (phase)/category transactions for a job.

The Unbilled Revenue Amount column is a calculated column based on job billing rates, equipment billing rates, or payroll billing rates. The value populated under this column is used as CPR (calculated potential revenue) amount for cost type bill code lines, in job billing generation programs, to be generated as billing amounts.

The Unbilled Revenue column values may be updated when necessary, using the Job Billing module's Job Billing - Recalculating Billing Rates utility.

If the Post Burdens By field is set to "Transaction Type" and the 'Post Transactions by Hour Type in Job Cost' box is checked on the General tab of the Payroll Control screen in the US Payroll module, the labor cost transaction lines will display individual lines for each transaction type (component), as opposed to current two lines for base wage and burdens lump sum amount (standard Treeview path: US Payroll > Setup > Company > Control – General tab). Payroll timesheet posting will consider the checked 'Post Transactions by Hour Type in Job Cost' box and will post and split the transactions by hour type in the JC Transaction Detail Log screen: NWHR, OVHR (OT), DTHR (DOT), OTHR (Other Hours), and Expense.

NOTE: For burden types, the JCDT_AMT will be used for calculation of the unbilled revenue amount. The Payroll’s Final Posting screen will post individual lines in the JCDETAIL table for both costs and burden amounts.

Customizing Display

Hover over a column header to display arrows to sort the column in ascending or descending order. Also, columns can be dragged and dropped to different positions, and resized.

NOTE For more information about using the Data Filters feature, refer to Getting Started - Searches, Table Filters & Sorts.