What is the upcharge based on? Specific customer? Specific Part? Product Group?
I just played around with the “I Hate THIS Customer” route and defaulted a 5% upcharge on them.
You’d have to test this through the whole process in case there’s something I’m missing… but…
The Customer.DiscountPercentage field on the Customer record is set to only be positive. But I just played with changing the format in Extended Properties to allow negatives.
And it worked!
I created a Sales Order with this customer… No discount % displayed. Well, that’s because the OrderHed.DiscountPercentage ALSO doesn’t allow negatives. So, back to Extended Properties, changed OrderHed.DiscountPercentage to a format of ->9.99
That worked…
Had to go through that Ext. Prop. exercise again on OrderDtl.DiscountPercentage… but… if I then add a line item, the default -5% discount on the customer DID make it through to the line item… and DID work out mathematically on the line item price:
That’s as far as I took this.
Also struck me that you could do this with a Misc. Charge. More straight forward.
You can set that up to apply a set percentage:
Here you can see both of my above applied to this line item.
The only noticeable hiccup I see in my first approach above (using a negative discount) is that the Sales Order header “summary” shows the “discount” as a negative… even though the line item summary didn’t have that issue. The TOTAL is still correct, though. So, math is still mathing… but the display is not correct.
The Other side of all of this is how you’re presenting this TO THE CUSTOMER, vs internally. Internally this is all good. But you may not want your Sales Order Acknowledgement to have a misc. “I Hate You” charge. So, if you’re showing misc. charge descriptions, remember that could be customer-facing.
Same with the OrderAck showing a negative discount… may be confusing and/or appear shady.