...
Balance of Inventory report shows the item balance quantity, Average Cost Price (ACP) , and inventory amount/value as of the items on chosen selected date (Purchasing > Reports > Balance of Inventory):Inventory).
The report allows to see:
- Quantity — the current quantity of items on balance;
- Amount — the total inventory value calculated;
- Average Cost Price — the average cost per unit based on quantity and total amount.
Average Cost Price = Amount / Quantity (where amount is calculated as a result of operations and Quantity is a current balance of the item)
...
This field may be hidden, so use Change form option to add it in the table.
...