Hi All,
How to take the stock report for finished goods based on receipt from production date. This report should contains available finished goods QTY and FG value based on production completed date.
EX.
FG001 manufacturing cost is 100 and stock is 30. Based on the report completion date it should be categorized, last 30 days production count is 10, last 30-60 days production count is 20(only for available QTY).
Item code qty(0-30 days) FG value(0-30) qty(30-60) FG value(30-60) Qty sum FG value Sum
FG001 10 1000 20 2000 30 3000