Sage 100

We do scripts for weird pricing rules. 

For that one I'd suggest a PreTotals script to loop through lines, and add/update a /DISCOUNT line with the calculated amount.  Adjusting UnitPrice on lines gets complicated because users want things to update in real-time, and the Lines grid doesn't cooperate.  Working in large orders (lots of lines) would slow things down a lot too... where PreTotals doesn't have to loop through lines with each line edit.

We do scripts for weird pricing rules. 

For that one I'd suggest a PreTotals script to loop through lines, and add/update a /DISCOUNT line with the calculated amount.  Adjusting UnitPrice on lines gets complicated because users want things to update in real-time, and the Lines grid doesn't cooperate.  Working in large orders (lots of lines) would slow things down a lot too... where PreTotals doesn't have to loop through lines with each line edit.

Thanks for that technical-side feedback @Kevin Moyes - that gives them another way to look at the pricing (a /DISCOUNT line), which may open them up to some more flexibility.

We do scripts for weird pricing rules. 

For that one I'd suggest a PreTotals script to loop through lines, and add/update a /DISCOUNT line with the calculated amount.  Adjusting UnitPrice on lines gets complicated because users want things to update in real-time, and the Lines grid doesn't cooperate.  Working in large orders (lots of lines) would slow things down a lot too... where PreTotals doesn't have to loop through lines with each line edit.

The only possible issue to discuss in advance is that this approach (of having a /Discount line) makes a lot of reports and screen inquiries on sales by item/product line not work correctly - requiring allocations in reporting (similar to how the discount on the totals page is not taken into account on lots of screens and reports.)

"Danger Will Robinson"

Jeff F

Thanks for that technical-side feedback @Kevin Moyes - that gives them another way to look at the pricing (a /DISCOUNT line), which may open them up to some more flexibility.

We do scripts for weird pricing rules. 

For that one I'd suggest a PreTotals script to loop through lines, and add/update a /DISCOUNT line with the calculated amount.  Adjusting UnitPrice on lines gets complicated because users want things to update in real-time, and the Lines grid doesn't cooperate.  Working in large orders (lots of lines) would slow things down a lot too... where PreTotals doesn't have to loop through lines with each line edit.