Paulo Carlos
Lockbox SAP Configuration:
Step 1: Set up Bank and Bank account G/L Structure:
Transaction code- FS00
I previously created a Citibank Main G/L account: 100070. Now I have to create a Lockbox main account
and a lockbox clearing account.
Creating Lockbox main account: 100055
Creating Lockbox clearing account: 100056:
Step 2: Define Lockbox in house bank
Transaction code: OB10
Choose new entries and enter the
required data:
Enter other data like PO box address, street address and hit save
Choose save and you will see the newly created Lockbox for your company code:
Step 3: Define Control Parameters:
Transaction code: OBAY
In this step, we are using the BAI2 format for the lockox.
If you double click on BAI2, it will give you the default parameters:
Step 4: Define Posting Data:
Transaction code: OBAX
Choose new entries:
Or you can choose to COPY AS and enter your company code and name the destination and
origin fields. Bank G/L account is for the Lockbox Main A/C (100055) and Bank Clearing account (100056)
is the LB clearing a/c we created earlier.
Choose save and you will see your created posting data:
Now we must create a test file since we will not have any open invoices from the lockbox for BAI2
format
We use transaction code: sa38 and run the program RFEBLBT2:
Choose the Program
Hit Execute
It will take to the Autocash: Lockbox- Create test data for BAI2 Format and we must enter all our data.
File name is the Lockbox name, enter the Destination and Origin name on the respective field. Enter
company code. For the customer, enter the customer number. Enter the Sales revenue G/L account for
the Dummy Account field.
Hit Execute:
In order to copy the test data, Go to List -> Save/Send -> File and choose Rich text format:
Save it to the desktop and save it as a notepad file in your C: drive containing SAP.
To display customer line item, use transaction code: FBL5N:
Transaction code: FLB2 to upload the program
After running the program:
Accounts posted:
Looking at the Display Customer Line item, you can see that the balance is 0.
Display G/L Account Balance: FS10N and hit execute:
Double click on the amount:
Here we see the Lockbox Main account is debited and the clearing account has been credited