Electronic Bank Statement and Lockbox in SAP ERP
This book provides guidance and examples to help you optimize your daily processing of the electronic bank statement component in SAP. In addition to covering electronic bank statement basics in SAP, you will get tips and tricks for post-processing bank statements and integrating payment advices. You will learn more about advanced features and get tips on how to use search patterns.
In this book, we will also provide an overview of the cash application as part of the order-to-cash process, including lockbox, dispute management and collections management. We will go into detail on lockbox functionality, including the posting process and configuration. Familiarize yourself with lockbox file record formats and learn more about the importance of customer master records in the lockbox process.
This book covers the following topics:
- Processing the Electronic Bank Statement in SAP for advanced users
- Integrating payment advices as of SAP EhP 5
- New functionality for post-processing as of SAP EhP 6
- Lockbox process overview and configuration
View Full Table of Contents
- Foreword
- 1 Importing and Processing Bank Statements in the Standard SAP System
- 1.1 Settings for the Data Import in EhP6
- 1.2 Processing Collective Credit Memos
- 1.3 Processing Financial Information with SWIFT MT942
- 1.4 Processing XML Bank Statements
- 1.5 Return Debits in the Electronic Bank Statement
- 1.6 Summary
- 2 Postprocessing Bank Statements in the Standard SAP System
- 2.1 Postprocessing Transaction FEBAN
- 2.2 Definition of Postprocessing Transactions in EhP6
- 2.3 Postprocessing Transaction FEB- BSPROC in EhP6
- 2.4 Summary
- 3 Integration of Payment Advices in the Standard SAP System
- 3.1 Use of Payment Advices in SAP
- 3.2 Payment Advices in Cash Management
- 3.3 Payment Advices in the Electronic Bank Statement
- 3.4 Enhancement Options from EhP5
- 3.5 Summary
- 4 Lockbox overview
- 4.1 What is a lockbox and how does it work?
- 4.2 Business process overview
- 4.3 Advantages of lockbox
- 4.4 Lockbox vs. Electronic Bank Statement
- 4.5 Summary
- 5 Lockbox process in SAP
- 5.1 Main lockbox program RFEBLBOO
- 5.2 Main lockbox program RFEBLB30
- 5.3 Payment advices as part of the lockbox process
- 5.4 Lockbox postprocess
- 5.5 Updating customer bank information
- 5.6 Summary
- 6 Lockbox configuration
- 6.1 Define control parameters
- 6.2 Define posting data
- 6.3 Define lockboxes for house banks
- 6.4 Summary
- 7 Lockbox file record formats
- 7.1 Difference between BAI I BAl2 formats and EDI ANSI 823
- 7.2 BAI I BAl2 file format
- 7.3 Summary
- 8 Customer master record
- 9 Electronic bank statements in North America (Appendix)
- 9.1 BAl2 file format for electronic bank statements
- 9.2 BAI preprocessor
- 9.3 Common business transaction codes (BTC)
- 9.4 Interpretation algorithm for outgoing checks
- 9.5 Summary
- 10 Useful programs
- 10.1 Lock box file creating programs
- 10.2 RFEBKA96-Delete buffer
- 10.3 Summary
- 11 Quick Reference Guide
- 11.1 Transaction codes
- 11.2 Reports
- 11.3 Tables (Maintenance)
- A The Authors
- B Index
- C Disclaimer
