Skip to Content
0

EBS search string bank charges

Nov 15, 2016 at 09:20 PM

94

avatar image

Hi

We use SAP transaction FF_5 for posting our EBS in MT 940 (SWIFT MT940 - Field 86: Structure Recognized Automatically). The problem is when we have a transaction on our bank statement file that looks like the following:

:61:1604050405C164311,00NTRF0013761//609694XXXXx1 45 :86:/FR045/TRANSFERTS RECUS /RFB/INV.1100MIDDLE EAST PHARMA/ORDP//NAME/MIDDLE EAST PHARMACEUT ICAL CO.LTD./REMI//RFB/INV.1100000231/32/OCMT/EUR164366,00//CHGS/ EUR55,00//PDO/SA ARABIE SAOUDITE


The difference between received amount and OCMT amount is due to bank charges shown in the Notes as /CHGS/EUR55,00

The EBS mapping for to debit g/l bank account (100100) and credit intermediate account(100105) with 164311,00
Also the EBS mapping works so it debits the intermediate account(100105) and credits my customer account (1800206) with 164366,00. This I believe is wrong and needs to be corrected. SAP should take the 16311,00, which we had received and then match this figure with a invoice having that figure. Then SAP should take the difference between the customer invoice and received amount and place on a bank charge cost account.


How do I achieve this using the string functions in SPRO?

Best Regards,

Barbara McCourt

ebs
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Primitivo Velez Collantes Jul 07, 2017 at 08:18 AM
0
Share
10 |10000 characters needed characters left characters exceeded