Electronic bank statement in Foreign Currency

[Former Member]

Hi,

We have set up the system so as to create a payment order when automatic payment program is run. Now, we have a scenario, where house bank is in local currency - SEK. This is used to pay the invoices in foreign currencies USD, DKK etc using automatic payment program. The electronic bank statement  we receive from the bank has transactions in different currencies. We convert this  to multicash format using DME engine, mapping the amounts in local currency to the statement and item file.

When  try to clear the invocies by importing this multicash statement, following error message is generated.

Message no. F5794 i.e. XXX  is not a payment order for currency XXX. Correction required.

.

Any ponters to solve the issue.

Appreciate the help in this regard!

Thanks

/Vartika

[narasimhulu_konnipati]

It seems, the Payment order currency in SAP and the EBS file are different. In SAP, you made the payment in say per example Payment order 1234 in USD. If the same order number is appearing with the currency EUR in EBS file, then it is a mismatch.

Please check

[Former Member]

Hi Narasimhulu,

Thanks for your reply.

The thing is, payment orders are in a foreign currencies - USD , EUR etc. The clearing account is in local currency SEK. The bank statement has amounts both in order currency as well as local currency for every order. But when we are clearing using multicash, we are trying to pass the amounts in local currencies for each order. This is because,  as far as i understand, it is the currency in multicash statement file that is used for clearing . And there can be only one record in  multicash statement file. So we have to use the local currency for clearing.

EBS:

1  Payment order 1 - 1000 USD = 7000 SEK

2  Payment order 2 -2000 EUR = 18000 SEK

Multicah Statement File :

25000 SEK

Multicash Item File :

Payment order 1 -   7000 SEK

Payment order 2 -  18000 SEK

Or is there any other way of handling it ?

Many thanks again!

Regards,

Vartika

[Former Member]

Hi Vartika

Did u got any solution for this.

Regards

Srini

[Former Member]

Hi Srinivas,

Yes, we solved it. The key was to map both transaction amount and document amount/currency in the item file. So for the example i explained in my post, the DME files look like:

Multicah Statement File :

25000 SEK

Multicash Item File :

Payment order 1 - WRBTR =  7000  FWAER = 1000 FWBTR = USD

Payment order 2 -  WRBTR = 18000 FWAER = 2000 FWBTR = EUR

Also clearing is made in posting are 2 so busniess transaction code should be accordingly configured!!

/Vartika