We are trying to configure free goods based on customer and division in our system. If a customer orders any material belonging to a specific division, he is entitled for a free good.
For this we created a new condition table based on customer and division and maintained condition records that if he orders 100 qty of any material in Division 10 that he is entitled for 1 qty of material X.
Now the problem is that at the time of creating the sales order if Material A is entered for qty 50 and Material B is for qty 50 then the system does not give free goods. However, if we enter Materail A for 100 qty it gives the free goods 1 qty of Material X. Similarly, for Mat B with 100 qty it gives Mat X as free goods.
The system is not adding up the quantities for the multiple line items to calculate the free goods.
Is there any way by which we can achieve this.