The formula we would like to use is Total Scrap expense /Total revenue.
Solution
If you have the Advanced Manufacturing bundle, the Production Loss Report – Detail which displays all production loss (scrap) details is available in Advanced Manufacturing > Manufacturing Reports > Production Loss Report – Detail.
However, without the AM, a report, or Saved Search to achieve this is still a system limitation.
Enhancement # 252217 – Manufacturing > Work Order Completion > Please expose Operation, Quantity and run time fields to transaction searches and/or reports
But for the formula can be added in search with some limitations of hard coding.
Formula:
- SUM(case when {account.number} IN (‘6200‘,’6220‘) then {amount} else 0 end)
- SUM(case when {account.number} IN (‘1090‘,’1100‘) then {amount} else 0 end)
- (SUM(case when {account.number} IN (‘6200‘,’6220‘) then {amount} else 0 end))/(NUllif(Sum(case when {account.number} IN (‘1090′,’1100’) then {amount} else 0 end),0))