Each business day cru should confirm that the bank of america lockbox file loaded successfully to sap and to ensure that incoming payments have been cleared. Lets explore if the above file needs to be uploaded into sap, what is it an. Once a lockbox file is processed in sap system through tcode flb2 program rfeblb00, it is not always necessary that all the checks have successfully posted. Understanding sd fi integration in very simple terms. Capture data using forms and import that data directly into the sap system. Then bank collects the data and sends either through edi 820 and 823 formats to r3 users edi server standard process. Get help for your sap fico problems sap fico forum do you have a sap fico question.
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. Sap inhouse cash is used to perform what is known as inhouse banking, which provides you with some services that are usually provided by external banks, for example, intercompany cash transfers, loan services, investment services, and net. Lockbox business process, lockbox configuration in sap, lockbox file creation, testing 4. This acticle explain the crux of sap lock box process, bai 2 format etc. Specifically it controls the account type, debitcredit posting, and layout of entry screens. Each lockbox must have its own unique destination and origin combination, and also must be defined for a single company code in configuration.
If you choose to code this activity to a house bank account that you setup in. I have come across many documents explaining the configuration and functionality for lockbox implementation in sap. Concept of lockbox erp financials community wiki sap. It is used to store the financial data of an organization. Pdf configuration guide configuration guide for sap cash. Sap transaction code flbp post lockbox data sap tcodes the best online sap transaction code analytics. Run the post process lockbox transaction select the menu path accts recvcash mgmt period end closing post process lockbox. Spro img financial accounting bank accounting business transactions payment transactions lockbox define posting data. Open text doculink configuration to access documents. But during testing, the system allows multiple lockbox files with the same date, as long as the time stamps are different. This document is applicable only for file processed using bai2 format. 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.
The server translates the message using as standard edi interface into an idoc intermediary documents and sends it to the sap server. As the central finance system is an sap s4hana system, you can run the transactions either in the sap gui or in fiori ui. Ifba is the abbreviation of sap interactive forms by adobe. Open text archiving and document access for sap solutions offers a range of options for integrating sap documents and other documents in the different sap applications, including emails, faxes, images and informal correspondence, etc. Define lockboxes for house banks in sap sap training. Posting keys are twodigit numeric keys that control the entry of document line items. Sap books sap fico books certification, interview questions and configuration. 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.
Each bank has its own standard bai and bai2, hence configuration and testing needs to be done depending on bank file configuration. Configuring lockbox for cash application in sap fico. Fica configuration step by step sap expertise consulting. Sap can call you to discuss any questions you have. You can define lockboxes in sap by using one of the following navigation methods.
In our previous training tutorials we have learnt how to define lockboxes for house bank in sap sap img path. Lockbox is an account in the house bank which handles the receipt and processing of incoming payments in sap. This document is written using colorcoding to allow easier reading and interpretation of the data than if using variable fonts, underlining, etc. Relationship between ebs and lockbox assume on day 1 company receives lockbox file from bank and on day 2 receives ebs file. I want it to open in sap window instead of acrobat reader so that i can have sap toolbar to add notes in the pdf document displayed on screen. Summary this document helps you to configure and run automatic payment program in fico module in sap ecc 6.
Sap fi helps to analyze the financial conditions of a company in the market. It is strongly recommended that companies maintain the bank details on their customer contiguration records. 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. Variant configuration lo vc sap ag variant configuration lo vc 10 april 2001 to define the features of a configurable material, you use characteristics. Pdf wm configuration document warehouse management. When using lockbox and electronic bank statement it is important to set up the posting rules in sap correctly to avoid incorrect postings. This pdf depicts various steps for lockbox process configuration that are.
Lockbox process configuration, pdf book in sap fico. Embed other file formats inside pdf documents as attachments. Fi12 sap customizing implementation guide financial accounting bank accounting bank accounts define house banks on the following popup window enter the company code in this case 0010 for the sake of this guide. Right click on session name and click on process option. Sap uses this name to refer to interactive forms which have the flag interactive switched off, i. The lockbox program uses detailed information from the payment advice to automatically search and match customer open items. The document number on the payment advice is matched against the document number in the customer open item file. If you intend to print out this document for your reference, you will need to use a color printer. This page has been created in a way where it is easy for you to navigate through all the configuration steps. Today the growing global interest in erp solutions and particularly sap gives abacus sap academy graduates. Execute the following transactions to test the lockbox configuration flb2 main lockbox program that uploads the lockbox file data. Payment medium dmee configuration published by sachiadmin on june 18, 2017 june 18, 2017. It was opening earlier but nowadays it has started opening in a separate window using acrobat reader.
I chose to turn off updating bank data of customer, because it also create records in the bank key file. Unprocessed sap did not recognize the customer invoice number in the bank file and the credit. This service is mainly provided by banks in the united states. Configuration steps in sap fica this post will describe you briefly, which basic configuration steps to be followed for sap fica module implementation. Lockbox processing configuration in sap sap materials. The united states, unlike much of the world, still relies heavily on paper checks for payments. These criteria is decided during the initial stages of setting up lockbox process. This document explain about step by step configuration and processes for sap lock box functionality. This document is intended to explain the different aspects of postprocessing data and assist users to successfully processing the file data. Therefore, accurate payment data is necessary for automatic clearing to take place. Are you looking to configure sap fico or just refreshing your memory on certain steps this document will show you how to configure it step by step and explain some of the business processes around it. Sap fico 1 sap fi stands for financial accounting and it is one of important modules of sap erp. To enable you to use characteristics to configure a material, you assign the material to a class of class type 300. Lock box processing in sap free download as word doc.
However i have found very little post regarding post processing aspects of lockbox. Define lockbox posting data in sap sap training tutorials. Transaction ob56 is used to configure the text that appears on a line item based on the reason code entered. A bank will have several clients and each clients daily text file. Sap transaction code flbp post lockbox data sap tcodes. Define house banks define lockbox accounts for house banks define control. Configuration guide configuration guide for sap cash management powered by sap hana content. For more information, visit the financial excellence homepage. Now let us see, how to configure lock box functionality in sap. Is there any sap gui setting to open the pdf document in same sap window. Bank of america lockbox job aid page 3 of 10 job aid post process lockbox transaction 1. Sap customizing implementation guide financial accounting bank. This tutorial explains sap sd configuration step by step guide which includes topics such as creating sales relevent organisation units, assigning organisational units, creating master data, sales order creation and understanding the sales order table of contents. Sap easy access a accounting afinancial accounting abanks a lockbox a flb2 import.
Fico part tax procedure configuration steps for gst. The following sap training tutorials guides you how to define lockbox posting data in sap step by step. Besides archiving documents, it allows you to manage, search, display and edit them. Test data generation for the lockbox program rfeblbt2 and rfeblbt3. The following sap training tutorials guides you how to define lockboxes accounts at house banks in sap step by step. In sap financials closing operations user guide book, we will look at. Save the lockbox file attached with this document and modify the document number in file with open customer invoice.
Sap fi automatic payment program configuration and run. This pdf depicts various steps for lockbox process configuration. Lockbox configuration enables as a reference for customer master accounts and customers know where to send there payments. Setup and configure document management system dms and for document info record dir number range configuration and replication of dir. Please modify the t code as xd03 for customer master data in the document and suggested to avoid typo erors. Bank of america lockbox job aid page 1 of 10 job aid common scenarios for the bank of america lockbox. When ever a sales is made party will credit payment to this lock box account in. Each business day cru should confirm that the bank of america lockbox file loaded. Carriage return is used for creating new line in word or pdf formart and line feed is used for creating new line in txt format.