Company code gl account 1201005, first union bank company code gl account 1201006, pnc, bank company code 2000 gl account 1201008, wachovia, bank. Configuring sap r3 fico is the only book of its kind. The name used is a combined decision made by client and bank. Each bank has its own standard bai and bai2, hence configuration and testing needs to be done depending on bank file configuration. This pdf depicts various steps for lockbox process configuration.
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. Electronic bank statement and lockbox in sap erp by. This pdf depicts various steps for lockbox process configuration that are. Configuring sap erp financials and controlling download. However i have found very little post regarding post processing aspects of lockbox. Lockbox processing configuration in sap sap materials.
When using lockbox and electronic bank statement it is important to set up the posting rules in sap correctly to avoid incorrect postings. Mashups, web services, and external search providers integration. Move beyond the basics and get the stepbystep instructions you need to configure and run actual costing, group valuation, profit center valuation, and more. 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. 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. 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. Sap lockbox configuration the first step in the configuration is to set the control parameters for lockbox processing. Sap books sap fico books certification, interview questions and configuration. 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.
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. He has implemented solutions in all of the modules within fico for several fortune 100 companies in several. Krishan kumaroverviewauto lockbox is a service that commercial banks offer corporate customers to enable them tooutsource their accounts receivable payment processing. You can define lockboxes in sap by using one of the following navigation methods. Sap customizing implementation guide financial accounting bank accounting bank. While implementing sap r3 or sap erp financials, consultants always look for sequential steps that need to be followed. Execute the following transactions to test the lockbox configuration flb2 main lockbox program that uploads the lockbox file data. A lockbox is a bankoperated mailing address to which a company directs its customers to send their payments. Download for offline reading, highlight, bookmark or take notes while you read electronic bank statement and lockbox in sap erp. 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. I have come across many documents explaining the configuration and functionality for lockbox implementation in sap. First 4 character represents the name of the client. Each lockbox must have its own unique destination and origin combination, and also must be defined for a single company code in configuration.
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. Click download or read online button to get configuring sap r 3 fi co book now. On the posting data overview screen, click on new entries button to create new lockbox posting data as per organization requirements. This document is intended to explain the different aspects of postprocessing data and assist users to successfully processing the file data. This service is mainly provided by banks in the united states. This field should contain the destination code the bank submits to you in your lockbox file. The united states, unlike much of the world, still relies heavily on paper checks for payments. Images and data are stored based on a selected duration period and can be accessed andor downloaded for that set period of time. During the transition you bank may be able to direct customer payments sent to lockbox b and c into lockbox a. Lockbox is an account in the house bank which handles the receipt and processing of incoming payments in sap. In our previous training tutorials we have learnt how to define lockboxes for house bank in sap.
Configure the fi and co modules to meet all your business requirements. Define house banks define lockbox accounts for house banks define control. Companys than upload these files in sap and update their balance and clear customers i. Sap erp financial accounting and controlling unquote books. Bank of america lockbox job aid page 5 of 10 job aid 6. In sap financials closing operations user guide book, we will look at. Bai2 format for lockbox erp financials community wiki. Lock box processing in sap free download as word doc. Processing the electronic bank statement in sap for advanced users. A summary of the lockbox data will appear on the lockbox data overview.
The purpose of this page is to clarify the understanding of the bai2 format for lockbox, such as characters and segments of the file. Lockbox posting data the following sap training tutorials guides you how to define lockbox posting data in sap step by step. Sap fico books certification, interview questions and configuration. Jan 01, 2014 electronic bank statement and lockbox in sap erp ebook written by lennart ullmann. 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 solutions for them. Note that this line item contains the customer invoice number in the value field. Configuring lockbox for cash application in sap fico. 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. Define lockbox posting data in sap sap training tutorials. Therefore, accurate payment data is necessary for automatic clearing to take place. Electronic bank statement and lockbox in sap erp ebook written by lennart ullmann. A lockbox system is an excellent way to reduce mail float for a larger company that has a national or international customer base. 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. A subapplication and not a subledger within financial accounting fi. Configuring sap erp financials and controlling wiley. When the files are imported, the bank data file creates a payment.
Configuring sap erp sales and distribution by kapil sharma. Update the destination code that bank submitted in your lockbox file. Unlock the potential of the material ledger in sap s4hana with this comprehensive guide. This uptodate quick reference guides the reader through the most popular sap module. Sap transaction code flbp post lockbox data sap tcodes the best online sap transaction code analytics. 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 erp financial accounting and controlling configuration and use management book also available for read online, mobi, docx and mobile and kindle reading. Banks offer lockbox service to help companies process. Run the post process lockbox transaction select the menu path accts recvcash mgmt period end closing post process lockbox.
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. The first and only book to offer detailed explanations of sap erp sales and distribution. Peter jones is a platinum principal consultant for sap america and speaks regularly at sapsponsored events. Line item data screen enter the payment amount into the item 1 payment amount field and confirm that the invoice number. The scanned images are posted to a secure website, where the companys accounting staff can access the images to.
Configuring sap r 3 fi co download ebook pdf, epub. On the following screen select lockbox and click the button to display the details for the control parameters. Configuring sap r 3 fi co download ebook pdf, epub, tuebl, mobi. Com page 2 of 25 lock box functionality in sap ecc 6. Double click on the date of the lockbox file you wish to view. Features it includes the management of bank master data, cash balance management check and bill of. Select the pdf form checkbox to print the check lot in the cash journal in pdf for mat.
He is also on the technical advisory board and an editor for fico expert. Lockbox configuration enables as a reference for customer master accounts and customers know where to send there payments. Please let us know if you find this entries as per the requirements. This step is usually already done by default in most ecc 6. These criteria is decided during the initial stages of setting up lockbox process. 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. Sap sap has standard configuration to support lockbox file processing using both formats. The bank opens the incoming mail, deposits all received funds in the companys bank account, and scans the payments and any remittance information. It seems to be one of the better books for sap that we have bought. 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. Sap transaction code flbp post lockbox data sap tcodes.
Familiarize yourself with lockbox file record formats and learn more about the importance of customer master records in the lockbox process. The following sap training tutorials guides you how to define lockboxes accounts at house banks in sap step by step. Configuring financial accounting in sap erp amazon s3. Sap material ledger with sap s4hana sap press books.
May 10, 2012 the lockbox program uses detailed information from the payment advice to automatically search and match customer open items. Configuration and use management is in fact the most comprehensive and easytofollow sap fico configuration book in the market. 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. Now let us see, how to configure lock box functionality in sap. 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. In this chapter, i provide the most common objectoriented configuration steps in a sequence with path and transaction codes. Click download or read online button to get configuring sap erp financials and controlling book now. Jul 23, 2009 lockbox is an account in the house bank which handles the receipt and processing of incoming payments in sap. That way, youll only get one file and all the cash goes into the same bank account. 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. Verify forms, reports, user interfaces, and 3rd party integration verify scoping configuration. Sap online help which is not in pdf files can be printed only relatively complex.
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. 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. 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. Spro img financial accounting bank accounting business transactions. On the lockbox posting data configuration screen, update the following fields. 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. 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. Define lockboxes for house banks in sap sap training tutorials. Concept of lockbox erp financials community wiki sap. Sap is the world leader in enterprise resource planning erp software. Lockbox assignment on customer master lockboxes are assigned on customer master records and determine which remit to address is printed on the customers invoices.
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. It includes material on sap erp financials, sap fico, and sap r3. Fica configuration step by step sap expertise consulting. This acticle explain the crux of sap lock box process, bai 2 format etc. Dec 21, 2009 this uptodate quick reference guides the reader through the most popular sap module. This site is like a library, use search box in the widget to get ebook that you want. Electronic bank statement and lockbox in sap erp espresso. John burger is senior director of global sourcing at mckesson. Electronic bank statement and lockbox in sap erp by lennart. Lockbox process configuration, pdf book in sap fico. 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. Configuration steps in sap fica this post will describe you briefly, which basic configuration steps to be followed for sap fica module implementation. Consult detailed screenshots and expert guidance as you dive deep into the major processes. Usually both the entries are shipped default with sap r3 software.
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. Update the destination code that bank submitted in your lockbox file origin. In sap tolerance limits are set for users and customer accounts with the stricter limits applying. 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. This book provides guidance and examples to help you optimize your daily. We will go into detail on lockbox functionality, including the posting process and configuration.
1198 692 170 1420 1372 285 16 521 44 19 1209 1146 1597 307 1227 272 320 1179 245 660 939 1149 270 69 191 1258 942 1361 147 208