Extract Credit Card Posting Currency and Amount for Expenses

[Reggi]

Hi All,

I'm working on extracting "Paid" expense reports from Concur and I've been able to get all the details I need between Reports, Expenses/Entries, Itemizations, and Allocations APIs. The one final detail I haven't been able to extract is the posted amount and posted currency code - in the case of a US based credit card being used abroad. Has anyone been able to successfully extract this data via API?

I would post this in the Admin Group, but I am not a Concur Admin at my company. Appreciate any help I can get here!

[KevinD]

@Reggi APIs aren't my area of expertise, but as they say..."I know a guy". I've sent him a link to this post. He's currently showing offline, but he's really good at responding as soon as he sees his messages. 

[Reggi]

Thanks @KevinD! Leaving additional information here for your contact:

- Believe corp credit card posting amount/currency can't be extracted via Credit Card Transactions API as it requires user level access tokens and can only return the transactions tied to the user token. Can someone confirm this so I know for sure?
- Financial Integration Service API MIGHT be an option, but it isn't enabled in our environment, and requires changes to our current config and processing workflow which we don't want to introduce.

- Do we have any other options? Standard Accounting Extract?

[TChapman · Accepted solution]

Reggi - 

Since you are looking at "Paid" expenses, FIS wouldn't help.  FIS is used to get data from Concur into ERP prior to payment.

There are three amount/currencies in Concur.  They are:

1) Transaction amount/currency - this is based on where the expense was incurred

2) Posted amount/currency - this is based on the employees reimbursement currency

3) Corporate Card Billing amount/currency - this is the currency of the card.  

In most cases, 2+3 are the same.  But in some situations, the card might be in a different currency.  We have seen this in Latin America / South America and in rare instances in Europe (where a non-euro employee might be holding a euro corporate card).

Assuming you are using Expense v4 APIs, The expense entry transactionAmount is #1, postedAmount is #2.  

Using Cards v4, you can get the billedAmount however it isn't easy as the only API available requires you to sift through all the transactions for a user to find the one associated with that expense.

BTW, this billed amount is available on FIS (cardTransactionPostedAmount) as well as the SAE (column 153)

[Reggi]

@TChapman - you mentioned it's possible to get the billedAmount via Cards v4, but not easy. I found that the Credit Card Transaction ID is returned via Expenses v4 and was looking to use that to filter through a user's CC transactions. However, I haven't been able to make any successful calls to retrieve any other users' CC transactions - other than for the web service user which obviously won't have any transactions.  Is this a known restriction where you can only retrieve CC transactions via Cards v4 for the user the user level access token is associated to? Can you confirm?

If that is the case, then maybe our only options now are either (1) look at sending data into ERP prior to payment via FIS (change in process) OR (2) look at pulling the data from SAE via Extracts v1. 

On a related note - @KevinD is there a difference between SAE vs. Expense Export Files? From what I can tell SAE provides a standardized 400-column data set, but Expense Export allows for customization of which fields are included. Also, believe Expense Export File is broken out by Payment Batches?

[KevinD]

@Reggi full transparency...I've never heard the term Expense Export Files, so I'm not quite sure what you are referring to here. You are correct about the SAE file. I know customers can customize what gets extracted to include their custom fields, so maybe that is what you are referring to by Expense Export Files. I think the SAE is the default extract that comes with using SAP Concur.

[Reggi]

@KevinD This was the learning article where I read about Expense File Exports: https://learning.sap.com/learning-journeys/getting-started-with-concur-expense-standard-for-administ...

Maybe this is just the same thing as SAE, but customized to only include fields customers care about.

[KevinD]

@Reggi yes, that is what that link is. Customizing the extract. 🙂

[Reggi]

Thank you for the quick responses!