Document Splitting for Residual Invoice(Cross CC Lockbox and Manual Cash Receipt)

[Former Member]

We have recently implemented the user exits EXIT_RFEBLB20_002 and EXIT_RFEBLB20_001 to enable the cross company code lockbox. It is working great except for when we have a customer that under or overpays an invoice and we need to post a residual invoice in a company code different than the lockbox company code. I found an SAP blog post (which unfortunately seems to have been deleted within the last week) that said to make the following changes in the document splitting configuration to allow residuals to post correctly:

1) Change the business transaction for the customer payment document type to 1010 (clearing transactions).

2) For the business transaction variant assigned to transaction type 1010, change the "Further Subdivision in Document" section to the setting "After Each Logical Transaction."

This actually did seem to get the correct end result (it cleared all the original invoices and posted a residual invoice on the correct company code), however, it appeared to split the dollar amounts in a strange way that did not make sense.

Another point to note is that if we try to post a manual cross company code residual invoice through F-28, it cannot correctly derive the profit centers and ends up using the constant for unassigned processes which we do not want. I am not sure how this is happening since lockbox and F-28 are both using the document types, same business transaction and transaction variant yet they get different results.

Has anyone been successful in getting the cross company code residual invoice to post in both the lockbox and manually in F-28? I have attached a spreadsheet of the entries I am getting from the lockbox.

cross-company-code-lockbox-residual.png

Any input on this issue is greatly appreciated!

Thank You,

Melissa

[Former Member]

Just checking back if anyone has any ideas of how to configure the document splitting for residual cross company code invoices? I have tried many different combinations of business transactions/variants but it always results in an incorrect entry or part of the entry posting to the profit center for unassigned processes because it can't determine the correct profit center.

Any guidance at all would be appreciated.

Thanks!