Whole Order Discount
Overview:
Your company offers a discount on a Sales order according to a tiered discount structure. When an order qualifies for a tiered discount, you would like the line item unit price to be adjusted to reflect the earned discount price.
Proposed Solution:
A Flexibility script will be written to analyze a sales order and apply the appropriate discount to all line items.
Detail of Requirements:
A Flexibility script will be attached to the standard Macola OE 'Enter Orders' screen.
The discount tier to be applied to each line item is determined by totaling the quantity ordered for all line items. The required purchase to earn a tiered discount are as follows:
| Tier | Requirement |
| Level 1 | 1 to 9 total pieces |
| Level 2 | 10 - 149 |
| Level 3 | 150+ pieces |
Every item for which a discount tier applies will have a Price Code Type 3 (By Customer Type and Item Number) set up in the OE Price Code file.
The specific price for each quantity level will be entered in Level 1,2 and 3.
When the total quantity purchased attains a discount tier:
- The line items will be re-priced according to the earned level for the customer type.
- The Order Header totals will be adjusted to reflect the new line item pricing.
- An OE audit record will be written for each transaction
The processing will occur when the user completes an order and returns to the Order Header screen. This will be a background process that will be transparent to the user. No confirmation or prompts will occur.
| General Information | ||
|
|
||
|
||
| Languages | Exact Product Line | |
|
|
||
|
|
|
| Development Platform | Modules Impacted | |
|
|
||
|
|
|
| Database Supported | Version | |
|
|
||
|
|
|
| Industries | Horizontal Focus | |
|
|
||
|
||