cancel
Showing results for 
Search instead for 
Did you mean: 

Comparing trip request VS expense report amounts

Former Member
0 Kudos

Hi,

Is there any chart or list view for comparing "Trip request" amounts (theoretical amounts when booking hotel, mileage, etc) versus "Expense report" amounts (real amounts that you have paid) for a specific User, Cost center, Project?

Thanks,

David

Accepted Solutions (1)

Accepted Solutions (1)

rahul_mishra7
Active Participant
0 Kudos

Hi David,

There is not standard report available to compare these details.

But there is a Data Source available of Trip Request Details & Expense Report Details.

You can make you own report with these data sources.

  

Data source „Trip Request Details“ with technical ID ODTTRVREQU01 contains estimated costs in trip request.

 

Data source “Allocated Trip Requests” with technical ID ODTTRVREQU02 contains cost allocation in trip request.

 

Depending on what the requirement is, either the one or the other should be used.

You can join this with another data source that contains expense report data (using
TRAVEL_PROCESS_UUID as join condition)

I propose to join ODTTRVREQU01 with FINERMU01 or

ODTTRVREQU02 with ODTERMU03

Best Regards,

Rahul Mishra

Former Member
0 Kudos

Hi Rahul,

Thanks for your response. This new report using "Data sources" feature can be created by an administrator of Travel ondemand?, or is it necessary to be created using ToD Studio/SDK tools?

Is it easy to create?

best,

David

rahul_mishra7
Active Participant
0 Kudos

This new report using "Data sources" feature can be created by an administrator of Travel on-demand.

No ToD Studio/SDK tools is required.

Regards,

Rahul Mishra

Answers (0)