How can I obtain the real costs (Material, Labor, Burden) of what I am invoicing for the job even if it has not yet been completed?
What tables can I use to obtain information?
Look in JobAsmbl table filtered for only AsmSeq 0 and columns that start with TLA and LLA
If you are looking to obtain real costs, the assumption is these products are not standard costed. If the top level part is standard costed, it will always transact as standard with the offset going to manufacturing variance.
Once non-standard costed jobs are invoiced you are better off using the InvcDtl.JC% fields. If jobs are completed, costs can still be added to them, so you want to make sure you run the Sales Gross Margin report in batch - e.g. 8 pm each evening so those InvcDtl tables update any additional costs until the job closes (e.g. late subcontract invoices). If the jobs close, then additional costs would just get lumped in manufacturing variances unless you reopen the job first.
Jenn