Sometimes for business reasons, when we create a Purchase Order we might list some Inventory ID’s multiple times.
Eg
Inventory ID XYZ
Line one has an order for 2
Line two has an order for 3
Line three has an order for 1
We would like to show in a report (done in Report Designer) that sums these rows and shows only one row.
So in the above example we would have only one line appear for XYZ with order qty of 6.
Can anyone suggest how we do this?
Best answer by ejmillar
View original