User Tools

Site Tools


acq:reports

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
acq:reports [2018/01/25 16:39] tlittleacq:reports [2019/02/06 15:24] (current) tlittle
Line 1: Line 1:
 ====== Reports ====== ====== Reports ======
 +
 +===== Copies/Items =====
 +==== 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->Templates->PINESacqadmin->Invoices.
  
 ==== 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 ("Shelving loca Display fields: Item→Barcode Item→Shelving Location→Name ("Shelving loca
 +
 +===== Funds =====
 +These reports are found in Shared Folders->Templates->PINESacqadmin->Funds.
 +==== 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)