Serial Receipts and Invoices Documentation

Staff Web StaffWeb: UG | UW | WLU
Libraries: UG | UW | WLU
Campus: UG | UW | WLU

Home TUG Statistics & Reports

Documents Contacts Search

Impromptu Report Documentation

Search Reports Status Database

Report Title	Serial Receipts and Invoices
Report Reference #
Revision Date	2010-10-20
Requestor	Jonathan Sutherland

Impromptu File Name	Directory	Catalogue Name
serial_receipts_and_invoices.imr	C:\Impromptu Web Reports\acquisitions	C:\Impromptu Web Reports\acquisitions\acquisitions-serials.cat

Web File Name ( login)	Web News Box
serial_receipts_and_invoices (see sample)	TUG Reports and Cubes/Acquisitions/Serial Reports/

Report Description:

This report will list serial receipts and invoice payment information for orders for the specified fund and date ranges. It is important to understand that receipt dates and invoice dates may not correspond exactly.

This report is useful for open monograph series purchase orders if the checkin issue contains a brief title of the title received.

NOTE: This report cannot be saved in an excel format.

Prompt	Type	Description
List ledgers that start with :	Type in	Enter the start characters of the ledgers to select from
Select a ledger	Picklist	Select the ledger to list funds for reporting
Select one or more funds for report:	Picklist	Select the funds to include in the report
Enter receipt start date:	Type in	Enter the start date of receipts to include in report
Enter receipt end date:	Type in	Enter the end date of receipts to include in the report
Enter invoice start date:	Type in	Enter the start date of invoices to include in report
Enter invoice end date:	Type in	Enter the end date of invoices to include in the report

Filters:

Purchase order fund equals the fund(s) selected in the fund prompt

Order status equals "Current"

Check in issue receipt date between the dates entered in the prompt

Invoice date between the dates entered in the prompt

Sort Order:

Fund name

Order number (ascending)

Title

Receipt date (descending)

Invoice date (descending)

Data Elements:

Order Number
Title
Publisher
Fund name
Received item
Receipt date
Invoice date
Invoice number
Amount paid (CAD)

Important Notes:

Order status is determined by PO Status, Line Status and special cancel vendors.

Estimated run time:

5 - 10 minutes

Report Developer:

Gail Sperling