- Duplicate rows are displayed in reports run in the Acquisitions Universe
- WMS Reports Designer
When a report is run in the Acquisitions Universe, the report may select one or more lines for each budget transaction. Depending on the output fields selected, the lines may be aggregated or displayed as separate lines.
For example, separate lines are output for both active (contains encumbered or expended items/costs) and non-active (does not contain encumbered or expended items/costs) budget transactions.
To pull out only the current active records :
- Add 'Budget Transaction Status = 1' to the query filter