Invoice Price Variance by Supplier Report
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.
Prerequisites
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.
Report Submission
In the Cost and Period Close Reports (for Inventory) or Submit Requests windows, select Invoice Price Variance Report in the Name field.
Report Parameters
Categories From/To
Enter the beginning and ending purchasing categories.
Suppliers From/To
Enter the beginning and ending supplier numbers.
Period Name
Enter an accounting period to restrict the report to a specific period.
Sort By
Choose one of the following options:
Supplier
| Sort the report by supplier.
|
Category
| Sort the report by purchasing category.
|
Item
| Sort the report by purchasing item.
|
Invoice Date
| Sort the report by purchasing invoice date.
|
Dynamic Precision Option
Enter the decimal precision for quantities on the report.
See Also
Submitting a Request