Meal Overages/ attendess

[claypoolb]

Hi,

We are reviewing are meal allowance amounts.   Are there any reports out there that can give the meal amount and show if there were any additional attendees for that meal? 

I found this report EXPENSE ENTRY ANALYSIS DETAILS (GROUPED BY EXPENSE TYPE) but it doesn't say if any attendees were included for the total amount to know what the average cost per person per meal would be.   And advice or direction would be appreciated.   

Thank you,

Bethany

[samasuraj · Accepted solution]

Hi  @claypoolb 

Topic: Meal Overages/ attendess

Please check the below. Hope this helps

——-

SAP Concur – Meal Expense and Attendee Reporting

To analyze meal allowances accurately, please use SAP Concur Intelligence (Cognos) to create a custom report combining meal expenses and attendee details.

The Expense Entry Analysis Details (Grouped by Expense Type) report provides meal expense amounts but may not include attendee details.

Check:

1. Concur Intelligence / Cognos: Check for available Attendee Detail or Expense Entry Attendee reports.
2. Custom Report: Combine meal expense entries with attendee information using the available reporting data.
3. Required Fields: Expense Report ID, Expense Entry ID, Meal Amount, Attendee Name, Attendee Count, and Transaction Date.
4. Calculation: Divide the total meal amount by the number of attendees, including the employee when applicable.

Thanks & Regards

—

Samantha Prathikantam

SF_EC & ECP / SAP Concur Consultant

[samasuraj · Accepted solution]

Hi  @claypoolb 

Topic: Meal Overages/ attendess

Please check the below. Hope this helps

——-

SAP Concur – Meal Expense and Attendee Reporting

To analyze meal allowances accurately, please use SAP Concur Intelligence (Cognos) to create a custom report combining meal expenses and attendee details.

The Expense Entry Analysis Details (Grouped by Expense Type) report provides meal expense amounts but may not include attendee details.

Check:

1. Concur Intelligence / Cognos: Check for available Attendee Detail or Expense Entry Attendee reports.
2. Custom Report: Combine meal expense entries with attendee information using the available reporting data.
3. Required Fields: Expense Report ID, Expense Entry ID, Meal Amount, Attendee Name, Attendee Count, and Transaction Date.
4. Calculation: Divide the total meal amount by the number of attendees, including the employee when applicable.

Thanks & Regards

—

Samantha Prathikantam

SF_EC & ECP / SAP Concur Consultant

[claypoolb]

thank you

[claypoolb]

Thank you.

[KevinD · Accepted solution]

@claypoolb not sure if you know this or not, but if you are building a simple List query/report and include Attendees as a data item, you are going to see repeated amounts of the whole total rather than a breakdown of the amount per attendee. This a a pretty common thing that happens. See my screenshot below. 

You will need to create a calculation on your report that would divide the Entry Expense amount by the number of attendees. There is an Attendee Count data item. Add this to your report. Then select the Entry Expense Amount column title and the Attendee Count column title (in that order). On the toolbar look for the Insert Calculation button. Click it and you'll see some calculation options. Select the one that shows the division (/) sign between Entry Expense Amount and Number of Attendees. 

This is what you want to avoid. 

[claypoolb]

thank you

[samasuraj]

Hi @claypoolb 

Topic: Meal Overages/ attendess

Thank you for marking my response as an Accepted Solution!

I am glad the information was helpful in resolving your issue.

Happy to help! 🙂

Thanks & Regards

--

Samantha Prathikantam

SF_EC & ECP / SAP Concur Consultant