The Invoice Average Cost Variance Report allows you to catch cost changes that may result in a discrepancy between your Inventory Value Report and the inventory value in your General Ledger. It highlights differences between the average cost of a part coming into the system (receiving) compared to the average cost of the part going out (next time it is placed on a Sales Order after the receiving). It only prints when the average cost has changed and can be used to help track down differences between the Inventory Value Report and the General Ledger Inventory Account.
**This report can only be used 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 $2 is posted to the General Ledger. If you then enter the vendor's invoice for that receiving and the average cost increases to $3, then that $3 is being used to value your inventory when you run your Inventory Value Report. Item A would then display on the Invoice Average Cost Variance Report to help reconcile the discrepancy.
To print an Invoice Average Cost Variance Report follow the easy steps below.
1.Select Inventory > Invoice Average Cost Variance Report.
2.Choose to print the report for a specific branch by entering it in the Branch field, or leave this field blank to include all branches in the report.
3.Select to print the report for a specific warehouse by entering it in the Warehouse field, or leave this field blank to include transactions for all warehouses in the report.
4.Now choose to print the report for a Date Range or Sales Period by clicking on either option. Then enter the date range or sales period that you want to include in the report.
5.You also have the option to export the report to a spreadsheet by checking off the Export to CSV box. To print the report, leave this box unchecked.
6.Click the OK button in the bottom toolbar. From the printer window, select the appropriate printer and number of copies. You may also view the report on screen before you decide to print it by clicking the View button. This will open a preview of the report in a new window. Click Print to print the report. Remember to check that your printer is turned on and connected, and that you have inserted a sufficient amount of paper into the correct printer tray. You may also fax or email this report by clicking the Fax/Email button. For more help faxing or emailing the report, see the Fax/Email Reports page.
