Open Order Status 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

Impromptu File Name	Directory	Catalogue Name
Open_order_status_report.imr	C:\Impromptu Web Reports\Acquisitions	C:\Impromptu Web Reports\Acquisitions\Acquisitions-serials.cat

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

Report Description:

This report will list all orders for the selected order location, line type, line item status, invoice status, and fiscal year

Prompt	Type	Description
Order locations start with:	type in	Enter the first few characters of the ledger name
Select line type(s):	picklist	Select the line item types to include (use <CTRL> or <SHIFT> key to select multiples)
Select line item status:	picklist	Select the line item status to include
Invoiced or Not Invoiced	type in	Enter either "Invoiced" or "Not Invoiced" as required

Filters:

Order location code starts with location prompt value

Line item type equals type selected in prompt

Line item status equals status selected in prompt

Purchase order status not equal "Complete" or "Canceled"

Line item invoice status equals value entered in prompt

Fiscal period is current fiscal period

Sort Order:

Line item type (Ascending)

Data Elements:

Estimated run time:

15 minutes

Gail Sperling