Skip to Content

EBS Search Strings, algorithms, user exit: Find ref num & get to XBLNR

Hello Colleagues,

I have checked these and other forums, but have not found the information I need, so would be grateful for some help.

I am working with Electronic Bank Statements for the first time, and having some trouble. As a start, I am working with incoming payments and trying to extract the reference number from the "Note to Payee" so that we can match on XBLNR. This field contains all sorts of gibberish, but we do have a specified format on the invoice numbers. For example, the Note to Payee might contain:

---

I10IPKW35741 I10IPKW35740 I10IPKW35 739 I10IPKW35738 I10IPKW3573 7 I10IP KW35742 MAP SVERIGE AB BOX 55136 TRANSFER A MT SEK 200,789.68 ORIGINAL AMT SEK 200,789.68 EXCH. RATE SEK 0.4 206 1500 8311007131

---

I have set up the search string as

(I10|I11|I12)????#####

and the search string simulation correctly finds all the embedded references numbers:

I10IPKW35741

I10IPKW35740

I10IPKW35738

I10IPKW35741

I10IPKW35740

I10IPKW35738

Next, I tested the various algorithms against an existing bank statement using FEBSTS. (If I am testing using a bank statement that already cleared, will those documents still be found in the simulation?)

"000" executes the map correctly against the bank statement and returns the embedded invoice numbers, but does not return the related document to be cleared. However, I cannot see that "000" knows what field to key on.

"001", "015", "019", "021", and "121" do NOT return the embedded invoice numbers in the simulation.

Is there any way to make this work using search strings alone, or does the search string merely parse out the invoice numbers, and the rest of the processing must be done in the user exit FEB0001?

As a related question, what are the 900 series algorithms ("Customer-specific algorithm 901", etc.) and how are they managed or configured? Is that something my predecessors created in our implementation?

Thanks in advance.

Patricia

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Jun 18, 2011 at 06:08 PM

    Hi

    While using the interpretation algorithm, did you mentioned the interval range for XBLNR in the FF_5 selection screen? If not, try this once, algorithm 001 requires a interval range in the selection screen to work.

    Thanks

    Nikhil

    Edited by: Nikhil Kothari on Jun 18, 2011 8:25 PM

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Patricia Brainard

      Patricia,

      We use BAI2, not MT940, so that might explain the difference in processing of the interpretation algorithms.

      Regards,

      Shannon

  • avatar image
    Former Member
    Jun 24, 2011 at 06:12 PM

    Hi Patricia

    Ideally Algo 001, would serve your purpose. It works fine for me for MT940 unstructured format :).

    I think the problem for you would still arise for the interval range to be maintained in the selection screen.

    Just check if we can give special character in the selection screen or not.

    For me, i use interval range for both belnr and xblnr 000..000 to zzz...zzz.

    As you might now tht after numbers alphabet appears i.e. after 0... 9.. aplhabet A/a appears.

    SO you need to check when the special character appears as in your case the reference contains " | ".

    Hoe its helpful.. 😊

    Thanks

    Nikhil

    Add comment
    10|10000 characters needed characters exceeded