Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Administrators can search for expense reports in the system , and speed their searches by filtering criteria. Once the expense report is found, an administrator may view the report, delete it, change its status, send an E-mail to its author, or print it. Admin retrieves expense reports meeting all of the selected search criteria; selecting a report ID will override any other selection criteria.

...

  1. Click on Utilities.
  2. Click Expense Report Search.
  3. To bring up all Expense Reports in the system, click on Apply in the Expense Report Query window. If there is a large amount of Expense Reports, the system will ask you to limit your query.
  4. To speed the search, filter the search by one or more criteria in the Expense Report Query window, then click on Apply.
  5. The Expense Report Search window appears, listing all of the expense reports meeting the search criteriaFilter your search results with the following criteria to the right under the Filter menu Image Added. If you do not wish to filter against certain criteria, leave it blank. You must make at least one selection.
  6. From this window administrators may delete expense reports, change expense reports' statuses, send an E-mail to the expense report's author, or view and print the expense report.
Level2 Code

Field

Description

Report ID

Selecting a Report ID will retrieve the expense report bearing this ID

Employee ID

Selecting an employee ID will retrieve only the expense reports of the selected employee

First Name

Entering an employee's first name will retrieve only the reports of employees with that first name

Last Name

Entering an employee's last name will retrieve only the reports of employees with that last nameStart Date

Date Range

Selecting a date range would retrieve transactions within the selected timeframe

Date From

The start date for the date range that will be retrieved

End Date To

The end date for the date range that will be retrieved

Last Modified FromFilter results by starting date from which data entries have been last modified
Last Modified ToFilter results by the ending date to which data entries have been last modified
Employee Type 

Selecting an employee type will retrieve only expense reports created by the employee type

Report Type

Selecting a Report Type will retrieve all expense reports of the selected report type

Expense TypeSelecting an Expense Type will retrieve all expense reports of the selected expense type

Status

Selecting a status will retrieve only expense reports having the selected status

Previous Status

Selecting a previous status will retrieve only the expense reports whose status immediately previous to their current status was the selected status

Company

Selecting a Company will retrieve only the expense reports of employees of the selected company

Department

Selecting a department will retrieve only expense reports of employees of the selected department

Location

Selecting a location will retrieve only expense reports of employees of the selected location

Validation Status

Selecting a validation status will retrieve only expense reports of the selected validation status

File Attachment

Selecting with attachments Yes will retrieve only expense reports that have file attachments; selecting without attachments No will retrieve only expense reports that do not have any file attachments

Process Status

Selecting a Process Status will retrieve all expense reports bearing the selected status

CertificationFilter results by user certification

My Group

Selecting a group will retrieve the reports for the login user or for the user's team, department or proxy group

Posted To

Selecting a Posted To will only show expense reports posted to that particular extract

Post Date >=Filter based on the postdate being greater than or equal to a specific date
Post Date <=Filter based on the postdate being less than or equal to a specific date

Not Posted To

Selecting a Not Posted To will only show expense reports that have not been posted to that particular extract

Exception

Selecting an Exception will only show users with that exception status

Level1 CodeWBS Level 1

Selecting a Level 1 code will only show expense reports with charges to selected Level 1

WBS Level 1 Query

Allows search by WBS level 1 one additional query

WBS Level 2

Selecting a Level 2 code will only show expense reports with charges to selected Level 2

WBS Level 2 Query

Allows search by WBS level 2 one additional query

Approver

Selecting a approver will retrieve only expense reports where the selected approver approved or approves for

Vendor

Selecting a vendor will retrieve only vendor payments reports for selected vendor

Batch No

Selecting a Batch Number will retrieve only the expense reports from the selected batch 

Reimbursement>0

Selecting Reimbursement>0 will retrieve only the expense reports with a reimbursement equal to or greater than zero, depending on the selection Yes, will retrieve transactions that have reimbursable amount. Selecting “No” would retrieve transactions with no reimbursable amount

Report Currency

Selecting report currency will retrieve only the expense reports with the selected currency

Employee AttributeAllows search for employee timesheets by an attribute assigned to an employee through Additional Fields
Attribute ValueAllows search for employee timesheets with a specific attribute value

Deleting Expense Reports

To delete an Expense Report:

  1. Search for the expense report(s) to be deleted as detailed in Expense Report Search above.
  2. Select the expense report(s) to be deleted.
  3. Click on Action.
  4. Click on Delete Expense Report.
  5. Enter a Note on why this report is being deleted. 
  6. Click Delete

Sending E-mails

To send an e-mail to the expense report's author:

  1. Search for the expense report(s) to whose author an E-mail is to be sent as detailed in Expense Report Search above.
  2. Select the expense report to whose author will receive the E-mail.
  3. Click on Action.
  4. Click the Send Mail button.
  5. Click inside the Text Box, and key in the message.
  6. Click on ApplyEnter in a Note. This note will be included in the email that is being sent. 
  7. Click Send.

Validating Expense Reports

...

  1. Search for the expense report whose status is to be changed as detailed in the Expense Report Search above.
  2. Select the report(s) whose with a status is to be changed.
  3. Click on Change Status.
  4. Select the new Status from the drop-down.
  5. Enter a Note regarding the status change
  6. Click on Apply Save.
  7. Expense will generate a Change Status Report to inform an Action Result pop-up window which will inform the administrator whether the status change was performed and, if not, why not.

...

  1. Search for the expense reports to route. Expense reports have to be released, rejected, or approved. Open, closed or on Hold expense reports cannot be routed.
  2. Select the expense reporttimesheet(s) to route.
  3. Click on Action.
  4. Click on Approval Routing.
  5. Enter the Approver ID, mail option and message.
  6. Click on Route.the Approval Routing button
    • Manager Name: Select the name of the approver to route to
    • Append Flag
      • Append: Adds the new approvers to the existing list of approvers without replacing or removing any existing approvers
      • Replace: If selected, the entire approval structure will be replaced, and the approver being routed to will have the final approval
    • Send e-mail: Choose whether or not to e-mail the new approver.
    • Notes: Enter any notes regarding this approval routing
  7. Click Apply

Refresh Approval Structure

Refresh Approval Structure is used when reporttimesheet(s) are already in the approval process and a change is made to the approval structure, such as an approver was updated or an approver was removed, thus resulting a timesheet to be stuck in the approval limbo. First the approval structure needs to be updated, then the approval path will need to be refreshed for the corresponding timesheets. By refreshing the approval structure of report(s) the approver(s) will be added/removed without resetting the current approval queue.

...

To generate a viewable/printable version of the Expense an Expense  Report:

  1. Search for the expense report as detailed in the Vendor Expense

...

  1. Search above.

  2. Select the expense report.

  3. Click the arrow next to

...

  1. the Report

...

  1.  button.

  2. Select the type of report to be generated:

...

    1.  Detail Report

...

    1. By Line will organize the expense report's contents by

...

    1. line item.

...

    1. Detail Report

...

    1. By Day will organize

...

    1. the expense report's contents by

...

    1. date.

...

    1. Audit Report will display the date/time for expense entry and who entered the expense.

    2. Audit Report of Deletion will display the date/time for expense deletion and who deleted the expense.

    3. Audit Report of Rejection will display the date/time for expense

...

    1. rejection and who

...

    1. rejected the expense.

    2. Fax Cover Sheet for Receipts will display the fax number and barcode needed to fax receipts to expense reports

    3. Receipt Audit Report will display a summary of audited receipts and expenses along with who did the audit and any auditor notes

  1. View or Print the Report