You are here: Home / administrative-computing / documentation / Work Requests / Student Financials Projects / WR_SF041 / ZSF041_EXT_LOAD_DATE_RANGE

ZSF041_EXT_LOAD_DATE_RANGE

by vandberg published Feb 25, 2011 11:45 AM, last modified Jun 23, 2017 02:37 PM
Query Instructions

Function:

Display a list of all transactions that were loaded from one type of external file during a range of dates. 

Operation:

From the menu, select:

Main Menu >Reporting Tools > Query > Query Viewer

In the Search By select Query Name to search for ZSF041_EXT_LOAD_DATE_RANGE or any of the other criteria.

Click the Search button.

Click on HTML to see the query results in a web page or Excel to see the query results in a spreadsheet

External load by dates - prompts

Enter the code for the type of external file in Ext File.

Enter the beginning of the date range in Start Date.

Enter the end of the date range in End Date.  

Click the View Results button.

External load by dates - output 

Click Excel Spreadsheet or CSV Text File if you want to down the information in that format. 

If there are any messages for a transaction, Message, Warning or Error will appear  in the Err / Warn column.  Click this word to display the messages. 

Additional Information

See the system instructions --  Load External Charges