acq:reports
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revisionNext revisionBoth sides next revision | ||
acq:reports [2022/02/10 13:34] – external edit 127.0.0.1 | acq:reports [2022/08/10 16:24] – tlittle | ||
---|---|---|---|
Line 3: | Line 3: | ||
This page includes reports created by different Evergreen consortia that might be useful. The templates have attribution in case you would like to contact that consortia to ask any questions about the reports. | This page includes reports created by different Evergreen consortia that might be useful. The templates have attribution in case you would like to contact that consortia to ask any questions about the reports. | ||
- | ===== Copies | + | ===== Report Sources |
+ | Beyond the list of Core Sources, the list of reports sources is very long. These are some suggested report sources to start with for Acquisitions reports. | ||
+ | |||
+ | * Debit from Fund | ||
+ | * EDI Account | ||
+ | * Fund | ||
+ | * Funding Source | ||
+ | * Invoice | ||
+ | * Invoice Entry | ||
+ | * Line Item | ||
+ | * Line Item Detail | ||
+ | * Purchase Order | ||
+ | |||
+ | ===== Sample Templates ===== | ||
+ | |||
+ | |||
+ | ==== Copies | ||
**Orphaned Barcodes**\\ | **Orphaned Barcodes**\\ | ||
//Created by PINES// | //Created by PINES// | ||
Line 34: | Line 50: | ||
{{: | {{: | ||
- | ===== Line Items ===== | + | ==== Line Items ==== |
===Line Items that have been invoiced but not received=== | ===Line Items that have been invoiced but not received=== | ||
Line 85: | Line 101: | ||
- | ===== Funds / Fund Debits | + | ==== Funds / Fund Debits ==== |
**Fund Debit SQL query**\\ | **Fund Debit SQL query**\\ | ||
//Created by PINES// | //Created by PINES// | ||
Line 135: | Line 151: | ||
- | ===== Purchase Orders | + | ==== Purchase Orders ==== |
- | ===== Claiming | + | ==== Claiming ===== |
===Claim ready items=== | ===Claim ready items=== | ||
Line 151: | Line 167: | ||
- | ===== EDI ===== | + | ==== EDI ==== |
**EDI-enabled POs ordered yesterday**\\ | **EDI-enabled POs ordered yesterday**\\ | ||
//Submitted by PINES// | //Submitted by PINES// | ||
Line 182: | Line 198: | ||
If you would like to try to use the spreadsheet, | If you would like to try to use the spreadsheet, | ||
+ | |||
+ | ==== Invoices ==== | ||
+ | |||
+ | **List Invoices by Date Range** | ||
+ | |||
+ | //Submitted by Bibliomation, | ||
+ | |||
+ | This report lists invoices with fund information; | ||
+ | |||
+ | Click the image to see an enlarged version. | ||
+ | |||
+ | Display Fields: | ||
+ | {{ : | ||
+ | |||
+ | Filters: | ||
+ | {{ : | ||
+ | |||
+ |
acq/reports.txt · Last modified: 2022/11/15 10:37 by tlittle