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:43] – 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 126: | Line 148: | ||
| ===== Funds ===== | ===== Funds ===== | ||
| + | These reports are found in Shared Folders-> | ||
| ==== List of items purchased in a time period, by fund ==== | ==== 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. | //Use:// Find a list of items that were purchased between two dates, filtered on the fund code. | ||
| Line 132: | Line 156: | ||
| **Displayed: | **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→Fund Debit (none)→Amount |
| - | * Line Item Detail->PO Line Item (none)->Evergreen bib ID (none)->Simple Record Extracts(none)->Title | + | * Line Item Detail→PO Line Item (none)→Evergreen bib ID (none)→Simple Record Extracts(none)→Author |
| - | * Line Item Detail->Fund (none)->Code | + | * Line Item Detail→PO Line Item (none)→Evergreen bib ID (none)→Simple Record Extracts(none)→Title |
| + | * Line Item Detail→Fund (none)→Code | ||
| **Filters: | **Filters: | ||
| - | | + | |
| - | * Line Item Detail->Fund->Fund ID (in list) | + | |
| + | * Line Item Detail→Fund→Fund ID (in list) | ||
acq/reports.1516898636.txt.gz · Last modified: 2018/10/11 20:15 (external edit)