Skip to Content
0
Oct 21, 2015 at 02:02 PM

Search Strings bank statement: reference field

224 Views

Hi,

I am just trying to look for any invoice reference in the note a payee of the bank statement. As all the invoices have 5 digits I have inlcuded as search string parameter like #####. The program finds what I am looking for (perfect), but also is taking into account other numbers in the note a payee without 5 digits and it is also trying to clear them. Any idea?

Example:

CREDIT/ID//REMI/50312+50311+50313+50337+50362/ISDT/00000000/ULTD//NAME//ID//ULTB//NAME//ID/ /PURP//PRTRY//OCMT/EUR57278,54/EXCH/1.0000000

The program is finding 50312, 50311, etc (5 strings) but also is looking for references in the invoices numbers like "54" or "1". Any idea? Please let me know.

Regards,

Daniel