cancel
Showing results for 
Search instead for 
Did you mean: 

AMEX - Credit Card Import Error - KR1025

Former Member
0 Kudos

Hi All,

We have an issue with the AMEX credit card import where in the AMEX KR1025 file we are getting couple of transaction where the 'billed currency' currency for the transaction is different to the settlement currency at the header level. We did debugging of the program RPRCCC_READ_KR1025 and found that there is standard code which is called to check if the transactions billed currency is same as the settlement currency and if its different then it fails with the error message 'Source files can only contain one settlement currency'

I was wondering if anyone has a similar issue with the KR1025 format? and does this also happen for the GL1025 format too?

Thanks

Ankur

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Any update guys? any advice/help on this would be highly appreciated.

Former Member
0 Kudos

Dear Ankur,

Yes, we also had the similar issue. If the settlement currency is different from the billed currency, system gives the error and file upload get failed. This happened for both the file format i.e GL1025 & KR1025. This is the standard behavior of the system.

The solution is only to ask the AMEX team to provide the file with the correct currency. We had a call with the AMEX team and were able to permanently resolve this issue by ensuring the correct currency in the file.

Regards,

SUmti Bhadani

Former Member
0 Kudos

Hi Sumti,

Thanks for the response. This shouldn't really happen however we are using this in China and AMEX has a collaboration with China Merchant Bank and the cards in China are issued in dual currency. For transactions in foreign amount we are getting this in USD and AMEX has no control over this as this feed is provided by CMB to AMEX.

Anyone had any experience of AMEX interface for China or solution to this issue? It has been a nightmare trying to get a response back from AMEX and China Bank so any help on this would be appreciated!

Thanks

Ankur

Former Member
0 Kudos

Dear Ankur,

I don't think in standard SAP, solution is available for this. Please check this wiki for details for credit card processing.

Processing of Credit Card transactions in Travel and Expenses - ERP Human Capital Management - SCN W...

May be some Z program can be developed but not very much sure on that

Regards,

Sumti Bhadani

Lukas_Weigelt
Active Contributor
0 Kudos

Hi Ankur,

the way you describe it, a custom development seems like the last straw . That is, if the cooperation between CMB and AMEX definitely rules out that AMEX can change the format to one single currency (as it should be), RPRCCC_READ_KR1025  wont be able to read these files (as you already analysed correctly and as your provided screenshot shows.).

For some food for thought: We are using Airplus (with a company account) with ATX Format. That's a completely different situation than yours and technically it works out relatively good. However, we did have some problems with the functional content of the ATX Files, because certain service providers aren't able to return their data with a reference key (PERNR, REINR, Itemization). For this, I have created a WDA based Scenario which does the following:

  • the original File is read in, validated and parsed
  • the power user using the scenario can manipulate certain items that qualify for certain service providers and are missing any reference to the SAP data whatsoever. Basis for that manipulation are paper based documents which do have a reference (better don't ask....)
  • the data is parsed, validated and converted back into an ATX-File
  • the manipulated/converted/corrected ATX file is submitted to the standard program RPRCCC00
  • everybody's happy

This makes the business process a bit clumsy but it works out and it does work out a lot better than toying around with the CCC-Buffer and the standard file correction reports.

Maybe you can build something similar and mix your two currencies into one without falsifying the sums to "prepare" the files for RPRCCC_READ_KR1025. ;-/

Cheers, Lukas

Former Member
0 Kudos

Hi Lukas,

Thanks for the input.

Just for everyone else who are planning to implement AMEX solution for T&E in China

Be careful when you are deploying T&E solution with AMEX interface for China. China is an optional dual currency settlement market for credit cards and when you are requesting new AMEX card, which are issued by China Merchant Bank (in our case at least) with default as dual currency CNY and USD. This means if you are making transactions outside of China then they would appear as USD settlement currency in the GL1025 file but if they are incurred in China then they would appear in CNY which will result in error during loading of the transactions because SAP standard program has a standard check for multiple settlement currencies in the file.

NOTE: So when requesting new AMEX cards for China please ensure that you have NOT selected the fourth option on the form 'FX rate 1st day of each month which in English means overseas transactions will be converted using the FX rate of 1st of the month and converted into USD. If you want to have single currency in the file then it is HIGHLY recommend that the first option is selected which in English is 'transaction day exchange rate' and this means even the foreign transactions will be settled in local currency i.e. CNY (Chinese Yuan). Obviously the above was applicable to our case but still please check how the cards have been set up and the currency.

It was really pain but glad we were able to fix it

Thanks

Ankur

Lukas_Weigelt
Active Contributor
0 Kudos

So this could be solved by configuration means on AMEX/Bank side? Very interesting

Cheers, Lukas

P.S. You should set your answer "correct", so others can find it more easily