For Auto clearing, please check below prerequisite; it is applicable only for manual bank statement upload not for electronic bank statement; for EBRS, we have to define clearance (OB74) criteria and algorithm (OT83) as well.
Manual upload check;
1. Before manual upload, in FBL3N, both Incoming and outgoing open G/L must be filled with UTR or cheque number, etc., you can use ‘Assignment’ or Reference filed.
2. While entering data in FF67, make sure the assignment or reference field should be available for input, then give UTR Number or cheque number as per your case, but it should be the same whatever you have given in FBL3N assignment field.
3. Your posting rule should not be configured as ‘on account’ else it will not check the open item as result system will directly post bank statement without checking open items( We do only in case of Advance payment)
Please check step 1 & 2 carefully and let me know.
Thanks for the reply. Can you also tell me how can I maintain posting rules in case of manual bank statement I have 2 bank accounts. Thank you for your help
Also do we maintain OT43 or OT83 I am confused my requirement is clear the open line items automatically in MBS with reference and algorithm!!
OT83 is compulsory, while OT43 is optional. However, if the allocation field or reference field is not visible, then you have to change your SAP variant; in that case, OT43 also required. I have prepared a document for OT43. Please go through it will help you
Thanks Kalika it is very helpful. I would appreciate if you can send me Posting Rule document. I can confused as to how many posting rule should i create as of now i have creatd 2 rules for incoming and outgoing. Also all 3 gl's(main,income & outgoing GL should not have a tick on post automatically?