How to use Group Lines for Discount based on some custom fields (Points Earned), not based on the It
We have a requirement where we want to Group the Lines for Discount based on the Custom field on the Sales Order Lines and need to sum as a Volume to give the discount as I understand Advanced Pricing does not allow to Group on any other fields except Quantity and Amount, the example is as given below, any help is really appreciated.
Example,
/*************************************************************************************************************************************************************************************************************/
We have a custom field called Line Points and every Sales Order Line has some value in it, the requirement is we want to have a Group Of Lines (All Items) Discount based on the Volume of these Points, say if Points are between 100 to 200, we give 10% Discount.