Standard. This occurs when running Sales Gross Margin, Adjusted Costs flag equals true.
If you run it as false you get SGM with just the standard cost.
If you run it as true you get SGM with Actuals from the jobs but anything without a job you get 0 cost.
You get one or the other so we wrote a dashboard that gives best of both worlds now, but until the job is closed InvoiceDtl.JCUnitMtlCost is 0
Good to know.
Just about a year according to the jira date
But reality is longer than that. We wrestled with the 100%s in SGM for years only recently figured out what was doing it. If you see them in the SGM you can open and close the job and they will fill in.
Yeah man itās been on my to do since I got hired (almost 3 years ago).
We are making some headway. We are sticking with standard cost though. It takes a villageā¦
JobHead.JobClosed == true
So, the cost can still be changed since you have not run the Capture.
Well sure, we could open the job change stuff and close it again and the invoices would update.
this is that balance between āhow much admin do you want to do to maintain this,ā question that you brought up earlier right @jkane ?
Correct, your cost for that Job will not be locked until you run the Capture. What you are looking at is a snapshot in time. If you have a job that takes $100 in material and $100 in labor to produce 10, and then you ship and invoice 5, the invoice will reflect the Job cost at that point in time which should be roughly $150.
It is just semantics at this point, but the FINAL cost of the job does not happen until it is captured. As Epicorās documentation says, the SGA is just SIMULATING the PROJECTED job cost.
All I am trying to say is that if you run the SGA in the middle of the month before the capture process happens, and run around saying the sky is falling because of that point in time, you might have egg on your face at the end of the month after the capture happens.
Like you said before I love seeing how much thought Epicor did put into the costing portion of the system. It makes total sense that if you ship before capture or before the job is done you get partial costs allocated to the shipment and it looks really good and then the latter half of the shipment gets the complete cost which balances out the first partā¦
Super cool, and thanks for all the time youāve spent on this thread John!
I think on SGM John is correct, been a while. Thatās why many struggle to show the SGM on the AR Edit List, before posting, because it the MaterialCost, LaborCost, Burden get calculated at COS/WIP that is for Standard Costsā¦
I think Josh is thinking of the JC Job Costs, those get populated upon Job Closing (btw if you close a Job and then Invoice the JC Costs dont get populated, known Epicor bug), even if the Invoice is Posted and COS/WIP is complete. I think John is saying you run the risk if someone were to add more stuff to the Job or change Costs after invoicing, posting. So your trustworthy number is after the Job Closes, but if you know no one is adding anything then you could trust the JC Columns.
After the COS/WIP is captured. Until that happens, nothing is guaranteed. I also believe this is when Part costs get updated that are not Standard (Not 100% sure though).
Iām not even CLOSE to repaying what I have gotten here. I donāt think I ever will beā¦
Thanks @hkeric.wci and everyone.
You guys are always doing stuff with this type of confidence, I wish I could arrive here and understand the logic behind the scenes to know with such confidence that this is what they are doing it and then write a directive like this.
