Orders Estimated Price 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	Orders with estimated price > $nn
Report Reference #	acq-200505-99
Revision Date	2005-05-03
Requestor	TUG Acq

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

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

Report Description:

This report will list orders for the selected ledger and order type(s) if the estimated price is greater than the amount specified.

Prompt	Type	Description
List ledgers that start with:	Type in	Enter a string that the ledger or ledgers to select from include (case sensitive)
Select a ledger	Picklist	Select a ledger from the dropdown list
Select order types to include:	Picklist	Select one or more order types from the dropdown list
Select orders with estimated price > :	Type in	Enter the lowest estimated price to include in the report (based on the foreign currency amount, not the CAD converted price)

Filters:

Ledger name equals the ledger selected in the prompt

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

Line item unit price is greater than the amount entered in the prompt

Sort Order:

none

Data Elements:

PO Number
PO Type
PO Status
Unit Price
Currency
Ledger name
Fund name
Title

Important Notes:

Estimated run time:

5 - 15 minutes

Report Developer:

Gail Sperling