What are the configuration steps to do lock box processing? Lockbox configuration will not involve many steps. I assume you are configuring BAI2 format and it is a text file encrypted from Bank. The steps to be followed are:. Define Housebank for Lockbox. Define Control Parameters ie.
|Published (Last):||11 September 2006|
|PDF File Size:||19.96 Mb|
|ePub File Size:||14.32 Mb|
|Price:||Free* [*Free Regsitration Required]|
The predominant way payments are made in US is by checks. Lockboxs help in speedy deposit of funds and clearance of customer accounts. Lockboxs are special depository accounts set up at a bank to which customer remit their invoice payments. Figure 1: Lockbox Process Flow.
Each bank has its own standard BAI and BAI2, hence configuration and testing needs to be done depending on bank file 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 a preprocessing program and make file fit with SAP standard format. BAI2 is advised as because it has greater probability of producing automatic matches in the processing and because it allows one to record deduction information and create proper residual postings.
Day 1 When the bank receives a check from customer with remittance information its sends it in Lockbox file. Lockbox file when processed will generate below accounting posting. Dr Bank Clearing account — incoming. Cr Lockbox Clearing Account. Dr Lock box clearing account. Cr Customer account customer sub ledger. Day 2 when the check is cleared in bank, it appears in EBS. EBS when processed produces below accounting entry.
Cr Bank Clearing Account — incoming. Lockbox Configuration. Activating this field is recommended. Insert Bank Details: Applicable for batch input session name that updates bank details of master records for customers who have either changed bank information or did not have bank information maintained for them. Destination: This field should contain the destination code the bank submits to you in your lockbox file.
Origin: This field should contain the your lockbox number bank account number at the bank. Maintain Bank details in customer master data which bank will send in lockbox file. SAP gives option of using one of the two standard algorithms for lockbox processing. A common misrepresentation is that one can create own algorithm which is not correct. We can only use the pen delivered by SAP. Documentation can be viewed for this program from SE38 transaction code.
This program contains lot many user exits whether one can add any additional business logic. Two algorithms that are used are and If file contains checks that cannot be applied against specific invoice but for which customer account is known, SAP posts them on the customer account without reference to any specific invoice. Using algorithm , SAP distributes the check across open invoices, beginning at the oldest invoice and working its way forward until the check amount is fully distributed.
Save the lockbox file attached with this document and modify the document number in file with open customer invoice. Select the one which contains data in file. For example if file contains is second session name will be Right click on and select Process Checks options. Again view customer invoice it will be displayed as cleared from the payment received and posted via lockbox.
Unique key for each lockbox file is its header record i. Destination, Origin name, Date and time. These programs will generate customer open items and a lockbox file for processing. Same can be downloaded and uploaded with just modification of document number else copy from below location. Hi Gagan Pareek. Thanks Jandoval Nascimento. Please modify the T code as XD03 for customer master data in the document and suggested to avoid typo erors.
But if same are found using IBAN, are correct. Please provide solution asap. How do we avoid step 3 and keep the info in sync between the two systems? Looking for std SAP solution here.. How the program will work? The program will try to apply to last one or will check the MICR number and after to decide in which account to apply? Former Member.
Posted on September 23, 6 minute read. Follow RSS feed Like. Lockbox process The predominant way payments are made in US is by checks. Difference between BAI and BAI2 BAI2 is advised as because it has greater probability of producing automatic matches in the processing and because it allows one to record deduction information and create proper residual postings.
Customer Invoice Posting Post one amount customer invoice. Invoice will display in open state. Lockbox file processing SAP gives option of using one of the two standard algorithms for lockbox processing.
Transaction Code: FLB2 Save the lockbox file attached with this document and modify the document number in file with open customer invoice. Click on green execute button. Click on back button. Right click on Session name and click on Process option. Alert Moderator. Assigned tags. Related Blog Posts. Related Questions. You must be Logged on to comment or reply to a post. Godavari SAP. September 23, at am. Thanks a lot, Gagan.
It is explained well. Like 0. Former Member Post author. October 17, at pm. December 14, at am. Hi Gagan, Can you please look into this thread and resolve this issue. Appreciate your effort. Hi Gagan, Good document.. Kind Regards, Prasad. Good one Gagan.. Mohammed Kalim. Nice Document Gagan…thanks for posting. Regards, Kalim. Vinod Vemuru. September 23, at pm. Good document Gagan. October 19, at am. Thanks Veenu for highlighting that …Rectified the entries now.
Nice Document.. Thanks for Sharing…Gagan. Regards, Lingesh. October 23, at am. Thanks narra lingesh. Hi Gagan Pareek Thanks for share the document with us. Jandoval Nascimento. October 20, at pm.
Lakshmi Sama. October 30, at am. Hi Gagan, Very explained document on lockbox. Thanks for sharing! Please modify the T code as XD03 for customer master data in the document and suggested to avoid typo erors Regards, Lakshmi S.
Lockbox process Configuration
I have come across many documents explaining the configuration and functionality for Lock-box implementation in SAP. However I have found very little post regarding post processing aspects of Lockbox. Hence I have excluded lockbox configuration part. This document is applicable only for file processed using BAI2 format.
Lockbox post processing in SAP
Lock Box Configuration What are the steps for lock box configuration? For example account is for PNC Bank. The remit-to lockbox assignment must also be specified. Regarding the tolerance group assignment, XXXXX only has one configured that is a blank customer tolerance.
Lockbox Configuration In SAP
Yes, all details will be on the bank file. The name used is a combined decision made by client and bank. First 4 character represents the name of the client. These criteria is decided during the initial stages of setting up lockbox process. A bank will have several clients and each client's daily text file must be unique, so even though payment data changes client name will be an effective way for easy identification. It also helps the bank person who upload the file on the bank server since he will have to upload each file it to the correct client's account. Not what you're looking for?