SAP Lockbox
Suresh Sadhu
SAP S/4HANA Finance Consultant | 15+ years in financial transformation | Expertise in configuration & data migration | Worked with Deloitte & Accenture | VIM | SAP Certified
SAP Lockbox
In the US, checks are the predominant form of payment. Lockboxes help in speedy deposit of funds and clearance of customer accounts, which are special depository accounts set up by banks in which invoice payments are made. Invoices and deposits are sent to the company by banks in the form of an electronic file every day. The company uploads these files into SAP and updates their balance and clears the customers as a result.
Mainly we will use BAI and BAI2 file formats for lockbox
There is little bit difference in these 2 file formats.
Configuration Steps: below configuration in place before uploading the lockbox file.
T.code Description
FI12 House Bank Creation
OBAX Define posting data
OBAY Define Control Parameters
OB10 Define Lockboxes for House Banks
Sample file format of BAI2
100LOCKBOXBOALOCKBOX1230710001521912041519
20000000000000000000000
50010011234567240705LOCKBOXBOALOCKBOX123
60010020000010000 1234567111110000000000009
400100360101800000009 0000000050000
7001004123456720072400100000100
80010051234567200724000100000100
9000001