We are manufacturing make-to-order products and all our products are customized every time they are ordered. So every time an order is confirmed, a work order is generated. At the end of the week, we would like to compare the total of sales order value closed and also the total of valuation rate of each manufactured item.
How to generate a report in which each item of the sales order is linked with its work order and valuation rate