Order List 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	Order List
Report Reference #	acq-200309-96
Revision Date	2004-03-17
Requestor	Debbie Tytko

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

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

Report Description:

This report will list orders for the various values specified in the prompts. Order type, line item type, order status and line item status can be specified in the prompts. An order date range and order location can also be specified.

Prompt	Type	Description
Select one or more order types:	Picklist	Select the order types to include in the report (to include all order types select the first order type, hold the shift key down and click on the last order type)
Select one or more line types to include:	Picklist	Select the line types to include in the report (to include all line types select the first order type, hold the shift key down and click on the last line type)
Select order status to include:	Picklist	Select one or more order status to include in the report
Select line status to include:	Picklist	Select one or more line status to include in the report
Enter start date:	Type in	Enter the earliest order date to include in the report
Enter end date:	Type in	Enter the latest order date to include in the report
Select order location(s);	Picklist	Select the order location(s) to include in the report
Enter N to only select OPAC records, Y to select all records:	Type in	Only change the default from "Y" to "N" if you want to exclude records that have been suppressed from OPAC (at the MFHD level)

Filters:

Order type equals order types selected in prompt

Line item type equals line types selected in prompt

Order status equals order status selected in prompt

Line status equals line status selected in prompt

Order create date between start and end dates entered in prompt

Order location equals order locations selected in prompt

OPAC suppressed mhfd records are excluded if the last prompt answer is not "Y"

Sort Order:

Vendor Name (ascending)

Order Create Date (ascending)

Data Elements:

vendor name (in header)
order number
order create date
author
title
status

Important Notes:

Estimated run time:

5 - 10 minutes

Report Developer:

Gail Sperling