Sage 100

Sales Order, pick a customer with a price level, type in the item#. Enter a quantity of 20 then override the calculated price level price to .01.  Hit enter until you are on the next line. Then, go back to the item#, change the quantity from 20 to 50 and it will automatically change the price from .01 to the customers assigned price level pricing.

Is there any way to disable the recalculation of the price level price when the quantity ordered changes if the unit price is overridden? I understand the price level logic executes when the quantity ordered is entered, so if the quantity ordered later changes, the price gets re-calculated.  Can this logic be disabled by line item in off-the-shelf Sage 100, or would this perhaps require a UDF check box and a script?

------------------------------
Doug Higgs
Midwest Commerce Solutions, Inc
(312) 315-0960
Assistant to the Traveling Secretary
------------------------------

I'm not sure of an off-the-shelf way to do this but the SO_SalesOrderDetail table has a PriceOverridden field so in theory, you should be able to use a script on an appropriate event to detect if the PriceOverridden has been set to Y and if so, clear the value from the detail's PriceLevel field (this is what's inherited from the customer's price level but can be cleared on a line by line basis).  I believe this might work but if it doesn't I guess the other way to do it would be to use a detail post read script to store the current unit price and maybe the price overridden value and then use a pre write script to check for a condition where the unit price was recalculate vs being changed by the user (probably will need a script on either pre or post validate of the unit price to see if you can isolate if changed by the user).

------------------------------
David Speck II
Tennessee Software Solutions
------------------------------

@David Speck II Thank you!  Great options for me to research.​

------------------------------
Doug Higgs
Midwest Commerce Solutions, Inc
(312) 315-0960
Assistant to the Traveling Secretary
------------------------------

Original Message:
Sent: 04-17-2021 07:10
From: David Speck II
Subject: Manually Changing a Price with Customer Price Levels

I'm not sure of an off-the-shelf way to do this but the SO_SalesOrderDetail table has a PriceOverridden field so in theory, you should be able to use a script on an appropriate event to detect if the PriceOverridden has been set to Y and if so, clear the value from the detail's PriceLevel field (this is what's inherited from the customer's price level but can be cleared on a line by line basis).  I believe this might work but if it doesn't I guess the other way to do it would be to use a detail post read script to store the current unit price and maybe the price overridden value and then use a pre write script to check for a condition where the unit price was recalculate vs being changed by the user (probably will need a script on either pre or post validate of the unit price to see if you can isolate if changed by the user).

------------------------------
David Speck II
Tennessee Software Solutions
------------------------------