Maximum discount by line item during SO Entry

Question

My client has hundreds of product lines with corresponding vendors that allow maximum discount percentages on their products. For example product line AAA has a maximum discount of 30%, where product line ABA allows a maximum discount of 35%. 
 With so many product lines, salesmen need reminders (?) or restrictions during SO Entry on how much discounts they can apply to line items based on maximum discount allowed by vendor. What would be the best way to achieve this objective? 
 Thank you in advance, 
 KVO

T-Storm · Accepted Answer

If the discounts are "standard", price levels offer a systematic approach. There's also a warning that can be set if a profit margin falls below a predefined level (global, not product line). If the discount is not standard (i.e., if the max discount is 30%, but it's really up to the salesperson) one option might be a UDF added to the SO line showing the max allowable discount. Although it could not be "enforced" systematically, you could write an exception report to identify any time a salesperson violated the maximum. You could even use the UDF to "override" the actual SO and Invoice document (or provide a warning on the forms) if the max discount is violated. Hope this helps.

Sage 100

Maximum discount by line item during SO Entry

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING