...
Acquisitions Reports | ||||||
CUL Report Code and Link to Query | Last Updated | Report Name | Description | ~Time to run | Related JIRA REP Issues | Setup |
---|---|---|---|---|---|---|
CR109 | standing order purchase orders | daily report run by acquisitions staff to review firm purchase orders against standing purchase orders | REP-283 | np55 | ||
CR111 | duplicate orders on ISBN | used by Acquisitions to identify recent orders that duplicate already held volumes or that lack standard numbers and require manual searching | REP-281 | np55 | ||
CR123 | 9/22/21 | open_orders | provides a list of open purchase orders and their encumbrance and/or amount paid, broken down by purchase order lines | REP-283 | nb299 | |
CR134 | 10/26/2021 | appr_invoices_bib_data | This query provides the list of approved invoices within a date range along with vendor name, invoice number, fund details and purchase order data. It also provides some Bib data, which will be more complete after the release of Folio Kiwi scheduled for November 2021. The elements that will be added are commented out in the main query. | REP-39, REP-83, REP-287 | nb299 | |
CR195 | 1104/14/2213/23 (revised) | expense_transfer | This query is a customization of CR-134 (paid invoices with bib data) for the purpose of identifying expenditures that can be transferred from unrestricted funds to restricted funds. | ~20 seconds | NEW | jl41 |
...