Inventory Transfer PLD total quantity
We are trying to add total quantity to the standard Batch report PLD at BTN3 level for inventory transfer. We are using colsum() for a column that is in the repetitive column. However, It is not adding the total quantity it is only adding partial quantity. Any advise?
Nagarajan K replied
Try this solution:
1. Create new header level at inventory transfer to get total quantity.
2. Run below FMS and assign this query above UDF field.
SELECT SUM(T1.[Quantity]) FROM OWTR T0 INNER JOIN WTR1 T1 ON T0.[DocEntry] = T1.[DocEntry] WHERE T0.Docentry = $[OWTR.Docentry]
3. Edit PLD to get UDF field to get total quantity.
Over all view: