| Oracle® Retail POS Suite 14.1/Merchandising 14.1.1 Implementation Guide Release 14.1.1 E63051-02 |
|
 Previous |
 Next |
| Oracle® Retail POS Suite 14.1/Merchandising 14.1.1 Implementation Guide Release 14.1.1 E63051-02 |
|
Previous |
Next |
During import of a DiscountRule, a quantity must be specified when an Any qualifier is given for either the source or target. These two new quantities are added as columns to the PriceDerivationRule (RU_PRDV) table:
QU_AN_SRC QU_AN_TGT
When the Any quantities for source or target are zero, Point-of-Service considers this to mean that all sources or targets are required. When the Any quantities for source or target are one or greater, that quantity is the minimum required for the source or target to activate the discount. When the Any quantities for source or target are -1, any combination of sources can participate in the rule. Point-of-Service considers -1 to mean that any combination of sources can participate in the rule as long as the total quantity meets the threshold value.This is only applicable for Multithreshold discount rules.
When left unspecified during import, sources and targets are imported as Any 1. The Any quantity should not be confused with the quantity specified by the source or target. For example, the Any quantity can be set to 1, but the source quantity can be set to 3. Three items that match the source criteria must exist before that one source will meet the Any 1 qualification.
When a discount rule contains the Any option, and the number of available choices of sources or targets exceed the any quantity, the system must determine how to sort the items in order to know which items participate in the discount rule. The sorting algorithm varies based on the discount rule and whether or not the items participate as both sources and targets within that rule (that is, whether the sources are discounted):
When the same items participate as both sources items and targets (that is, whether the sources receive the discount), the system sorts the source items from most expensive to least expensive to determine which source items should participate in the discount rule.
When the same items do not participate as both sources and targets, the system sorts the source items from least expensive to most expensive and chooses the first options until the any quantity is met.
Targets are always sorted and chosen from most expensive to least expensive and chosen in order, unless the rule specifies BuyNofXgetLowestPricedXatZ%off, in which case the least expensive target items are chosen first.
