Skip to Content
author's profile photo Former Member
Former Member

Lockbox - IDOC

Hello,

The question is related to lockbox processing using IDOC (as opposed to BAI). The issue I am having is with interpretation o the document number that comes from lockbox IDOC. Challenge is that most of the time we wouldn't have customer's bank information on the customer master (don't ask me why, it is what it is) so we're going to have to rely on the document search for the most part. Now, when the bank file has SAP document number as reference it all works fine, the problems start when I use a reference document number in the file - then the system is unable to find the invoice to clear. I know that there are user exits that would let one manipulate the processing logic, but even w/o using them there should be a way (I am guessing in IDOC structure itself) to make system look for different fields in the document while searching for open item. Any thoughts would be appreciated.

Thanks,

K.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Jun 03, 2008 at 10:16 PM

    Hi

    In IDOC segment "E1IDQU2-BUSZFO" the external transaction type will be populated

    In T.Code :OT51 for individual external transaction types we will set the algorithms.

    For Ex: if algthm is set to

    021 - it will search for the Reference document number

    020 for Document number ..........

    This search will be on the data populated in the segment

    E1IDT02-TXT01....

    Let me know if you need any further details.

    Thanks

    Kalyan

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi, thanks for response, but I am not sure I really follow the solution:

      First of all, the segment you're refering to is on a higher level then the actual invoice details, also we don't have information in the file from the bank as to what number is being transferred - reference number or invoice number (I don't think bank would even know, because it's totally dependant on what the customer put on their check). Also, what I am trying to achieve actually is that whatever number is transferred is to be used for search in several fields (e.g. first look in BELNR, then look in XBLNR etc.).

      One more thing, the customizing you're referring to, I was under the impression that this customizing is for the electronic bank statement and lockbox had it's own piece in the IMG (quite small, only couple of steps). Are you saying that you, guys, are using the electronic bank statement functionality to process the lockbox file? Which transactions are you using to process the IDOC that came in: flbp and feba_lockbox or others?

      Thanks,

      K.

  • author's profile photo Former Member
    Former Member
    Posted on Jun 04, 2008 at 09:19 PM

    One of the FLB2 on screen processing options is field "Invoice Numbers"

    What value are you using when you import the lockbox program?

    If you use value 3 or 4, it the program will automatically check both the reference number and the document number fields in SAP when trying to match the invoice.

    I believe this could solve your issue without any special customization

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.