We are having an issue with one of our custom reports (i know), but we are also having an issue with discrepancies between the TLA field on Job tracker and the actual labor records for this job. If I pull the details from LaborDtl table my cost for labor is about $360K. But if I look at this field on Job Tracker, it shows the labor cost at $139K. I’m trying to understand any possible differences. Please note, this job only has the ‘0’ assembly on it, no subassemblies. Can anyone shed light as to possible issues?
@mmr70 What other tables are joined to LaborDtl? I had several jobs recently with from 2 to 20 extra JobOpDtl records that made my labors hours off from Job Tracker.
Oh those are some good questions…as I did not even consider JobOpDtl table and is NOT being used. The report is using the JobAssembly table mostly. I would have to send the whole query as there are several sub-queries in it.
@mmr70 If it is a query I can run in SSMS I can look at it today. I am already checking why I am getting LaborDtl records for no labor rate, but a burden rate.
