LOckbox

[Former Member]

Hi,

I could Import Lockbox data and it posts GL ( DR bank cr Lockbox Clearing Ac) only butnot claring Customer Open Item like Electronic Bank Statement(EBS).

Error message - Not processed as customer * is not availale.

(It didnt clear the customer Open Item.)I followed the following format of Amro bank .It gave error saying

My doubts are:

1. There is no config like interpretation under EBS.

2. What is the algorithm of Claring the open Item

3. Where are we entering the customer no.

I tried by giving Invoice no in detail record (recod 6) in lock box data but it didnt recognize. Also in Detail Overflow record (record 4).Could you give the reason and solution please. ( Amount 8000)

Invoice no 200000007 ( refre record 4)

100123300212312330001230605170759

212330021231233000123

5001001000300206051712330021231233000123

600100100008000000610000521234567000740029001

40010016010200000007000000000

700100100030020605170010000800000

9000006

Thanks in advance.

Chitra

[former_member197269 · Accepted solution]

Hi Chitra,

Please refer the below link for details on lockbox.

http://academic.uofs.edu/faculty/gramborw/sap/lockbox.htm

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/1d8ca590-0201-0010-c795-ae0...

http://help.sap.com/saphelp_erp2005/helpdata/en/88/ed91381d90070fe10000009b38f8cf/frameset.htm

http://help.sap.com/saphelp_erp2005/helpdata/en/57/f1fc3768b56d00e10000009b38f842/frameset.htm

http://help.sap.com/saphelp_erp2005/helpdata/en/57/f1fc3768b56d00e10000009b38f842/frameset.htm

hope this is helpful

[Former Member]

Hi,

let me know the process you are trying to import the lockbox file , is it manual thru FLB2 or using idoc direct upload Using EDI/EAI?

Are you using BAI/ BAI2 format?

BAI2 Format looks something like this:

1005945704 00710000130705291600

500100000700470705295945704 0071000013

60010010000250000072404786000021769565360000592888

40010016001<b>50000130</b> 0000250000

700100000700470705290010000250000

8001000007004707052900010000250000

9000007

Its only at the highlighted place where you give the invoice number and not anyhwhere else.The details of fields & Field lengths of individual record types can be cross checked with the 9 tables

FLB01--Thru-- FLB09 in SE11.

NOTE: For BAI2 format the record types 4 & 6 tables are FLB24 & FLB26 respectively. apart from that all other tables are common for BAI & BAI2.

2) For unprocessed checks u have to use the TCode :FLB1 to manually process.

Let me know of any other concerns giving me the details of the queries i raised.

Regards,

Hema

[Former Member]

Invoice required :

Customer Number :3000000

Assignment: 0000005200001

Accounting Document Number: 1600000041

Baseline date for due date calculation:07/20/2006

Tolerance 200

Amount: 3,598.24 but put 3400 instead to check

Immediate Destination for Lockbox (Recipient Bank Number: 8188207155

Origin of Transmission - Transit Routing Number Lockbox: 0071000039

Lockbox Number: 0013834

[Former Member]

How do I create a sample lockbox file to make a payment for follwoing info

Invoice required :

Customer Number :3000000

Assignment: 0000005200001

Accounting Document Number: 1600000041

Baseline date for due date calculation:07/20/2006

Tolerance 200

Amount: 3,598.24 but put 3400 instead to check

Immediate Destination for Lockbox (Recipient Bank Number: 8188207155

Origin of Transmission - Transit Routing Number Lockbox: 0071000039

Lockbox Number: 0013834

[Former Member]

Hi,

Any one worked on Lockbox post process.

The customer Open Item as Debit .after importing the lockbox

1.will it clear the open Item if the invoice no matches?

or

it creates one more line of Credit entry on customer Line item (in FBL5n).

2. What is the post process steps. It is bit cryptic unlike Bank statement.

3. How do I process the unproceesed items ?

It does not take me to custome OI to clear it of then and there manually.

4. Can I use the paymnet advice created by lockbox

as incoming paymnet clearing and clear ? What is the screen for clearing? What it does during post process.

I am missing the proper route here?

Thankful to get yr early reply .

Regards,

Chitra

Chitra.

[Former Member]

Hi Ms. Chitra

To answer your question of credit memos....yes if the doc number matches, the credit memos are cleared automatically...

You post process the unprocessed items by double clicking on them, entering the right customer number on the payment advice creation screen & editing the document number on the payment advice line item...

Payment advice creation with a customer number = creation of a line item at the customer level with the total amount of the check as credit on the customers account

If the document number inside the payment advice matches you will be able to pull up the open items for that document number by hitting CTRL+F1 from the line item screen of the payment advice just for you to compare..now you can post process there or you can dorectly hit post from the flb1 screen placing your cursor on the check itself & post process on the open item screen...

Lemme know if you need more help....

I am actually doing Bank statement implementation ...I would appreciate it if you can gimme ur email address that way I can contact you directly if I have any issues...

Thanks

Morgan