Navigator > Reports > Special Pricing > Price List Designer > Selections tab
Use the Selections tab to define the records to include in the report and the selections available when the report is run.
See also SP Price List Designer.
Note: Where criteria is only available in Accredo Saturn.
Select What, When, Who, Where dimensions for the Price list.
To include a selection in the report selections toggle
to
next to the selection.
What |
Select a range of Products or Stock Groups to obtain a Price List. If no Special Price applies, the regular price is used. The Price List will show prices for all Products in the selected range. You can filter the list. |
When |
Effective Date and Currency selections are always included in report selections. Dates saved in the report definition are handled as an offset from the System Date. |
Who |
Select a Customer or Job and Price Code for the Price list. When you select a Customer or Job, Who selections populate from Customer dimensions (for example, Sales Area or AR Category) or Job (for example, Job Group or JC Category). Who selections are based on dimensions setup in the Who grid. If Invoicing dimensions are available (for example, IN Category), select the relevant criteria as these are independent of the Customer and Job records. If selections are left blank, rules depending on that criteria will be ignored. For example, if you do not specify an IN Category 1, rules where IN Category 1 is one of the Who criteria will be ignored. |
Where |
Where selections are based on dimensions setup in the Where grid.
|
Filter Report |
The report may be filtered, for example filter on SpecialPriceApplied to only report records where the customer receives a special price.
|