2012 Aug 07 10:04 AM
Hi
Is there a standard solution in IS-U to import a MT940 fil to Multicash
Kind regards
Preben Vestbjerg
2012 Aug 07 11:17 AM
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
Hope it helps
Thanks,
Amlan
2012 Aug 07 11:44 AM
Hi Amlan
Thanks for your fasr reply.
I was looking for exactly how to convert a MT940 file to MultiCash.
Kind regards
Preben