Sales Price Variance Report window
The Price Variance Report shows the variance between the base price of a range of items and the actual selling price. A variety of sort options make this report a useful tool for evaluating salesperson performance and sales pricing effectiveness.
NOTE: Items that were imported from QuickBooks® will not show an accurate variance until you post transactions in Denali. |
Include
Use these check boxes to specify the type(s) of transactions you want to include in the report. The default is that both check boxes are checked.
Orders
These are transactions that were entered in the Sales Order Entry window.
Register Sales
These are transactions that were entered in the Sales POS Register window.
Transaction Type
• Posted: include only posted transactions from the sales history file in your report. If you select this option, then the Order Batch start and end range will be unavailable.
• Unposted: include only current unposted transactions.
Start and End Ranges: Order Batch, Sales Register, Item, Salesperson, Invoice/Receipt Date, and Location (MLI only)
These boxes allow you to define the range of items to include on the report. You can include a single item by entering the same value in both boxes. These settings will include all items that meet the remaining criteria in the window. The defaults for
Order Batch,
Sales Register,
Invoice/Receipt Number, and
Salesperson are
Start and
End. The default for the
Date Start is the first date of your
fiscal calendar, and the default for the
Date End is the current system date.
If you left the Orders check box unchecked or selected Posted as the Transaction Type, then the Order Batch range will be unavailable.
Date Range
From the drop-down, select a
predefined period to run the report for.
Related Topics
Published date: 11/22/2021