lock box config and process to test with test files

[Former Member]

hi gurus,

can anyone help me in providing documentation and test file( BAI fomat) totest the functionality.

My client wants to delevelop this functionality.

thanks in advance..

regds,

ram

[former_member197269]

please refer below link for detaails:

"Configuration:

Before you start configuration of Lockbox, you need to be clear whether you are using the file format in BAI or BAI2 format. The file is received from the Bank. Next question you need to understand how the incoming file is received from Bank - is it through EDI (Electronic Data Interface) or a encrypted text file? If it is a EDI file, you need to make additional settings like Partner Profile / Basic Idoc type to be used etc.

Steps in Configuration:

1. Define Lockboxes for House Banks in T.Code OB10.

2. Define Control Parameters using transaction code OBAY.

3. Define posting data in T.Code OBAX.

Customer Master Data:

1. Maintain the Lockbox number.

2. Maintain MICR number and Bank accountnumber.

Testing:

Get a test file from Bank and try to process the file using the transaction FLB2. If the file is processed, even if all the line items are unprocessed - basic configuration is correct.

My suggestion is to copy and take only one incoming payment (basically you are creating a file manually - ensure that header details like origin / destination are not changed). With this file you can playaround and identify if there are errors and correct it.

You can test Business scenarios like:

1. Full payment received from Customer. Customer MICR / Account number is maintained in Customer master.

2. Short payment / excess payment.

3. MICR / Account number is not maintained and the invoice number is matching.

4. No MICR number and invoice number not matching.

5. Multiple invoices for a single payment etc.

With regard to transaction code FLB2, you can execute in foreground / background. If you have to execute in background, the file needs to be in Unix path. For initial testing you can do in foreground and place the file on desktop."

hope this helps

pls assign points as way to say thanks

[Former Member]

hi

Lockboxes are a procedure used mainly in the USA to enable checks to be deposited more quickly. The checks the bank sends to you are entered as credits by the bank, and the information entered is sent to the payee using File Transfer. The lockbox files must be formatted per the BAI standard format.

Under certain circumstances, the bank transmits a data carrier to the payee several times a day; the carrier bears the important check information.

From this data carrier, postings are then generated for accounts receivable and G/L accounting.

Lockbox service has the following advantages for the payee:

Better liquidity, thanks to faster collection, depositing, and crediting of checks

Reduced processing workload

Procedure

To import lockbox data, proceed as follows:

Choose Incomings ® Lockbox ® Import.

You reach the initial screen.

Specify the path and file name of the lockbox file.

Specify the import options.

Choose Program ® Execute.

===========================================================

From the SAP Easy Access Screen select Accounting ® Treasury ® Cash Management ® Incomings ® Lockbox ® Postprocess or Accounting ® Banking ® Incomings ® Lockbox ® Postprocess.

2. Enter the required data and choose Execute.

The selected lockbox data is displayed in a hierarchy. The icons in front of each line show the status of the check. The following are possible status entries:

¡ Posted

¡ Posted on account

¡ Partially applied

¡ Not posted

Proceed as follows to display the check status:

a. Choose View ® Other Display

The screen for displaying lists appears.

b. Click on the ALV icon Layout settings and choose Change layout.

c. Select the Check Status field in the dialog window under Column List.

d. If you want to use the field in the column list, click on the left arrow and choose Copy.

The system displays the check status.

3. Edit Payment Advice

¡ In order to edit the payment advice, double-click on the Payment Advice field in the list display. Change the data you want to correct, save and choose Back.

¡ If you want to change the account or account type, show the Account and Account Type fields as described for the Check Status field. Both fields are shown in the list display and you can change them directly. Choose Enter to save the changed data.

If you want to ensure that your changes have been saved, double-click on the Payment Advice field and choose Payment Advice ® Header.

4. Choose Checks ® Post to resume the automatic posting of changed checks.

Hope this helps. please assign points.