on 06-03-2008 9:08 PM
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
User | Count |
---|---|
108 | |
12 | |
11 | |
6 | |
6 | |
4 | |
4 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.