Why do I retrieve duplicate rows when I run a report in the Acquisitions Universe
Symptom
- Duplicate rows are displayed in reports run in the Acquisitions Universe
Applies to
- WMS Reports Designer
Resolution
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
Additional information
x