Invoices > amount specified 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	Invoices > nnnnnn
Report Reference #	acq-200702-101
Revision Date	2007-02-27
Requestor	Debbie Tytko

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

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

Report Description:

This report will list invoices with a total invoice amount in $CAD > the amount specified for the date range and ledger specified in the prompts.

Prompt	Type	Description
List ledgers that start with:	Type in	Enter the start characters of the ledgers to select from
Select ledger for report:	Picklist	Select the ledger to include in 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
Invoice total > (e.g. 1000)	Type in	Enter the total CAD amount to report on (do not include $ or commas)

Filters:

Ledger equals the ledger selected in the ledger prompt

Invoice paid date is between the start and end dates entered

Invoice total in CAD greater than the amount specified in the prompt

Sort Order:

Ledger (ascending)

Data Elements:

Ledger name (in header)
Invoice Date
Invoice Number
Currency
Total (Foreign)
Total (Cad)
Vendor Name

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