He is also on the technical advisory board and an editor for fico expert. Configuring lockbox for cash application in sap fico. Lockbox is an account in the house bank which handles the receipt and processing of incoming payments in sap. This document is intended to explain the different aspects of postprocessing data and assist users to successfully processing the file data. The document number on the payment advice is matched against the document number in the customer open item file. Unlike most books that only provide questions and answers for certification or interview preparation, this book covers fifty common business situations related to erp financialsfico and provides practical. Jan 01, 2014 electronic bank statement and lockbox in sap erp ebook written by lennart ullmann. On the lockbox posting data configuration screen, update the following fields. Sap books sap fico books certification, interview questions and configuration. Sap fico books certification, interview questions and configuration. Sap is the world leader in enterprise resource planning erp software.
During the transition you bank may be able to direct customer payments sent to lockbox b and c into lockbox a. Configuring financial accounting in sap erp amazon s3. The main lockbox program will debit the bank clearing account for accounts receivables and post a credit entry to the bank clearing account for incoming checks lockbox. You can define lockboxes in sap by using one of the following navigation methods. Define lockbox posting data in sap sap training tutorials. Lockbox processing configuration in sap sap materials. If a customer is identified by the document number but the bank details do not correspond to the micr number, they can be added via the optional batch input session. Overview a wider knowledge about the file structure you are uploading to your sap erp allows you to avoid many problems those looks like to be application issues. On the posting data overview screen, click on new entries button to create new lockbox posting data as per organization requirements. Lock box processing in sap free download as word doc. That way, youll only get one file and all the cash goes into the same bank account. This book provides guidance and examples to help you optimize your daily. The united states, unlike much of the world, still relies heavily on paper checks for payments. Company code gl account 1201005, first union bank company code gl account 1201006, pnc, bank company code 2000 gl account 1201008, wachovia, bank.
Processing the electronic bank statement in sap for advanced users. Jul 19, 20 lockbox process in sap this document depicts a implementation, automation of incoming account receivable process in sap, called as lockbox process surya padhi friday, 24may20 2. Configure the fi and co modules to meet all your business requirements. Configuring sap erp financials and controlling download. Sap transaction code flbp post lockbox data sap tcodes the best online sap transaction code analytics. While implementing sap r3 or sap erp financials, consultants always look for sequential steps that need to be followed. Line item data screen enter the payment amount into the item 1 payment amount field and confirm that the invoice number. In our previous training tutorials we have learnt how to define lockboxes for house bank in sap. Krishan kumaroverviewauto lockbox is a service that commercial banks offer corporate customers to enable them tooutsource their accounts receivable payment processing. Unlock the potential of the material ledger in sap s4hana with this comprehensive guide. It is rarely necessary for a smaller company with a local customer base to use more than a single lockbox at a local bank, since any reduction in mail float is more than offset by the related bank fees. The bank must transmit the file with the destination, origin and lockbox identifiers in the exact format as they have been created in sap lockbox configuration. Execute the following transactions to test the lockbox configuration flb2 main lockbox program that uploads the lockbox file data.
Today the growing global interest in erp solutions and particularly sap gives abacus sap academy graduates. Define lockboxes for house banks in sap sap training tutorials. A summary of the lockbox data will appear on the lockbox data overview. Com page 2 of 25 lock box functionality in sap ecc 6. Feb 25, 20 the purpose of this page is to clarify the understanding of the bai2 format for lockbox, such as characters and segments of the file. Sap customizing implementation guide financial accounting bank accounting bank. This step is usually already done by default in most ecc 6. This site is like a library, use search box in the widget to get ebook that you want. A lockbox is a bankoperated mailing address to which a company directs its customers to send their payments. A lockbox system is an excellent way to reduce mail float for a larger company that has a national or international customer base. Concept of lockbox erp financials community wiki sap. Electronic bank statement and lockbox in sap erp by. Bai2 format for lockbox erp financials community wiki. Sap ag bank accounting fi bl bank accounting fi bl april 2001 7 bank accounting fi bl purpose this component is used to handle accounting transactions that you process with your bank.
Familiarize yourself with lockbox file record formats and learn more about the importance of customer master records in the lockbox process. Update the destination code that bank submitted in your lockbox file origin. Unlike most books that only provide questions and answers for certification or interview preparation, this book covers fifty common business situations related to erp financialsfico and provides practical solutions for them. Each bank has its own standard bai and bai2, hence configuration and testing needs to be done depending on bank file configuration. The scanned images are posted to a secure website, where the companys accounting staff can access the images to. This field should contain the destination code the bank submits to you in your lockbox file. Now let us see, how to configure lock box functionality in sap. Configuring sap erp financials and controlling wiley. This pdf depicts various steps for lockbox process configuration that are.
May 10, 2012 the lockbox program uses detailed information from the payment advice to automatically search and match customer open items. Consult detailed screenshots and expert guidance as you dive deep into the major processes. Configuring sap erp sales and distribution by kapil sharma. When ever a sales is made party will credit payment to this lock box account in terms of certain invoice in house bank so in that scenario bank will update the data every day by sending a bai1 and. Features it includes the management of bank master data, cash balance management check and bill of. This service is mainly provided by banks in the united states.
Lockbox online viewing the lockbox online viewing provides a robust image archive, reporting, search, and user administration tool to manage the payment information received and scanned at the lockboxes. Peter jones is a platinum principal consultant for sap america and speaks regularly at sapsponsored events. A subapplication and not a subledger within financial accounting fi. Spro img financial accounting bank accounting business transactions. When ever a sales is made party will credit payment to this lock box account in terms of certain invoice in house bank so in that scenario bank will update the data every day by sending a bai1 and bai2 bank adminstrative. Double click on the date of the lockbox file you wish to view. Bai2 format for lockbox erp financials community wiki sap. Download sap erp financial accounting and controlling configuration and use management in pdf and epub formats for free. Companys than upload these files in sap and update their balance and clear customers i. Configuring sap r 3 fi co download ebook pdf, epub, tuebl, mobi. It incorporates a handson approach, with hundreds of screen shots and practical examples, that allows a person without prior configuration training to make sap fico ready. He has implemented solutions in all of the modules within fico for several fortune 100 companies in several. Sap lockbox configuration the first step in the configuration is to set the control parameters for lockbox processing. The purpose of this page is to clarify the understanding of the bai2 format for lockbox, such as characters and segments of the file.
Run the post process lockbox transaction select the menu path accts recvcash mgmt period end closing post process lockbox. This document explain about step by step configuration and processes for sap lock box functionality. When ever a sales is made party will credit payment to this lock box account in terms of certain invoice in house bank so in. Sap erp financial accounting and controlling unquote books. As the only book to provide indepth configuration of the sales and distribution sd module in the latest version of sap erp, this valuable resource presents you with stepbystep instruction, conceptual explanations, and plenty of examples. Bank of america lockbox job aid page 5 of 10 job aid 6. Mar 29, 2015 i have come across many documents explaining the configuration and functionality for lockbox implementation in sap. Define lockboxes for house banks in sap sap training. Images and data are stored based on a selected duration period and can be accessed andor downloaded for that set period of time.
The book is a little out of data as most of the screenshots seem to be taken from earlier versions of the software and we were running version 6. It includes material on sap erp financials, sap fico, and sap r3. Lockbox assignment on customer master lockboxes are assigned on customer master records and determine which remit to address is eap on the customers invoices tolerance settings when an incoming cash payment does not exactly pay the referenced open item sthe system will create a residual. Configuration steps in sap fica this post will describe you briefly, which basic configuration steps to be followed for sap fica module implementation. In this chapter, i provide the most common objectoriented configuration steps in a sequence with path and transaction codes. This pdf depicts various steps for lockbox process configuration. In sap tolerance limits are set for users and customer accounts with the stricter limits applying. Verify forms, reports, user interfaces, and 3rd party integration verify scoping configuration.
It seems to be one of the better books for sap that we have bought. Mar 11, 2015 when using lockbox and electronic bank statement it is important to set up the posting rules in sap correctly to avoid incorrect postings. Configuring sap r 3 fi co download ebook pdf, epub. This uptodate quick reference guides the reader through the most popular sap module. I have come across many documents explaining the configuration and functionality for lockbox implementation in sap. However i have found very little post regarding post processing aspects of lockbox. Sap transaction code flbp post lockbox data sap tcodes. Configuring sap r3 fico is the only book of its kind.
Click download or read online button to get configuring sap r 3 fi co book now. These criteria is decided during the initial stages of setting up lockbox process. Click download or read online button to get configuring sap erp financials and controlling book now. Therefore, accurate payment data is necessary for automatic clearing to take place. Lockbox configuration enables as a reference for customer master accounts and customers know where to send there payments. Electronic bank statement and lockbox in sap erp ebook written by lennart ullmann. Lockbox process configuration, pdf book in sap fico. Define house banks define lockbox accounts for house banks define control.
Lockbox posting data the following sap training tutorials guides you how to define lockbox posting data in sap step by step. Electronic bank statement and lockbox in sap erp espresso. Lockbox online viewing the lockbox online viewing provides a robust image archive, reporting, search, and user administration tool to manage the payment information received and scanned at the lockbox es. Dec 21, 2009 this uptodate quick reference guides the reader through the most popular sap module. Processing the electronic bank statement in sap for advanced users integrating payment advices as of sap ehp 5 new functionality for postprocessing as of sap ehp 6 lockbox process overview and configuration. Sap erp financial accounting and controlling configuration and use management book also available for read online, mobi, docx and mobile and kindle reading. Lockbox process configuration, pdf book in sap fico please modify the t code as xd03 for customer master data in the document and suggested to avoid typo erors. The first and only book to offer detailed explanations of sap erp sales and distribution. Jul 23, 2009 lockbox is an account in the house bank which handles the receipt and processing of incoming payments in sap. Banks offer lockbox service to help companies process. Sap material ledger with sap s4hana sap press books. When using lockbox and electronic bank statement it is important to set up the posting rules in sap correctly to avoid incorrect postings. Select the pdf form checkbox to print the check lot in the cash journal in pdf for mat. Lockbox assignment on customer master lockboxes are assigned on customer master records and determine which remit to address is printed on the customers invoices.
Update the destination code that bank submitted in your lockbox file. On the following screen select lockbox and click the button to display the details for the control parameters. Usually both the entries are shipped default with sap r3 software. Mashups, web services, and external search providers integration.
Configuration and use management is in fact the most comprehensive and easytofollow sap fico configuration book in the market. Note that this line item contains the customer invoice number in the value field. We will go into detail on lockbox functionality, including the posting process and configuration. In sap financials closing operations user guide book, we will look at. The bank opens the incoming mail, deposits all received funds in the companys bank account, and scans the payments and any remittance information.
Move beyond the basics and get the stepbystep instructions you need to configure and run actual costing, group valuation, profit center valuation, and more. Each lockbox must have its own unique destination and origin combination, and also must be defined for a single company code in configuration. Configuring lockbox for cash application in sap fico slide blue. The following sap training tutorials guides you how to define lockboxes accounts at house banks in sap step by step. John burger is senior director of global sourcing at mckesson. Sap sap has standard configuration to support lockbox file processing using both formats. Hence if you are not comfortable with bank file format either you can approach them to modify it depending on your requirement else abap can help in writing. Lockbox process in sap this document depicts a implementation, automation of incoming account receivable process in sap, called as lockbox process surya padhi friday, 24may20 2. First 4 character represents the name of the client. The lockbox program uses detailed information from the payment advice to automatically search and match customer open items.
The name used is a combined decision made by client and bank. A lockbox account is usually a designated post office box which has the company name but the customer configurayion are actually received by the bank. Download for offline reading, highlight, bookmark or take notes while you read electronic bank statement and lockbox in sap erp. Please let us know if you find this entries as per the requirements. Sap online help which is not in pdf files can be printed only relatively complex. Electronic bank statement and lockbox in sap erp by lennart. Written by the experts responsible for r3 configuration in a fortune 200 company, it provides detailed instructions and examples for all the financial and controlling.
18 545 329 1192 734 163 191 1264 4 131 26 1362 243 1592 673 1509 715 1388 1507 106 644 1443 169 1095 1141 117 709 923 161 884 419 683 604 453 640 292 953 1483 490