Report Description
This report pulls many fields from the PO table (Z68) and it includes payment data per PO. It sums all payments per fiscal year for each PO with a maximum of three years of payment history and counts the number of FY invoice transactions. It can serve serials review, data clean-up projects, and statistics on library purchases for external reporting. It includes latest fund transaction (invoiced) and latest encumbered transaction. The report does not limit by order status, instead allowing you a complete "look" at all your orders. It is particularly useful for continuation orders. Once the data has been pulled it is available in Task Manager as a .csv file, which can be opened in Excel or imported into Microsoft Access for assorted manipulation.

Selection criteria
Order type = S and/or Order type = O; or Order type = M (note that order type = M would yield a huge report and may need additional criteria to limit it)

ISSN or ISBN

Display/Listing: Columns are listed below.
ADM_NO
PO_Number
GON
ISSN/ISBN
Title
Latest_Fund_Transaction
Latest_Enc_Transaction
FY07_Transactions
FY07_Payments
FY08_Transactions
FY08_Payments
FY09_Transactions
FY09_Payments
Vendor_Name
Order_Status
No_of_trans
No_of_inv_trans
Sub_Lib
Material_Format
Material_Type
Acq_Method
Library_Note
Vendor_Code
Vendor_Ref
Renew_Date
ERM_ID
Order_Group
Order_Type
VendorNote

Final Report
located in Task Manager. After transferring to the local file, follow the path to the Aleph print file, for most users it would be:
C:\AL500_18.01_CP_LIVE\ACQ\files\MAI50\print  find the order history report file and edit the file name, removing the .cpprint. It is now a .csv file and with one click can be opened in Excel and saved elsewhere as .xls.

Run frequency
Upon request or on a routine schedule

Sample Report

Sample Order History Report (excel doc)

Maintained by: Information Technology Division College Park, MD 20742-7011