Customer Invoice number

[Former Member]

Hi,

I am trying to implement Lockbox. I need to create an BAI2 file, which consists of "Customer Invoice". I need to know where can we get the Customer Invoice number. We can post Customer Invoice using FB70, after giving all the information, I got a message "Document 1051 was posted". Is 1051 the Customer Invoice number ?

I Will award points surely.

Thanks

Rajanikanth

[Former Member · Accepted solution]

hi rajni,

Lockbox is a process provided by a bank where the customer remits his payment to a PO Box at your bank, the bank deposits the check in your account and enters the remittance data from the customer. Then the bank sends the data to you electronically for you to import and apply in SAP-AR.

The structure that the bank uses is usually one of two formats. BAI will provide you the customer information and the check amount but no invoice remittance data. Usually cheaper and works well for a business where customers are paying only one invoice at a time.

probably this link would help you about the processing of lockbox.

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

chk this link

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

Lockbox is the procedure for rapid deposit of checks used mainly in the USA. Checks that are sent by the business partner to the bank or the local box provider(Service company that process checks) are credited to the payee's account. The information entered is forward to the payee per file transfer.

Lockbox is payment media mainly used in USA and mainly by small vendors. The flow of data can be explained with the help of an example. Suppose customer X wants to make a payment to Company Y. Customer X will send the check to one of the Y's banks, which is closest to customer. Company Y may have number of lockbox bank accounts in different locations. Each lockbox bank a/c represents a bank which process payments for Company Y. Every bank consolidates all the payments they receive for Company Y and send a file to Company Y via EDI or may be any other way. The EDI group of the company consolidates all the files received from different locations and format it in the format that is required for SAP (standard is BAI2) and sends only one file to SAP.

Following is the configuration steps:

OBAY (setting up control parameters)

OBAX (Account determination and posting parameters)

OB10 (Setting up lockbox for company code and house bank)

FI12 (Define house bank, bank a./c, etc.)

There are two lock box file formats. BAI and BAI2. (BAI2 has better flexibility). There are three main steps in Lock Box processing.

Define Lock Box (OB10)– Here you specify the Account number at the bank and give a name to the lock box.

Define Lockbox Control Parameters (OBAY)– You specify the procedure name (LOCKBOX) and Record Format (BAI2 normally)

Define Posting Data (OBAX) - You specify the origin (lock box or account #), destination (destination code submitted by bank) and Bank Account # (GL code for the account at bank).

RFEBL00 is the program that does lock box processing.

Lock Box program debits the Cash Deposit Clearing Account and Credits the Bank Clearing Account. It then debits the Bank Clearing Account and credits the Customer AR account.

If the system can’t find the matching Customer AR account, then it leaves the credit in the bank clearing account.

Pls assign me the points.....

Ranjit

[Former Member · Accepted solution]

Hello Ranjit,

Thanks for the reply. But that was not my question. My question is, there is a field in the BAI2 file, where we are supposed to enter customer invoice number in the record that starts with the number "4". Can you please let me know from where can I get the invoice number. Is the invoice number same as the document number that we get when we post customer invoice in FB70?

Regards,

Rajani

[Former Member]

Hi,

Yes, that is the customer invoice number. If you want to see the same where it is go to the transaction code FBL5N and give customer name and search.

Assign Points

Z