Search Tips
Since the Job Summary By drop-down list is set to "Time Sheet" and the 'Post Transactions by Hour Type in Job Cost' box is checked in the Payroll Control, each unique record in the posted timesheet corresponds to one or more separate Job Costing transaction record(s) depending upon the hour type (e.g. REG – Regular, OT – Overtime, DOT – Double Overtime etc.).
NOTE: Due to Job Billing Overtime Rule processing, there may be further additional records for the hour types depending on the overtime rule setup.
For example, if the timesheet only has REG and OT hours entered for a given employee for a job/cost/category on a single day then, barring any additional setup, upon posting the timesheet it results in two cost transaction records. One for each REG and OT hour type.
However, if due to Billing Overtime Rule Processing, some hours are also allocated to DOT on the given day for the same employee and Job/Cost Code/Category combination, then it results in three cost transaction records. One for each REG, OT, and DOT.
Calculating Billing Quantity and Unbilled Revenue Amount with Proration
Since the Payroll timesheet is processed through the Job Billing Overtime Rules, the quantity/hours used to calculate the unbilled revenue amount is calculated through proration at a job level (Job Billing Overtime Rules are only applicable at the job level).
NOTE: Even if multiple employees with different pay/charge rates work on the same job, then the proration works on the total of all the employees’ quantity for the given job.
The billing quantity for each cost transaction record in the Job Costing Transaction Detail Log is calculated as the sum of the Payroll Quantity (JCDT_UNIT) and Payroll Job Billing Adjusted Quantity (JCDT_PYJB_BILLING_ADJ_QTY).
The Unbilled Revenue Amount is then calculated as the product of the Billing Quantity and the Billing Rate from the corresponding Job Billing Rate table.
To better demonstrate the calculations, consider the following two examples: