Concur Analysis / Intelligence

(1)

Concur Release Notes Page i Concur Analysis / Intelligence

Concur Release Notes

Concur Analysis / Intelligence

Month Audience

February 2014

Initial post: Thursday, February 06, 3:00 PM PT Concur Clients - FINAL

Release Notes ... 1

**Coming Soon** Enhancements for Analysis and Intelligence ... 1

New Folders in the Model – Preparing for Concur Insight Premium ... 1

**Ongoing** Upgrade to Cognos Version 10.2.1 Continues ... 3

New Fields/Folders in the Model ... 4

Invoice ... 4

Expense ... 4

(2)

Release Notes

Coming Soon Enhancements for Analysis and Intelligence

In March, Concur Analysis/Intelligence will see a name change as well as a new offering with enhanced data. Concur's combined business intelligence solution will carry the new name of Concur Insight. In addition:

 Analysis: The no-cost solution currently known as Analysis will be called Concur Insight Essentials. Other than the name change, the product will remain the same with regard to access, standard reports, etc.

 Intelligence: The current for-purchase solution known as Intelligence will be phased out of the sales process shortly after the launch of the new Concur Insight Premium offering (described below). Existing Intelligence clients can continue to use Intelligence and will be supported until the client is no longer under contract or chooses to upgrade to Concur Insight Premium.

 Concur Insight Premium: A new for-purchase solution – Concur Insight Premium – will be available to new and existing clients in the near future.

Concur Insight Premium uses the existing Intelligence solution and then layers on new technology for enhanced data aggregation, cleansing, normalization, enhancements, and report visualization. For example:

 It has several new reports and dashboards. Each quarter, additional reports will become available to Concur Insight Premium clients.

 Corporate card merchants will be matched to a unique vendor record to eliminate the disparate reporting that results from misspellings or differences amongst card and point-of-sale systems.

 Supplemental travel data can be imported for existing Concur Travel and Expense users via feed files from numerous TMC agencies.

 Pricing is different. Clients should contact their Concur Account Managers for information about the pricing difference.

There will be more information available later in March.

New Folders in the Model – Preparing for Concur Insight Premium

With the new reporting offering will come additional data, reports, and dashboards.

In the February release, there will be several new folders in the model. They will be populated when the new offering is available.

(3)

Concur Release Notes Page 2 Concur Analysis / Intelligence These folders are new in the model but are not yet populated:

 Expense > Expense Reports > Entry Information:

(4)

 Expense > Expense Reports > Credit card > Credit Card Transactions:

Ongoing Upgrade to Cognos Version 10.2.1 Continues

The Cognos upgrade to version 10.2.1 continues.

!

IMPORTANT: Be aware that existing functionality will not be impacted by the upgrade – the upgrade adds new functionality and enhancements.

For more information about the upgrade schedule and enhancements, refer to the January release notes.

(5)

Concur Release Notes Page 4 Concur Analysis / Intelligence

New Fields/Folders in the Model

Invoice

New fields are:

 Purchase Order > Purchase Order Line Item > Is Received

 Purchase Order > Purchase Order Line Item > Receipt Required

 Purchase Order > Purchase Order Line Item > Dates> Received Date

 Purchase Order > Purchase Order Line Item > Amounts > Received Quantity

 Payment Request Header Information > Additional Details > Is Invoice Confirmed

 Payment Request Header Information > Additional Details > Receipt Confirmation Message

Expense

New tax-related fields are:

 Expense Reports > Expense Taxes > Expense Tax > Proportional Flag

 Expense Reports > Expense Taxes > Expense Tax > Amounts (reimbursement currency) > VAT Reclaim Amount (reimb)

 Expense Reports > Expense Taxes > Expense Tax > Amounts (reporting currency) > VAT Reclaim Amount (rpt)

New ExpenseIt fields:

 Expense Reports > Entry Information > Additional Entry Details > Is Created By ExpenseIt

 Lists > Employee Information > Additional Details > Is ExpenseIt User New receipt-reviewed field:

 Expense Reports > Entry Information > Additional Entry Details > Is Reviewed

(6)

Concur Release Notes

Concur Insight (formerly Concur Analysis / Intelligence)

Month Audience

March 2014

Update #1: Friday, March 14, 5:30 PM PT Client - FINAL

Release Notes ... 1

Name Change ... 1

Model: Reports Removed ... 1

Reports: New Reports – Not Yet Available ... 2

Model: New Folders and Fields ... 3

Travel Folder ... 3

Expense Folder ... 3

Cognos: Upgrade to Cognos Version 10.2.1 Continues ... 3

Cache Issues ... 3

(7)

Concur Release Notes Page 1 Concur Insight (formerly Concur Analysis / Intelligence)

Release Notes

Name Change

With this release, Concur Analysis/Intelligence will see a name change. Concur's combined business intelligence solution is now known as Concur Insight.

 Analysis: The no-cost solution known as Analysis is now called Concur Insight Essentials. The product remains the same with regard to access, standard reports, etc. However:

 The report user will now see Concur Insight Essentials on the Reporting menu.

 While working with the reports in Cognos, the user will see that the

Analysis - Standard Reports folder is now named Insight Essentials - Standard Reports.

 Intelligence: For the for-purchase solution known as Intelligence, there will be no change – the product remains the same with regard to menus, folders, access, standard reports, etc.

Model: Reports Removed

Several reports will be removed in this release. These legacy billing reports – all of which incorporate a -5 day offset to accommodate Concur's previous billing process – were retained in the system alongside their replacement reports to support clients still working with them. Now, with the new replacement reports available, the legacy reports will be deleted.

These reports will be removed:

 Billed Transaction Reconciliation

 Billed Transaction Reconciliation - Detail

 Invoice Billed Transaction Reconciliation

 Invoice Billed Transaction Reconciliation – Detail

(8)

The reports were in these folders:

 Insight Essentials - Standard Reports > Administration

 Intelligence - Standard Reports > Administration

Reports: New Reports – Not Yet Available

With this release, two new reports will appear, however, they are not yet available. If you run them, no data will be returned. The reports are:

 Travel Points Details

 Travel Points Summary They appear in these folders:

 Insight Essentials - Standard Reports > Administration

 Intelligence - Standard Reports > Administration

You will receive more information when the reports are available and ready for use.

(9)

Concur Release Notes Page 3 Concur Insight (formerly Concur Analysis / Intelligence)

Model: New Folders and Fields

Travel Folder

Folder/Fields added to Travel > Reservations and Tickets:

 New folder: Car Pickup/Dropoff

 New fields in the folder:

 Car Pickup Location

 Car Pickup City

 Car Pickup State

 Car Pickup Country

 Car Dropoff Location

 Car Dropoff City

 Car Dropoff State

 Car Dropoff Country

Expense Folder

Fields added to Expense > Expense Reports > Expense Attendees > Additional Attendee Details:

 Custom 21 - Code through Custom 25 - Code

 Custom 21 - Name through Custom 25 - Name

Cognos: Upgrade to Cognos Version 10.2.1 Continues

The Cognos upgrade to version 10.2.1 continues.

!

IMPORTANT: Be aware that existing functionality will not be impacted by the upgrade – the upgrade adds new functionality and enhancements.

For more information about the upgrade schedule and enhancements, refer to the January release notes.

Cache Issues

If you are using Internet Explorer and if – after the 10.2.1 upgrade – you see a blank screen or if the reports are unresponsive, please clear your cache.

To do so in Internet Explorer:

1. Click Tools > Internet Options.

(10)

2. In the Browsing history section of the Internet Options dialog box, click Delete.

3. In the Delete Browsing History dialog box, ensure the following options are checked:

 Temporary Internet Files

 Cookies

 History

All other check boxes are optional.

4. Click Delete.

5. In the Browsing history section of the Internet Options dialog box, click Settings and then View Files.

6. Select all files and delete them.

7. Click OK twice to exit.

8. Close all browser windows.

9. Then, open a new browser window, log back in to the Concur application, and access reporting again.

(11)

Concur Release Notes Page i Concur Insight (formerly Analysis / Intelligence)

Concur Release Notes

Concur Insight (formerly Analysis / Intelligence)

Month Audience

April 2014

Initial post: Friday, April 11, 3:30 PM PT Internal Only - FINAL

Release Notes ... 1

New Fields in the Model ... 1

(12)

Release Notes

New Fields in the Model

These fields have been added to the model.

Affidavit

Location: Expense > Expense Reports > Entry Information > Additional Entry Details New Field: Has Affidavit

Cash Advance

Location: Expense > Cash Advances > Cash Advance Details > Additional Cash Advance Details

New fields:

Field Description

Requested Disbursement Date

Date for disbursing the cash advance funds

Travel Start Date Projected first date of travel Travel End Date Projected last date of travel

Location Primary destination of the trip city selector Purpose Business purpose for the cash advance

XML Receipt

Location: Expense > Entry Information > XML Receipt Information New fields:

Field Description

Status Status of the validation

Comment Comment when Status is 'Valid with warnings' or 'Invalid'

Location: Expense > Entry Information > XML Receipt Information > XML Receipt Keys

New fields:

xml Receipt Status Key

xml Receipt Status Prompt Key

(13)

Concur Release Notes

Concur Insight (formerly Analysis / Intelligence)

Month Audience

September 2014

Initial post: Friday, September 12, 1:00 PM PT Client - FINAL

Release Notes ... 1

Purchase Request Data Available ... 1

Additional Model Changes ... 3

Additional Concur Insights Documentation ... 4

Via the Concur Support Portal ... 4

Via Cognos ... 5

(14)

Release Notes

Purchase Request Data Available

With this release, Purchase Request data has been added to the Invoice folder in the reporting data model.

(15)

Concur Release Notes Page 2 Concur Insight (formerly Analysis / Intelligence)

If your role allows you to create or modify reports, you can now use the Purchase Request data in your reports. Purchase Request data will be added to the standard reports in a future release.

The field information is available in Chapter 3: Data Model - Invoice Folder of the Concur Insight guide.

(16)

Additional Model Changes

The following fields have been added to the model.

Expense

Expense > Expense Reports > Entry Information > Region

Expense > Expense Reports > Entry Information > Normalized Vendor > Vendor Region

Expense > Expense Reports > Entry Information > Keys > Region Key

Expense > Expense Reports > Entry Information > Keys > Prompt Keys > Region Prompt Key

Expense > Expense Reports > Credit Card > Credit Card Transactions > Normalized Vendor > Vendor Region

Expense > Expense Reports > Credit Card > Credit Card Transactions > Additional Merchant Details > Merchant Region

Expense > Expense Reports > Credit Card > Credit Card Transactions > Keys >

Merchant Region Key

Expense > Expense Reports > Credit Card > Credit Card Transactions > Keys >

Prompt Keys > Merchant Region Prompt Key

Invoice

Invoice > Payment Request Header Information > Keys > Associated Purchase Order Request Key

(17)

Additional Concur Insights Documentation

Additional documentation is available.

Via the Concur Support Portal

You can access Concur Insight documentation on the Concur Support Portal. If you have the proper permissions, the Support menu is available to you in Concur.

Click Support. Then, in the Concur Support Portal:

 For Professional edition, click Resources > Release/Tech Info (on the sub- menu).

– or –

 For Standard edition, click Resources > Release/Tech Info – Standard (on the sub-menu).

(18)

Click Technical Documentation. On the page that appears, click the User Guides link under Concur Insight.

Via Cognos

While in Cognos, click Launch > Help – Concur Model.

(19)

Concur Release Notes

Concur Insight (formerly Analysis / Intelligence)

Month Audience

October 2014

Initial post: Friday, October 17, 1:30 PM PT Client - FINAL

Release Notes ... 1

Model Changes – Expense: Attendees ... 1

Model Changes – Expense: Travel Allowance ... 1

New Reports: Invoice ... 1

Report: Employee Exceptions – Details ... 3

Report: Request Exception Analysis ... 4

Report: Request Exception Analysis (with comments) ... 5

Report: Request Header Exceptions ... 6

Report: Request Line Item Exceptions ... 7

Report: Request Line Item Exceptions Detail Report ... 8

Report: Top 10 Longest to Approve ... 9

Report: Top Exception Violators ... 10

Report: Workflow Cycle Times – Details ... 11

Report: Workflow Cycle Times – Summary by Manager ... 12

Report: Workflow Cycle Times – Summary by Processor ... 13

Additional Concur Insights Documentation ... 14

Via Cognos ... 15

(20)

Release Notes

Model Changes – Expense: Attendees

The following query item has been added:

Expense > Expense Reports > Expense Attendees > Is Traveling

Model Changes – Expense: Travel Allowance

The following query items have been added:

Expense > Travel Allowance > Fixed Travel Allowance > Amounts >

Rate Currency

Meals Rate

Lodging Rate

Expense > Travel Allowance > Reimbursable Travel Allowance > Amounts >

Rate Currency

Meals Rate

Lodging Rate

Expense > Travel Allowance > Itineraries > Trip Length

Expense > Travel Allowance > Itineraries > Keys > Associated Report Key Expense > Expense Reports > Report Header Information > Keys >

Associated Itinerary Key

New Reports: Invoice

The new Invoice report are available in these folders:

 Public Folders > Intelligence – Standard Reports > Invoice

 Public Folders > Insight Essentials – Standard Reports > Invoice

(21)

Report Description

Employee Exceptions – Details

This report will identify all request-level exceptions for a given employee.

A drill-through will be enabled from the Number of Exceptions and Employee columns that open this report.

As with all of our drill-throughs, this report can also be run as a standalone report.

Request Exception Analysis

This report provides a list of exceptions for requests based on a date range.

Request Exception

Analysis (with comments) This report lists the exceptions for requests based on a date range with detailed comments.

Request Header Exceptions

This report shows the year-by-year exceptions that are created most frequently and the number of associated payment requests at the payment requests header level.

Request Line Item Exceptions

This report provides statistics about the exceptions that are captured at the line-item level for specified years and exception types, allowing long-term trend analysis of the types of

exceptions that are being detected in payment requests.

Request Line Item

Exceptions Detail Report This report provides a detailed list of all line-item exceptions for employees over a user-defined timeframe. Users also have the option of selecting a single employee when running this report.

Top 10 Longest to

Approve This report provides a rank of the longest time to approve payment requests.

Top Exception Violators This report shows the 10 employees with the highest number exceptions identified by the system on payment requests submitted during a specified timeframe.

Workflow Cycle Times – Details

This report provides details of workflow cycle times; shows the time it took for a request to move through the major workflow steps.

Workflow Cycle Times – Summary by Manager

This report provides a summary of workflow cycle times by manager; manager name is clickable for drill-through.

Via the Concur Support Portal

– or –

(34)

Via Cognos

(35)

Concur Release Notes

Concur Insight (formerly Analysis / Intelligence)

Month Audience

November 2014

Initial post: Monday, November 17, 10:00 AM PT Client - FINAL

Release Notes ... 1

Model Change: Invoice ... 1

Additional Changes – Model Change: Expense ... 1

Additional Concur Insights Documentation ... 2

Via Cognos ... 3

(36)

Release Notes

Model Change: Invoice

Invoice > Payment Request Line Items > Keys:

Purchase Order Line Item Legacy Key

Additional Changes – Model Change: Expense

There were other Expense model changes made earlier this year that may have had only limited visibility. They are:

Expense Reports > Entry Information > Additional Entry Details:

Has Affidavit

Entry Information > XML Receipt Information:

Status (Description: Status of the validation)

Comment (Description: Comment when Status is Valid with warnings or Invalid )

Entry Information > XML Receipt Information > XML Receipt Keys:

xml Receipt Status Key

xml Receipt Status Prompt Key

Travel Requests > Travel Request Segments > Additional Travel Request Segment Details:

Vendor (from list)

Vendor (free-form entry)

Cash Advances > Cash Advance Details > Additional Cash Advance Details:

Requested Disbursement Date Travel Start Date

Travel End Date Location

Purpose

(37)

Additional Concur Insights Documentation

Via the Concur Support Portal

– or –

(38)

Via Cognos

(39)

Concur Release Notes Page i Concur Insight

Concur Release Notes

Concur Insight

Insight Essentials, Intelligence, Insight Premium

Month Audience

December 2014

Initial post: Friday, December 12, 10:30 AM PT Client - FINAL

Release Notes ... 1

Model Change: Invoice ... 1

New Reports: Germany Market – M Reports ... 2

Overview... 2

Report Descriptions ... 2

Germany - M-Report Summary ... 2

Germany - M-Report Detail ... 4

Location of the Reports ... 5

New Report: Germany Market – BIK ... 6

Overview... 6

Report Description ... 6

Report Prompt ... 6

Report Output ... 7

Location of the Report ... 8

Updated Reports: Survey ... 8

Overview... 8

User Rating Summary – Expense ... 9

User Rating Summary – Travel ... 10

Location of the Reports ... 12

Additional Concur Insights Documentation ... 14

Via Cognos ... 15

(40)

Release Notes

Model Change: Invoice

The following fields and folders are now available to the Invoice folder:

 Field: Invoice > Purchase Order > Purchase Order Request > Status

 Folders and Fields: Invoice > Purchase Order > Purchase Order Request >

Supplier Details (with all associated fields and subfolders)

(41)

Concur Release Notes Page 2 Concur Insight

New Reports: Germany Market – M Reports

Overview

Beginning in 2014, German companies must print an "M" in the certificate of wage tax deduction if an employee has received any payment for travel allowance (where the meal type = external meals).

Concur has created two reports to help clients report this data:

 Germany - M-Report Summary

 Germany - M-Report Detail

These reports are available to all Insight Essentials, Intelligence, and Insight Premium clients but are only relevant to the German market.

Report Descriptions

These reports list all German employees (where the Employee Country = Germany) who – at least once in a calendar year – received a reimbursement for the meal type in German "Auswärtstätigkeit" (in English "external activity").

The Summary report contains a distinct list of employees who meet these criteria.

The Detail report contains a listing of all of the individual instances of travel allowances with External Activity meals entered that also have corresponding expenses, along with the corresponding expense information.

NOTE: If a user does not have an expense on the date the travel allowance with an External Activity meal is received, it will not currently appear on the reports.

Note the following:

 If the client uses both fixed and reimbursable allowances, then the reports display fixed and reimbursable data.

 If the client uses only fixed allowances, then the reports display fixed data.

 If the client uses only reimbursable allowances, then the reports display reimbursable data.

Germany - M-Report Summary

Report Prompts

The report has a required prompt for Paid Date and optional prompts for Active Flag and Employee.

(42)

Report Output

There are two ways to drill to the Detail report from the Summary report:

 Click Drill Through Detail, which displays the Detail report for all employees.

 Click an Employee ID, which displays the detail report for the selected employee.

NOTE: The resulting reports use the same prompts entered for the Summary.

(43)

Germany - M-Report Detail

Report Prompts

The report has a required prompt for Paid Date and optional prompts for Active Flag and Employee.

(44)

Report Output

Location of the Reports

The Germany - M-Report Summary and the Germany - M-Report Detail reports are located in the new Market Specific Reports folder:

(45)

New Report: Germany Market – BIK

Overview

Beginning in 2014, German employees must pay tax on BIK (Benefit In Kind) if they were provided an "External Activity" meal without having a claim for any per diem that meet all of the BIK criteria:

Expense report where the itinerary duration is <8 hours or >3 months – and –

The allowance amount is 0 because the per diem does not apply and the travel allowance meal type entered is "External Activity"

The new Germany – BIK Report will assist German clients who need to report the taxable amount for meals that meet the criteria in order to be compliant with German law.

The report is available to all Insight Essentials, Intelligence, and Insight Premium clients but is only relevant to the German market.

Report Description

The report lists all of the Expense transactions and corresponding travel allowance and itinerary information that meet the BIK criteria mentioned above, for German employees (where the Employee Country = Germany).

NOTE: If a user has a travel allowance that falls under the BIK rules but does not have a corresponding expense entry on the same day, the record will not currently appear on the BIK report. This is because the report is driven by the transaction date, which is on the expense entry, so if there is no expense entry – there is no transaction date.

Note the following:

 If the client uses both fixed and reimbursable allowances, then the reports display fixed and reimbursable data.

 If the client uses only fixed allowances, then the reports display fixed data.

 If the client uses only reimbursable allowances, then the reports display reimbursable data.

Report Prompt

The report has a required prompt for Transaction Date and optional prompt for Employee.

(46)

NOTE: The date prompt is based on the transaction date. For the date range, the beginning date defaults to Jan 1 2014 and the end date defaults to "today."

The report user can change the dates as needed.

It also has a required prompt for the BIK Amount values for Breakfast, Lunch, and Dinner. The defaults are 1.63, 3.00, and 3.00, but the report user can change them as needed.

Report Output

(47)

Location of the Report

The Germany Market – BIK report is located in the new Market Specific Reports folder:

Updated Reports: Survey

Overview

After a Concur user submits a report or books a trip, a survey appears. The survey was recently streamlined to ask only for the overall rating and comments. With that, these associated survey reports have been updated:

 User Rating Summary – Expense

 User Rating Summary – Travel

The Overall Rating and Comments column still appear in the report while Usability Rating, Reliability Rating, and Performance Rating have been removed. The prompt page has been changed accordingly.

These reports are available to all Insight Essentials, Intelligence, and Insight Premium clients.

(48)

User Rating Summary – Expense

Report Prompt

The report user can elect to see all feedback or only the feedback with comments.

Report Output All feedback:

(49)

Concur Release Notes Page 10 Concur Insight Only feedback with comments:

User Rating Summary – Travel

Report Prompt

The report user can elect to see all feedback or only the feedback with comments.

(50)

Report Output All feedback:

(51)

Concur Release Notes Page 12 Concur Insight Only feedback with comments:

Location of the Reports

The updated User Rating Summary – Expense and User Rating Summary – Travel reports are located in the Administration folder:

(52)

(53)

Additional Concur Insights Documentation

Via the Concur Support Portal

– or –

(54)

Concur Analysis / Intelligence

Concur Release Notes