acq:reports
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
acq:reports [2018/01/25 16:39] – tlittle | acq:reports [2019/02/06 15:24] (current) – tlittle | ||
---|---|---|---|
Line 1: | Line 1: | ||
====== Reports ====== | ====== Reports ====== | ||
+ | |||
+ | ===== Copies/ | ||
+ | ==== Copies remaining on true cancelled line items ==== | ||
+ | //Use:// Finds Acquisitions copies attached to line items with true cancels. Copies should have been deleted; if any found they should be deleted. | ||
+ | |||
+ | Source: Item | ||
+ | |||
+ | Filters: | ||
+ | Item->Is Deleted (Filter value=f) | ||
+ | Cancel Reason ID (in list) | ||
+ | |||
+ | Columns: | ||
+ | Line Item ID | ||
+ | PO ID | ||
+ | PO Name | ||
+ | Barcode | ||
+ | |||
===== Invoices ===== | ===== Invoices ===== | ||
+ | Reports can be found in Shared Folders-> | ||
==== Blank invoices ==== | ==== Blank invoices ==== | ||
Line 47: | Line 65: | ||
) limited_to_1048575_hits LIMIT 1048575 | ) limited_to_1048575_hits LIMIT 1048575 | ||
+ | |||
+ | ==== Completed Invoices showing Sum of Inv.Entries Amt Paid ==== | ||
+ | |||
+ | ==== Completed Invoices showing Sum of Inv.Items Amt Paid ==== | ||
===== Distribution Formulas, list of ===== | ===== Distribution Formulas, list of ===== | ||
Line 124: | Line 146: | ||
Display fields: Item→Barcode Item→Shelving Location→Name (" | Display fields: Item→Barcode Item→Shelving Location→Name (" | ||
+ | |||
+ | ===== Funds ===== | ||
+ | These reports are found in Shared Folders-> | ||
+ | ==== List of items purchased in a time period, by fund ==== | ||
+ | |||
+ | //Use:// Find a list of items that were purchased between two dates, filtered on the fund code. | ||
+ | |||
+ | **Report source:** Line item detail (Nullability enabled) | ||
+ | |||
+ | **Displayed: | ||
+ | |||
+ | * Line Item Detail→Fund Debit (none)→Amount | ||
+ | * Line Item Detail→PO Line Item (none)→Evergreen bib ID (none)→Simple Record Extracts(none)→Author | ||
+ | * Line Item Detail→PO Line Item (none)→Evergreen bib ID (none)→Simple Record Extracts(none)→Title | ||
+ | * Line Item Detail→Fund (none)→Code | ||
+ | |||
+ | **Filters: | ||
+ | |||
+ | * Line Item Detail→Fund Debit (none)→Create Time (Date) BETWEEN | ||
+ | * Line Item Detail→Fund→Fund ID (in list) | ||
acq/reports.1516898382.txt.gz · Last modified: 2018/10/11 20:15 (external edit)