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:

1. In MFG GL Transactions, press Alt+F3 to Edit Columns
2. Click Add Column, and call the column AmtPerQtyIn the Calculation enter 

[TotalAmt] / (CASE WHEN Quantity = 0 THEN 1 ELSE Quantity END), [Quantity]

1. Click OK
2. Click the Enable Summation icon and find the new calculated column called Column 1 and then click on the summation icon.  Click Sum and OK. Do the same for the column AmtPerQty and click OK
3. Click on the Enable Grouping, and drag and drop the Journal column, and then Work Order column in to the grouping area.
4. Refresh the view to see the data

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!

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:

1. Closed vs. open work orders
2. One report pulling from work order summary tables vs. the other report pulling from work order transactions and the two being out of sync
3. Other stuff that I'm not thinking of