Employee's Credit Card transactions processing

[Former Member]

Hi, our employees are using Credit Cards, we are receiving MT940 file containing each transaction done by employee with Credit Card number in payment note field (tag 86). So far we are using fb05 transaction to book the whole statement (booking: Employee: Db, Bank: Cr) and we are not importing the MT940 directly in the system is it possible to somehow automate this process? 1. Import the file, 2 Make same postings automatically based on credit card numbers to employees account. Thank you

[narasimhulu_konnipati]

BDC or LSMW are options.

But i think you can try EBS process. If not, make a custom program and create a batch job which can be scheduled on weekly / monthly / daily to post these entries automatically.

Thanks

[Former Member]

Hi, thanks, I would like to try with EBS process, I have done it for all incoming statements but do not have experience with outgoing when there is no Payment Orders. For incoming statement we have automatic matching - I have used search string functionality and set correct intervals in FEBP, so whenever I have Invoice Number in a payment note in incoming payment it is cleared automatically (when amount is correct) or posted on account (when having shortpay or overpayment). I do not know how to set this up when in payment note I have a Credit Card number which is stored in Employee's Master Data, thanks

[former_member313549]

Yo might want to consider using an LSMW or program a program to read the file and posts the GL entry.