Has anyone come across a report that shows the inventory in and outs which includes both quantity and the cost? As I couldnt find any relevant reports in the system, and have been trying to create 1 using the confirmation journal as the base, but it doesnt seem sufficient as I couldn't get to match it to get the inventory valuation for each detail line.
Would appreciate some guidance on creating an inventory report that could report the movement with quantity and cost involved, also if possible I would like to match the supplier and customer invoices for each In and out. Hope that someone could share some ideas with me. Thanks