Script to Return lowest price

Does anyone have a script for over-riding the price on a sales order with the lowest price? Some of our customers get product line discounts that result in a lower price than the current promo price. It might be like that for every SKU in the product line or just one or two, so customer/item contract price is too big a chore to consider doing.

  • 0

    I have done pricing scripts before based on external tables and UDT's. One could also evaluate each pricing technique using MAS tables after the quantity is entered and select the lowest price.  Basically, ignoring the initial result and redoing the price selection. Depending on which methods you need to check, the script could be complex.

  • 0 in reply to connex

    Thank you, sir, but how do you mean to 'redo' the price selection? Is there a way in script to check a single pricing type? Like "what is the promo price? what is the customer/item contract price" etc ...?