Skip to main content
OCLC Support

Acquisitions budget entity

Find information about the Acquisitions budget entity in Amlib OpenReports.

Skills outlined in this Sample are revising those used as last time as well as:

  • Setting the currency Format
  • Setting a Sum Function
  1. Access the Report Designer TAB
  2. Select New from the buttons
  3. The Edit Report Window will display
  4. Enter a Report Title in the Report Title section. For the sample “Budget 2014 – Committals and Actual expenditure
  5. Enter a Group since we want to find it later easily – for example Budget
  6. Enter a Sub Group – for example 2014
  7. Choose Report Type from the Drop-down options (Table is default):
    • Table – set out in rows and columns (select for the sample)
  8. Select Orientation
    • Portrait (select for the sample but depends on how many Display fields are selected)
  9. Ignore Show sql
  10. Show details: For this sample Report enter
    • All:  Enter the Top value required – for example 10
  11. Show Sub totals: Have this ticked if a Group exists, where subtotals are required
  12. Show total: Have this ticked if main totals are required
  13. Tick Private: Optional - leave this unticked.
  14. Show header on first page: For our sample tick this one if required
  15. Show header on next pages: This is your choice. But for now leave this unticked

Display Fields

  1. Select the Acquisitions Budget Entity
  2. Select required Data Field/s from the Entity and drag and drop to Display – in our sample, we included Budget Group Level 2, Budget Group Level 3, Budget Account, Budget Actual Amount and Budget Commit Amount. It depends on which Data Fields are to be displayed
  3. It is possible to change the Money fields for Actual and Committed Amounts to show as Dollars, by changing the Format to $ <space>0.00 ($ 0.00). Ensure that the Function is set to Sum if using Subtotals and Totals

Group Fields

We selected Budget Group Level 1 as the Group Fields as each Location is a different Level 1. If your Budget has only 1 Level 1 then it maybe more interesting to Group by Budget Level 2 for example


  1. Drag and drop Budget Financial Year to the Filter Column. Select Equal and use the Drop-down options to select the correct year
  2. If only wanting Committals outstanding for example, it is possible to Drag and drop Acquisitions Budget Commit Account to the Filter column. Select Greater than (>) and enter 0.00


It is useful to have an Order and often depends what the Group is to make it a logical sequence


Select Preview to view the Report



Once the Report is successful, select Save to be available in the Report Viewer

Note: Try adapting this Report by using sequences or combination of Accounts

Report on the most recent Account expenditure for example

Try using a Chart to display the Budget allocations for the year!