Joia
Occasional Member - Level 2

"Authorized Travel Request w/out Expense Report Entry" shows Requests that ARE on a Report

I got this request from one my users, and I'll admit: I'm scratching my head cuz she's totally right.

"Can you help me to understand report “Authorized Travel Request w/out Expense Report Entry”.

I was under the assumption that this report captures Travel Requests that are not attached to an expense report, however, in the below table these open requests appeared in the report but are attached to an expense report that has been paid.  Please let me know how this report is supposed to be used."

Can someone explain to me what we're both missing from how this report works?  She sent me a listing of six approved trip requests that have been properly attached to expense reports and yet are still showing on the report that proports to show un-expensed trip requests.  I thought maybe it was because the trip request was for more than the actual trip total, but when I looked up my own instance of that situation, it wasn't the case.  My trip request with 'money left' wasn't showing on the report I pulled.

Sarah Gorman
Travel Operations Analyst
I've got my doubts.... but what if I'm right?
1 Solution
Solution
PoojaKumatkar
Super User
Super User

Hi @johndi ,

 

I think you misunderstood the report description. You need to focus on below highlighted line: 

"This report will display all completed Travel Requests that do not have a Travel Request line item associated to a report entry. This will allow finance departments to identify liabilities and plan appropriately."

 

Here, they are NOT referring to just any expense report. They are specifically talking about the associated expense report entry where the travel request is not linked. 

 

Let me explain how this works for better clarity.

 

Assume you have the approved travel request below, and it has been linked to an expense report.

 

This is why the record is still appearing in your Cognos report. You may expect it not to show up because, from your understanding, the travel request has already been linked to the report.

 

PoojaKumatkar_0-1776672029110.png

 

The report will only be excluded from Cognos when the travel request is actually linked within the specific expense report entry. In this case, since the travel request is for the “taxi” expense type, you need to select the “taxi” expense type in the expense report and associate the approved travel request, as shown below.

Once this is done, the expense report record will no longer appear in the Cognos report results.

 

Note: In the backend, each expense type in the Request module is mapped to a corresponding expense type in the Expense module. That’s why the “Request” field appears only in certain expense entry forms. In other forms, this field will not be visible, as it is controlled by backend configuration.

PoojaKumatkar_1-1776672349033.png

PoojaKumatkar_2-1776672612482.png

 

In your scenario, employees may have linked the travel request to the expense report, but not to any specific expense entry. As a result, those records are still appearing in your Cognos output. You can verify this by manually reviewing such records in Concur.

 

 

Hope this helps to clarify your understanding! 🙂

 

If this answers your query, then please mark solution as accepted.

Thanks!
Regards,
Pooja

View solution in original post

9 REPLIES 9
KevinD
Community Manager
Community Manager

@Joia do you have examples of some Requests I can look up and take a look at? 


Thank you,
Kevin
SAP Concur Community Manager
Did this response answer your question? Be sure to select “Accept as Solution” so your fellow community members can be helped by it as well.
johndi
Occasional Member - Level 1

Hi Kevin, 

I'm not sure if you had internal conversation already with her but I'm having the same issues. Report includes requests that has been already added to an expense report (paid). Similar to her question, how should we utilize this report? I can send you screenshots via PM if that helps. 

Please let me know. 

Thanks!

Hi @johndi ,

 

Could you please describe the exact issue you’re facing? If possible, share a screenshot along with the error message—that would help clarify the problem.

 

If your query is about why an approved travel request is still visible in the expense report—even though it has already been used in a paid expense report—it could be due to your request policy configuration. The policy may be set up to allow a single approved travel request to be linked to multiple expense reports. This setting is part of the request policy configuration component.

 

PoojaKumatkar_0-1776670216623.png

 

 

If this answers your query, then please mark solution as accepted.

Thanks!
Regards,
Pooja
johndi
Occasional Member - Level 1

No, there's no error. I'm pertaining to a Standard Cognos Report: Authorized Travel Requests Without Expense Report Entry. A request already attached to an expense report is included in the report which doesn't make sense. 

Description of the report is: 

This report will display all completed Travel Requests that do not have a Travel Request line item associated to a report entry. This will allow finance departments to identify liabilities and plan appropriately.

So why would a request, already attached to an expense report be included on this Cognos Report?

Solution
PoojaKumatkar
Super User
Super User

Hi @johndi ,

 

I think you misunderstood the report description. You need to focus on below highlighted line: 

"This report will display all completed Travel Requests that do not have a Travel Request line item associated to a report entry. This will allow finance departments to identify liabilities and plan appropriately."

 

Here, they are NOT referring to just any expense report. They are specifically talking about the associated expense report entry where the travel request is not linked. 

 

Let me explain how this works for better clarity.

 

Assume you have the approved travel request below, and it has been linked to an expense report.

 

This is why the record is still appearing in your Cognos report. You may expect it not to show up because, from your understanding, the travel request has already been linked to the report.

 

PoojaKumatkar_0-1776672029110.png

 

The report will only be excluded from Cognos when the travel request is actually linked within the specific expense report entry. In this case, since the travel request is for the “taxi” expense type, you need to select the “taxi” expense type in the expense report and associate the approved travel request, as shown below.

Once this is done, the expense report record will no longer appear in the Cognos report results.

 

Note: In the backend, each expense type in the Request module is mapped to a corresponding expense type in the Expense module. That’s why the “Request” field appears only in certain expense entry forms. In other forms, this field will not be visible, as it is controlled by backend configuration.

PoojaKumatkar_1-1776672349033.png

PoojaKumatkar_2-1776672612482.png

 

In your scenario, employees may have linked the travel request to the expense report, but not to any specific expense entry. As a result, those records are still appearing in your Cognos output. You can verify this by manually reviewing such records in Concur.

 

 

Hope this helps to clarify your understanding! 🙂

 

If this answers your query, then please mark solution as accepted.

Thanks!
Regards,
Pooja
johndi
Occasional Member - Level 1

Thanks Pooja, we figured as much. 

One last clarification, in cases where for example, there's 5 request entries, the employee only managed to link 4 of those to the expense report, it will still appear in the report, right?

All entries from request must be linked to an expense type before it gets removed from the Cognos Report?

Thank you!

Hi @johndi ,

 

As per my understanding, yes—it will still appear since one request is still pending to be linked to an expense entry.

 

But again, backed request policy configuration wise scenarios could be different.

 

  • As mentioned in my earlier response, there is a configuration that determines how many expense reports a travel request can be assigned to. In your company, it might have been set to “multiple.” For example, if a user links five requests to one expense report but forgets to link one request to any expense entry, that request may still be linked to another expense report and its associated expense entry. So, it ultimately depends on the configuration.

 

  • Now, if the backend is configured to allow assignment to only “one” expense report, and the request is not linked to any expense entry, then it will definitely appear in the Cognos output.

PoojaKumatkar_1-1776675478696.png

 

So, based on your example, my overall assumption is that yes, it will appear in the Cognos output.

 

 

If this answers your query, then please mark solution as accepted.

Thanks!
Regards,
Pooja
johndi
Occasional Member - Level 1

Thanks Pooja, very helpful!

 

My client now needs to find a report that would display all requests that is not attached to an expense report. If there's 1 segment linked to an expense type, it should not appear on the report since it's still linked to an expense report.

Do you have a recommendation on which standard report they can utilize? I think they have to build a custom report no?

 

Thank you.

Hi @johndi ,

 

Yes, your understanding is correct. I checked the Standard Reporting Catalogue, and there isn’t a standard report available for the specific columns you need. You’ll need to create a custom report to meet this requirement.

 

If this answers your query, then please mark solution as accepted.

Thanks!
Regards,
Pooja