For quite sometime ,the SAP community has been wanting to simplify lockbox processing in SAP. The lockbox configuration steps are easily available on the internet. However following links are really helpful
www.financialsexpertonline.com/downloads/Tang_lockbox.docwww.sapdocs.info/sap/fico/lockbox-process-configuration-in-sapBut one question that the standard lockbox configuration does not answer is how to have one lockbox file post both on account for some customers and create residual item for other customers in the same lockbox batch file.
I was always wondering that there might be an option to do this albeit not a standard one. Following is my solution
- All customers for whom the payment has to be posted on account will be stored in a custom table
- The payment advice is imported in the SAP system by the lockbox program
- The payment advice is stored in the table AVIK before posting . Table AVIK has an indicator to specify post on account as shown below which is unchecked by default.
4. A USER EXIT (for program RFEBL030- you can go to CMOD and search) will supply the customer number at this point and it will check it against the entries in custom table to see if the customer payment has to go on account.
5. The indicator is checked for all such customers and the payment is posted on account for such payment advices.
6.The remaining payment advices will post as usual
If some one needs further help, please post comments with your mail ID. I will surely help.
Happying SAPping