MT940 - FF_5 -- Diffrence is too large for clearing

[v_saranya]

Dear All,

   I am getting the below error while uploading MT940 using FF_5 T code. If MT940 file have same date and amount with different two document numbers, we are getting this issue. In OT83 we have maintained 001 standard algorithm.But system is not reading the document number ,it is reading only amount. Kindly help me us the same.

>>>>>>>>>>>>Error F5-263 diffrence is too large for clearing

Thanks & Regards,

V.Saranya

[former_member251898 · Accepted solution]

Hi

Did you maintain the selection parameter in the section Algorithm in FF.5?

BELNR number interval: 1 - 9999999999

XBLNR number interval: 1 -      ZZZZZZZZZZZZZZZZ

If you do not maintain these interval, algorithm 1 does ignore these number therefore only checks the amount.

Cheers

Taro

[v_saranya · Accepted solution]

Dear Taro,

  Thanks for your reply. after maintaining BELNR also i am getting same error. we debugged that code and found the reason. In Tag 61 after BAI Code 16 digit number coming in MT940 file. In code level it is taking last 10 digit number like (0271500014).actually it should take like 0002000271.

Document Number : 0002000271

company code:5000

fiscal year : 14

:61:1412291229DR1000,00NTRF0002000271500014

Can you please tel me is there any possibility to truncate company code and fiscal year  using standard algorithm or some where..else please tel me which algorithm we can use to consider only document number.,

Thanks in Advance.,

Thanks & Regards,

V.Saranya

[Former Member · Accepted solution]

Dear Saranya,

Kindly Change the Algorithm in OT83 to 015:Clearing using assignment number.

Then make sure that the document number is populated in the G/L account assignment in FBl3n, for this maintain the sort key in FS00 of that G/L to 003: Document number.

The system will read both Amount and Document number during ff_5.

Regards,

M S Lokesh

[v_saranya · Accepted solution]

Dear Lokesh,

  Sort key 003 is for posting date.In MT940 file it is Coming with Document number + company code + fiscal year. But if we will give sort key  002 ( it is for document number + Fiscal year ) but there is no company code. kindly confirm is there any other option .

Note: Our issue ,if same amount, same date and different document number , reconciliation not happening.

Thanks in advance.

Thanks & Regards,

V.Saranya

[Former Member · Accepted solution]

Dear Saranya,

Check this document on how Sort key can be configured based on the requirement.

Create the sort key on your specific requirement and assign it to the G/L. Moreover you should also take into consideration that the Tag:61 in MT940 will have only 16 digits as reference field.

So in your case it is Document date (8) + Fiscal year(4)+company code(4) = 16. so your offset in the OB16 sort key should be 0.

This will solve your query.

Regards,

M S Lokesh

[former_member251898 · Accepted solution]

Hi

So your bank is sending the account document information in tag 61 - sub-field 7 (16 digits), which concatenate the account document number + Company code + FY.

Would you please check first if your system has OSS note 396776 applied, which could easily be verified by checking FEBRE table to see if the above information is added with <REF> </REF>?

If you have the subfield 7 information in FEBRe, you can use the search string functionality to retrieve only the first 10 digits number You can implement a search string for <REF>################</REF> to map the first 10 # and ensure that the target field is note to payee.

Would you please try this?

Hope that this helps.

cheers