Change sort values in DiscountCalculationMethod

Hi,

We are on Xstore v17.0.5, we want to change the sorting of Discounts that gets applied in a transaction. For example:

1. Add an item in sale transaction
2. Add a lineItem discount of PROMPT_AMOUNT with sort_order as 70
3. Add another lineitem discount of PROMPT_PERCENT with sort_order as 80
4. Add another lineitem discount of PROMPT_AMOUNT with sort_order as 50
5. Add another lineitem discount of PROMPT_PERCENT with sort_order as 60

The sort_order values are defined in table DSC_DISCOUNT and PROMPT_PERCENT and PROMPT_AMOUNT are the calculation_mthd_code in table DSC_DISCOUNT.

Now, ideally the Xstore should apply the discounts as per sort_order i.e. discounts with sort_order 50, 60, 70 and lastly 80.