Advanced Techniques to Optimize R/3 Lockbox Performance and Accelerate Cash Receipts

  • by Qian Sharon Tang, System Program Manager
  • July 15, 2006
Take full advantage of lockbox functionality with these advanced tips. Learn about two user exits that can increase lockbox efficiency.
Key Concept

Lockbox is a service provided by US banks that facilitates the collection and processing of customer payments. Instead of sending their payments to you, your customers send payments to a central bank location (usually a post office box). The bank credits your account, consolidates the remittance data from multiple customers into a flat file per BAI or BAI2 format, and sends the file to you via file transfer. You then use the data to clear customer open items and record the collection of the cash. SAP provides a standard functionality to import and process the data file for automatic matching and clearing of customer open items.

After I wrote an article about lockbox basics and intermediate techniques in May 2003, I received numerous inquiries from readers regarding ways to address more complex business scenarios. As a response, I conceived this article to share some of the advanced techniques, many of which are largely undocumented by SAP, with more readers. I’m focusing only on lockbox using the BAI and BAI2 format instead of IDocs.

I’ll briefly cover the overall processing logic of the main lockbox program and then dive into specific techniques you can employ to optimize lockbox performance.

Qian Sharon Tang

Qian (Sharon) Tang is a system program manager who is responsible for the support and development of various areas of SAP systems. Prior to this, she was a senior FI/CO application consultant at SAP China. She has been working with SAP since 1995, with emphasis on FI/CO modules such as FI-GL/AR/AP/SPL, CO-CCA, CO-PC, CO-PA, CO-ML, EC-PCA, and cross-module integration between FI/CO and logistics. She also has experience with MM, SD, SM, and PP.

See more by this author


No comments have been submitted on this article. 

Please log in to post a comment.

To learn more about subscription access to premium content, click here.