cancel
Showing results for 
Search instead for 
Did you mean: 

Lockbox Enhancement Issue

Former Member
0 Kudos

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.

Accepted Solutions (0)

Answers (2)

Answers (2)

manish_patel2
Participant
0 Kudos

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

fernando_evangelista
Contributor
0 Kudos

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

Former Member
0 Kudos

I have same issue where lockbox belongs to company 1000 but invoice is posted in company 1050. Have implemented exit_rfeblb20_001 and exit_rfeblb20_002 trying different combinations of populating AVIK-BUKRS = 1050, AVIP-BUKRS = 1050, AVIP-ABWBU = 1050. In all cases RFEBBU00 still attempts to select open items from lockbox company 1000. In debug, when we get to SAPMF05A, screen 710, where it specifies the criteria for open item selection it still shows company code 1000. When this is manually changed to 1050 the transaction posts correctly. Any suggestion how to properly populate the open item selection criteria? I have seen some documentation that this program looks at FEBCL for clearing criteria but FEBCL is empty.

Regards,

Linda

0 Kudos


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