FI-CA import MT940 file to Multicash

[former_member1232427]

Hi

Is there a standard solution in IS-U to import a MT940 fil to Multicash

Kind regards

Preben Vestbjerg

[AmlanBanerjee]

Hi Preben,

You can use transaction FPB7 (Report-RFKKKA00) for your purpose.

The report selects payments, returns, payment orders, and check encashments that were imported into the bank data storage can be directly transferred to a payment lot, payment order lot, or returns lot.

Check encashments are not saved in a lot, they are posted immediately in the transfer program. As an alternative to the transfer to a lot or direct posting (check encashments), you can output selected data from the bank data storage to a file. You can import these into a payment, payment order, or returns lot in a subsequent step, or for check encashments, run the posting.

When you convert country-specific bank formats into the MultiCash format, you can use this report to transfer data from a MultiCash statement and sales file to payment and returns lots in FI-CA.

You need to perform system settings for the same.

IMG->Financial Accounting->Bank Accounting -> Business Transactions -> Payment Transactions -> Electronic Account Statement ->Make Global Settings for the Electronic Bank Statement.

Define a transaction category for each country and assign the following external transaction codes and the corresponding +/- sign to these transaction categories. To do this, choose Assign External Transaction Codes to Posting Rules. You only have to make the specifications in the columns ExtTrans and +/- Sign. Note that to post negative amounts, you have to maintain the external transaction codes for positive and negative amounts

Also make the following settings under IMG->.Financial Accounting->>Contract Account receivable and payable->Business Transactions -> Payments -> Processing Incoming/Outgoing Payments

• Define Bank Clearing Accounts for Payment Lots
• Define Clarification Accounts
• Define Transactions for Transferring Electronic Account Statement
• Enter the external transaction codes and specify whether they are for payments or returns.
• Define Interpretation Rules for Note to Payee

Hope it helps

Thanks,

Amlan

[former_member1232427]

Hi Amlan

Thanks for your fasr reply. 

I was looking for exactly how to convert a MT940 file to MultiCash.

Kind regards

Preben