Expense Reports (Inquiry)

The Expense Reports Inquiry allows you to query for and view a listing of draft and final expense reports.

In addition, the Expense Reports Inquiry is a Supervisory Review Inquiry, which provides additional options to approve, cancel, recall, reject, save, and sign expense reports. For more information, see Supervisory Review (Time and Expense).

Restrictions

The inquiry includes the following default restrictions:

  Restriction Description
  From Posting Date

Enter or select a posting date. This is the first date in the date range to include open items. This field defaults to the current posting period.

To Posting Date Enter or select a posting date. This is the last date in the date range to include open items. This field defaults to the current posting period.
  Source Select the source of the expense reports. The options are: blank, Draft or Final. This field defaults to blank, which will return both drafts and finals in the list.

For a list of the optional restrictions, see ClosedExpense Report Optional Restrictions.

The following optional restrictions are available:

  • Begin Date
  • Created Date
  • Document Number
  • Document Suffix
  • Employee
  • Employee Home Company
  • Employee Home Organization
  • Employee Map
  • Employee Map Level
  • End Date
  • Voided

Results

The inquiry contains a single level of expense report information, which includes Posting Date, Employee Code, Employee Name, Begin Date, End Date, Document Number, Expense Report Name, Currency Code, Total Amount, Workflow, State, and Source. ClosedExpense Report Optional Columns.

The following optional columns of information are available:

  • Company Paid
  • Created Date
  • Date Last Updated
  • Document Suffix Code
  • Document Suffix Name
  • Employee Home Company Code
  • Employee Home Company Name
  • Employee Home Organization Code
  • Employee Home Organization Name
  • Employee Map Level 2 - 6 Name
  • Historical Home Organization Code
  • Historical Home Organization Name
  • Last Updated By
  • Reimbursement
  • Source Company Code
  • Source Company Name
  • Total Tax
  • Unallowed Amount
  • Voided