mponter
New Member - Level 1

Need help joining Concur Expense with Concur Travel Data

We are using the Concur API to import records from both the Concur Expense and Concur Travel modules. Is there a way to join these two based on a unique key? 

5 REPLIES 5
aamangulati
Occasional Member - Level 1

Hi, were you able to find a solution to this?

 

kreddy
Occasional Member - Level 1

any solution to this type of a problem?

KevinD
Community Manager
Community Manager

@kreddy My API contact is currently out of office. I'll try to get in touch with him when he's back.


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.
kreddy
Occasional Member - Level 1

@KevinD any update on this, is your API contact back?

TChapman
SAP Concur Employee
SAP Concur Employee

There is no link from the Travel Itinerary to one or more expense reports.
As for expense to Travel, I do not see a field for getting an itinerary associated with an expense entry. Some clients do require the itinerary to be associated with an Airfare expense (for example), but I don't see a dedicated field for that link.  I do see an ereceipt field in the expense v4 but I am unsure what it returns (you can only test in production).

My recommendation would be to associate expenses based on dates as the itinerary does have an airfare start and end date (which might not be accurate with actual start/end due to delayed flights). or use hotel start/end.