In our company we deliver products at customer locations. Our sales Van pick all products from warehouse and deliver them to customers. We need a delivery list having all product's lines from all sale orders genrated today. For examlpe we sell 200 products today to 20 different customers. Now we have 20 delivery orders in warehouse. We want to genrate a report based on those 20 delivery orders and print all product lines in one report so our warehouse staff take all the products and load into van.
Example
Delivery order one have a product named "ABC" with quantity of 5 Units.
Delivery Order two have same product named "ABC" with quantity of 3 Units.
The final report sholud have this Product named "ABC" with quantity of 8 Units ( Sum of Delivery Order one and two and so on.)