Doorgaan naar de website
OCLC Support

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 :

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

x

Page ID
36891