Hey everyone,
I am making a Query to show all job cost. I have labor and material cost but cannot find the Subcontract cost. Does anyone know if there is a table related to the job that holds the information or do I have to pull the info from the Purchase order?
Hi Jose,
Have you looked at the JobAsmbl table? It has TLASubcontractCost and LLASubcontractCost fields. TLA is This Level Assembly and LLA is Lower Level Assemblies. A calculated field can be used to total these.
4 Likes
@todd.mcgregor Thanks a lot. You made this query much simpler!