Inventory Revaluations worksheet needs division wise and Location wise report.
I’ve some Inventory in Location: A, Division: A and Project: A
another Inventeory item in location: B, Division: B and Project: B
So, I need to calculate how much (qty and value) asset (inventory) in the Division Location: A, Division: A and Project: A.
and then, I want to allocate some inventory item (qty and value) to expense in particular location, division and project.