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

Lockbox Enhancement Issue

Hi All FI Gurus,

We are facing issue with the Lockbox program enhacement related to the Cross Company Company Posting. We did the enhacement in the User Exit EXIT_RFEBLB20_002 but when I am trying to run a scenario where we have Acc doc to be cleared from 2 diff company codes its not working , so the enhacement basically is not working properly.

Requirement explained with example below:

The import program RFEBLB00 (run through transaction FLB2) should be able to apply payments against invoices which belong to a different company by using the invoice number. So, for example a payment might come in with lockbox file for Company 0036. However, if the invoice identified belongs to Company 0004 then the payment should be applied towards that invoice with the right intercompany receivable and payable transactions. This function is not a standard feature of the SAP Lockbox processing. The standard processing will post these payments into clarification. Hence an enhancement is needed to be able to do this function.

Let me know if anyone have any insight on this.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Posted on Aug 02, 2011 at 09:13 PM

    Hi Sidd_raj,

    Standard SAP Lockbox functionality allows postings within one company

    code. To clear open items across multiple company codes, a user exit

    must be written/inserted within program RFEBLB20.

    The intercompany posting can only work with a User Exit which fills e.g.

    the field alternate company code (AVIP-ABWBU) in the payment advice. The

    User Exit '001' in function exit_rfeblb20_001 allows you to change the

    complete payment advice. The interface looks as follows:

    • call userexit

    call customer-function '001'

    exporting

    i_avik = avik

    importing

    e_avik = avik

    tables

    t_avip = xavip

    t_avir = xavir.

    Within this user exit it is necessary to determine the alternate

    company code and the information needed to post such intercompany

    clearings.

    Kind Regards,

    Fernando Evangelista

    Add a comment
    10|10000 characters needed characters exceeded


    • Hi to All,

      We are also having problems getting the usesr exit to wrok as we have anticipated it should. We have activated both EXIT_RFEBLB20_001 and EXIT_RFEBLB20_002. We are attempting to post cash to company 3000, where the lockbox is defined. The invoice 18107001, that is being paid belongs to another company code, 1000.

      We have updated AVIP-ABWBU to be the company code 1000. We have also updated fields
      AVIP-ABWKO and AVIP- KONTO to reflect the customer number for the invoice that was posted to BSID. It appears that we are writing 2 records to AFIP for every record written to AVIK.

      The first update program ends in an error message: Accounts Receivable posting Error: ( F5 170 No open items were found) and a Posted on account classification of the payment posted. FS10n shows the amount posted to the cash account. This customer is defined for both companies 1000 & 3000. On the next report output we get the messages, No customer with MICR number and *18107001 Document not found.

      The clearing piec of the lockbox applications is not looking at company code 1000 open items. It is still looking at company code 3000. Please what can we do now to guide the clearing to company code 1000 and generate the cross company entries.

      Thanks,

      Connie

  • Posted on Sep 11, 2011 at 05:57 PM

    Hello all,

    We just implemented this process, and it is generating correct intercompany postings for us. In the include corresponding to EXIT_RFEBLB20_002, you have to put in additional code so that,

    1) You first search BSID for the document number using bsid-belnr (along with other criteria to make sure that you get only one row in return)

    2) Assign the returned company code to the parameter e_bukrs

    Is that you have currently implemented? I can dig in further if necesary.

    However, we are running into a different issue in terms of reconciling residual items after activating this user exit. I have started a separate thread. Please share your thoughts on it, if any.

    Regards,

    - Manish Patel

    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.