Fund Transaction 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	Fund Transactions
Report Reference #	acq-200202-57
Revision Date	2002-06-03
Requestor	TUGacq

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

Web File Name (login)	Web News Box
fund_transactions (see sample) fund_transactions-commitments (see sample) fund_transactions-expenditures (see sample)	TUG Reports and Cubes/Acquisitions/Fund Reports

Report Description:

This report will list transactions against an allocated fund (blue triangle symbol). There are also versions that will list only commitments or only expenditures. It is possible to find out the title associated with the commitment or expenditure by drilling through to another Impromptu report.

This report is designed to be viewed on the screen and not printed.

Prompt	Type	Description
List ledgers that start with:	Type in	The next prompt will list ledgers that start with the string entered here
Select a ledger:	Picklist	Select a ledger (fiscal year) from the dropdown list (ensure that the fiscal year matches the date range entered in the next prompts)
Enter start date (yyyy-mm-dd):	Type in	Enter the start of the date range for the transactions to include in the report
Enter end date (yyyy-mm-dd):	Type in	Enter the end of the date range
Select one or more funds:	Picklist	Select one or more funds to include in the report from the dropdown list

Data Elements:

Reference No

Transaction date

Transaction amount – in Canadian dollars

Fund Name

Ledger Name

Transaction type (fund transactions.imr only)

Note (fund transactions.imr only)

Operator Id (fund transactions.imr only)

Invoice number (fund transactions – expenditures.imr only)

PO Number (func transactions – commitments.imr only)

Filters:

Transaction date is between the date values entered in the prompts

Fund name starts with the string entered in the fund name prompt

Ledger equals the ledger selected in the ledger prompt

For fund transactions commitments.imr the following filter also applies

Transactions type equals commitment

For fund transactions expenditures.imr the following filter also applies

Transactions type equals expenditure

Sort Order:

Transaction date (ascending)

Important Notes:

For "commitments" the "Reference No" refers to the purchase order number. For "expenditures" the "Reference No" refers to the invoice number. To find the title associated with the commitment or expenditure right-click on the Reference No for the amount, select "Drill" and then select the "fund transactions drill – invoices.imr" if the amount is an expenditure or the "fund transactions drill – order.imr" if the amount is a commitment.

A second Impromptu report will then run and list;

Fund name
Order number
Title
Author
Invoice number (for "fund transactions drill – invoices.imr" only)

Estimated run time:

5 minutes

Report Developer:

Gail Sperling