Electronic Bank Statement - MT940

[aidaj_hilton]

We are planning to implement electronic bank statement using MT940 format via transaction FF_5.  I have loaded a sample file and although I am able to successfully load the bank statement I am unable to complete the post with clearing.  I get the error "FS 263 The difference is too large for clearing".

When creating a BDC and posting online I found that the amount that was being posted was not the correct amount.  This is due to the fact that when converting the value from char to amount it divides by 100.  For example, instead of posting 40,000 XPF it attempts to post 400 XPF.

The opening balance is 0.00 and I have 3 items on the bank statement:

Receipt for 40,000

Disbursement for 4,350

Receipt for 1,985

Closing balance 37,635

The logic occurs in the subroutine   CONV_CHAR_AMOUNT_TO_SAP_AMOUNT in program RFEKA400.

If fixpt = 'X'.                                      "fixed point arithmetic is checked in attributes screen for program RFEKA400

   betrag_pd = betrag_pd / 100.       " i.e. 40000.00/100

endif.

Please find attached copy of my input file and the entries created in FEBKO and FEBEP.

Obviously this transaction has been used successfully for some years so it cannot be an issue with this code.  I would appreciate any suggestions on what configuration changes I need to make to ensure this is loaded and posted correctly.

[Aniket_D]

Hello Hilton

If a currency is not defined in Table TCURX (decimal places for currency codes), then currency is considered as currency with two decimal places. Check if currency XPF is defined in table TCURX or not. Based on input file for XPF currency there seems to be no decimal format. So you need to maintain XPF in table TCURX with decimals value as “0”.

Regards

Aniket

[aidaj_hilton]

Thanks for your response Aniket.  The currency XPF is defined in TCURX with 0 decimal places.   I initially had the amount in the file as 40000,00 and changed it to 40000,   In both cases the amount posted is 400.00