Hello All,
I have a condition where I have been looking to customize a report related to production order.
The scenario is there is an stock termed as “Item FG” which is required to be produced. The materials required to produce this are “Item A1”, “item A2” & “Item A3” and so on.
Item FG has 2 attributes namely:
Target Weight that has an integer value mentioned as 5 and
Desired Mass per Run has an integer value mentioned as 12500
Similarly,
Item A1, A2 & A3 have attributes namely:
Additional Run that has an integer value mentioned as 1 (for Item A1), null (for Item A2), 3 (Item A3) respectively.
Now I would like to customize a report where I would like to calculate & display one of the value under Item A1 as:
if Additional Run of Item A1 is not null then it should calculate the formula as:
(Quantity of A1/Production qty of Item FG to produce/value of Desired Mass per Run attribute of Item FG/value of Target Weight attribute of Item FG)*Additional Run attribute of raw material Item A1.
Kindly let me know how can we apply the formula?
Thanks in advance.