We have a scenario in which we need to sum up the sales quantity for a particular material, date then to use this sum in all sales order line items:
for example: Material: ABC; Date: 01.11.2016
Sales Order Material Qty Sum(Qty) on 01.11.2016
1001 ABC 10 30
1002 ABC 10 30
1003 ABC 10 30
My question here would be how we can calculate the sum of quantity for material, date combination and to display the same at each line item
Thanks in advance.