Skip to main content
OCLC Support

Why do I retrieve duplicate rows when I run a report in the Acquisitions Universe


  • Duplicate rows are displayed in reports run in the Acquisitions Universe
Applies to
  • 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 :

  1. Add  'Budget Transaction Status = 1' to the query filter
Additional information


Page ID