Improve Your Lockbox Performance with User Exits, a Reformat Program, and Customized Reports

  • by Qian Sharon Tang, System Program Manager
  • May 15, 2003
In a typical implementation of lockbox service, users frequently encounter process, data, or functionality issues that are not controllable by the standard configuration. The author draws on her recent experience with a lockbox implementation to show how to develop workarounds with user exits and reformat programs.

Payment transactions in the United States are made almost exclusively in the form of checks. Banks offer lockbox service to accelerate the processing of the checks. Customers send payments directly to the lockbox bank. The bank deposits the checks and sends the remittance information to the payee via file transfer. The R/3 lockbox program reads this file and updates cash and receivables accounts automatically.

Manual effort is eliminated for most transactions and is required only for those items that fail to post. Lockbox greatly reduces the float time and expedites payment processing, reducing days for sales outstanding and maximizing cash application productivity and cash flow. It is especially important if a company’s business is too large for manual posting to be a viable, cost-effective option. (See, "What Is a Lockbox?" below.)

Despite the advanced functionality lockbox offers, it is not a very customizable function in R/3. It has only three tables for its configuration: T049L, T049A, and T049B. The headache of implementing the lockbox process comes from the need for creative use of limited customization to cope with unlimited customer lockbox data scenarios.

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.