Invoiced Orders Report 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	Invoiced Orders List
Report Reference #	acq-200110-64
Revision Date	2004-01-16
Requestor	Tim Sauer

Impromptu File Name	Directory	Catalogue Name
invoiced_orders(specify_ledger_date).imr	C:\Impromptu Web Reports\acquisitions	C:\Impromptu Web Reports\acquisitions\acquisitions-serials.cat

Web File Name ( login)	Web News Box
invoiced_orders(specify_ledger_date) (see sample)	TUG Reports and Cubes/Acquisitions/Invoice Reports

Report Description:

This report will list payment information by fiscal year (ledger) for each title that has been invoiced in the date range specified in the prompts, for the ledgers specified in the prompts and that have an order type matching the one(s) selected in the prompts.

Prompt	Type	Description
Select ledgers to display:	Picklist	Select the ledgers to include in the report
Enter start date	Type in	Enter the start date of the invoice paid date range to include in the report
Enter end date	Type in	Enter the end date
Select order types to include	Picklist	Select one or more order types to include

Filters:

Ledger equals one of the ledgers selected in the ledger prompt

Invoice paid date is between the start and end dates entered

Order type equals one of the types selected in the order type prompt

Sort Order:

Title (ascending)

Ledger (ascending)

Data Elements:

Title
PO Number
Order Status
Fund Name
Ledger name
Amount paid (CAD) (total for ledger at the title level)
Title Total (total amount paid for the title) (in footer)

Important Notes:

Amounts paid are reported in Canadian dollars. The conversion rate used to create the report may not reflect the exact rate used by TRELLIS and can cause slight discrepancies between the report and the on-line.

Estimated run time:

5 - 10 minutes

Report Developer:

Gail Sperling