Item Wise Weekly Report of Sales Order & Valuation Rate

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

Hi MonD,

Use a Script or SQL Query report, start with the Sales Order and pull in the Valuation Rate of the item. Alternatively, if you are using the Sales Invoice report and you have turned on perpetual inventory, the COGS entry is the sum of the valuation rate of the items that have been invoiced.

Hope this helps.