Configuration to handle reversal of charges in credit card clearing in SAP T&E

[Former Member]

Hi T&E gurus,

We are facing an issues related to credit card import transactions in SAP. Currently we are able to import all the expenses charged through the credit card, but for transactions which are reversal transactions are also pulled in as expenses (For. Ex. refund for an overcharge, cancelation of a airline ticket transaction). Those transactions should come in as negative amounts but they still come in as positive and add up to the total number. Is there a way through configuration to define the credits so they come as negative into the system?

Thanks,

Amit

[Former Member]

Our credit card provider is Mastercard. As per the layout provided by Mastercard, position 121 in the CDF file has a 1 character value of D (Debit) or C (Credit) which tells the system which sign to put on the transaction amount. Check your data from your credit card provider that they are issuing you a flag that you can key off of.

[Former Member]

Hi Kim,

Thanks for the prompt reply. Our credit card provider is Amex and in the file layout we have "+" and "-" indicator, but when the file is uploaded everything is read as "+" and uploads the reversal amount as expense.

Thanks,

Amit

[Former Member]

Have your programmer debug your conversion program. If the data is being supplied, then your program is not converting it correctly.

[manou_manou]

Hi Amit,

We are also using AMEX file for travel Expense.

on column 241 we use D or C (Debit /credit indicator  (Blank when zero)).

please try to change on your file .

after that convert it to CCD file.

Hope it's can help 🙂

Thanks

Emmanuel Levy

[Former Member]

Hi All,

We had the program debugged and it seems there is a bug in the program where it is not assigning the correct sign to the credits. We have approached SAP. Will keep you posted.

Thanks,

Amit