Expense Reports (Inquiry)

Additional Information

(missing or bad snippet)

Restrictions

The inquiry includes the following default restrictions:

  Req'dRestrictionDescription
 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 DateEnter 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.
 SourceSelect 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:

  • Balance
  • 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
  • Payment Amount
  • Reimbursement
  • Source Company Code
  • Source Company Name
  • Total Tax
  • Unallowed Amount
  • Voided