Does anyone here compare Actual cost to Standard Cost, and how? I’ve been working on a BAQ that would take a BOM and try to sum up the Actual cost on the Last job vs Standard. Is there a better way to do this?
We do a margin analysis that uses InvcDtl and PartCost to compare std/avg cost (partcost), to job cost (invcdtl TLA fields) to revenue on that invoice line(invcdtl).
You don’t need to sum it up if your job has all the costs in it. JobAsmbl has the totals at any point in the job processing including labor and materials used so far. you can just join that with PartCost.
1 Like
Are those subject to problems when transactions aren’t done in the right order?
Yes, they would be, so you would need to apply some logic to the numbers based on your synchronous or asych processing order. And off the top of my head, I’m not sure when they get updated - clocking out of an operations, or reporting qty… I’d have to test it again.
Since we’re a custom job shop, we really dont’ look at this data until a job is marked complete anyway… and then we’re looking at it against revenue on an invcdtl line so we can see margin. But the Invcdtl line also has the “TLA” and “TLE” fields so we can see actual and estimated costs AND see the estimated and actual margins.
What is the TLE based on? Is it based off of standard?
On parts with a MOM/BOM, it’s based on the ‘Get Details’ of that job. So it’s job-qty based material and labor costs based on the ‘qty per parent’ and labor standards for that MOM.
First thing to mention, all of the non-standard cost fields in PartCost are based on the value that has moved into inventory. It does NOT take into account parts shipped from jobs.
Second, the PartCost record has a CostID field so you can have many PartCost records (default is the ID: ‘1’). So you might be able to run a BAQ of your last job cost (or average or whatever) and populate a new PartCost Record. Now you have all of the data to compare your Standard to Last or whatever.
Mark W.
1 Like
So im only able to find the TLA and the TLE in jobasmble. is the TLA and TLE only for that level, or for all levels up to that point?
For the assembly on that row. If you want the whole job and have multiple assemblies in a job, you’ll need to sum to the job# level.