JC report run based on jobs with labor cost for a specific PE date

Question

I would like to be able to send (thru MA) a labor cost report (JC) to PM's for only jobs that had payroll the previous week. I have the report built, but all jobs with Labor cost run - is there anyway to condition/filter by only jobs with PR for a certain Period End Date?

Art Minds · Accepted Answer

Teresa, if you're printing one job per page, be sure to apply the conditional print area to everything that prints on the page. Also, be sure to check the box "Suppress Blank Lines if False" on the screen where you select the formula for the print condition.

Art Minds · Answer

Will you be reporting the JTD labor, but just for the jobs that had payroll in the most recent week? Unless you are using the Weekly accumulator option in your job setup, you will need to produce this report from the Job Cost Transaction file rather than the Job Cost Master file. 
 Since you will need to use the Current.JCT file as your driving record, you need to create a formula that determines if there are labor costs within the reporting period on a job by job basis. 
 Use the ASUM function to total labor costs by job, using a conditional formula based on the relevant period end dates and the parameters that define your definition of labor costs (cost type, category, etc). You can reference the period end dates by creating two "Prompt" fields for period end date from and to, and reference those prompt fields in the conditional part of the ASUM function you create. 
 Then apply a Conditional Print area to both the detail area of the report and the job number and description heading, so that your printing is suppressed unless the ASUM function returns something other than 0.00 for total labor costs for the respective job. 
 Hope this is helpful.

Sage Construction & Real Estate

JC report run based on jobs with labor cost for a specific PE date

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING