I need a report that shows the unit cost in WIP by L-M-OH. Or what have others provided to their auditors that breaks this out per unit in WIP? Thanks
What about modifying Manufacturing -> Insights -> Report -> Costing Reports -> Open WIP Report to group by Step Type rather than by Work Order?
It sounds like you would need to customize the Open WIP report and add some type of logic to divide the columns by the to-date total to come up with a Unit Cost in each category in WIP. I don't think you can get exactly what you're looking for out-of-the-box.
Jennifer Pitt
Christy,
I'm working with the MFG GL Transactions view to try to get the information you need by adding a calculated column. Standby
Christy,
I just learned this new trick with Explorer Views... even after supporting the product for years, I'm still learning
You can create a calculated column using the MFG GL Transactions view located in Manufacturing, Insights, Explorer
Play around with these steps to see if it yields the correct numbers for you:
[TotalAmt] / (CASE WHEN Quantity = 0 THEN 1 ELSE Quantity END), [Quantity]
See attachment for results,
thanks,
Jennifer Pitt
Thanks Jennifer, I will give that a try to see if it gives what I am looking for!
Nice work Jennifer. I've noticed that the calculated columns run slower than modifying the view in SQL, but it's nice that you can make the change yourself instead of having to call IT.
Christy, just make sure you tie-out the totals to your existing report. There could be some things that cause the two reports to be different like:
*Community Hub is the new name for Sage City