Skip to Content
0
Former Member
Jun 06, 2008 at 10:28 AM

MT940 statement BACS DME auto clearing

273 Views

Hi Friends,

Needed some help on automatic clearing of bank open items when processing electronic bank statement (MT940 format). When automatic payment is done through F110 , a DME file is created. In the bank statement config , the external transaction (NDDT) of HSBC bank is mapped to internal posting rule with clearing algorithm 019 - DME refrence number.

Bank in the MT940 statement must have BACS reference number.Usaually a 10 digit number if we use SAP delivered DME for BACS (GB_BACS). But this number does not appear in the file created. This can be seen in the details tab of the file. In the file created , there is another refrence which starts with SAPBACS00000xxxxx.(Note: a search string has been defined to pull the 10 digit numeric from this string). Earlier when i used to put this reference ..SAPBACS.... or the 10 digit number , open items used to be automatically cleared. Now it is not happening.

Does anyone have some more input on BACS items auto clearing during Electr Bank rec.

Regards

Ajit