The Invoice Price Variance Report shows the variance between the invoice price and the purchase price for all inventory and work in process related invoice distributions. Payables records invoice price variances when the invoices are matched, approved, and posted.
The report includes invoice Entry Types Adjustment, Entry, and Reversal.
The invoice price variance is the quantity invoiced multiplied by the difference between the invoice unit price and the purchase order unit price.
If the invoice price and the purchase order unit price are in the same currency but the exchange rates differ, the exchange rate variance is also displayed in this report. For example, if the report displays an invoice price variance of -9.5 and an exchange rate variance of -6, the total invoice price variance of -9.5 includes the exchange rate variance of -6.
Payables records invoice price variance only when you have inventory or work in process related invoices. Use this report only if you use Inventory by itself or with Work in Process.
In the Cost and Period Close Reports (for Inventory) or Submit Requests windows, select Invoice Price Variance by Supplier Report in the Name field.
Enter the beginning and ending purchasing categories.
Enter the beginning and ending supplier numbers.
Enter an accounting period to restrict the report to a specific period.
Enter the decimal precision for quantities on the report.