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
The PO Form (PO641000) has the line items within a groupheadersection.
This section is grouped by POLine.InventoryID, POLine.TransDesc, POLine.UOM and POLine.CuryUnitCost. The quantity is aggregated with the following expression: =Sum([POLine.OrderQty])
I would replicate the setup within this form to group the line items by inventory id. If the POLine.TransDesc is different for each record then remove the field from the group collection.
The PO Form (PO641000) has the line items within a groupheadersection.
This section is grouped by POLine.InventoryID, POLine.TransDesc, POLine.UOM and POLine.CuryUnitCost. The quantity is aggregated with the following expression: =Sum([POLine.OrderQty])
I would replicate the setup within this form to group the line items by inventory id. If the POLine.TransDesc is different for each record then remove the field from the group collection.
We use 3 different kinds of cookies. You can choose which cookies you want to accept. We need basic cookies to make this site work, therefore these are the minimum you can select. Learn more about our cookies.