Use this report to view items received at one average cost but sold at another (the next time the part is on a sales order after the receiving). You can use this report to help determine why you may have discrepancies between your Inventory Value Report and the inventory value in your General Ledger.
This report applies only if you are using your C2 average cost to post to the General Ledger and as the cost on your Inventory Value Report.
For example, if you receive item A with an average cost of $2 and sell it to a customer, then that $2 amount posts to the General Ledger. If you then enter the vendor's invoice for that receiving and the average cost increases to $3, the system uses $3 as the inventory value when you run your Inventory Value Report. Item A would then display on the Invoice Average Cost Variance Report, allowing you to reconcile the discrepancy.
Go to Inventory > Invoice Average Cost Variance Report.
- Branch: The branch on which the report will be run. Leave blank to include all branches.
- Warehouse: The warehouse on which you want to report. To report on all warehouses, leave blank.
- Period: Choose whether to run the report on a specific range of dates or a calendar period.
- If you select Calendar Range, then choose the Start Date and End Date.
- If you choose Sales Period, type the period in the format MMYY.
|Qty-Shp||The count of the items shipped.|
|Inv-Avg-Cost||The average cost at which the product was sold.|
|Rcv-Avg-Cost||The average cost you paid the vendor when the product was received.|
|Variance||The difference between the Invoiced cost (what the customer paid you) and the Received cost (the cost you paid the vendor)|