FLB1 - Apply Unprocessed Cash from Lockbox

The lockbox process (ZARI005) takes a daily cash feed, processes items, and creates a log of processed and unprocessed items. The unprocessed items must be identified and posted, as follows:

Get started
Postprocessing Lockbox Data: (select lockbox log)
Lockbox data overview: (find unprocessed payment)
Get customer number of payment to process
Get dunning area for payment to process
Lockbox data overview: (post unprocessed payment)
Post with clearing: create GL account (debit)
Post with clearing: create customer item (credit)
Repeat steps 4 - 8 for other unprocessed items in batch
Repeat steps 3 - 9 for other batches with unprocessed items
Check for zero's in Unprocessed column
Clear customer accounts

1. Get started

SAP menu path:
Accounting=>Treasury=>Cash management=>Incomings=>Lockbox=> Postprocess:
SAP fast path: FLB1

2. Postprocessing Lockbox Data:

Select lockbox data:
To list available Lockbox logs, press or Enter; select a log by double clicking on its line.
Note: Alternatively, fill in the fields described below and click on

Destination (MIT1)
Origin (genar)
Lockbox (Enter "C01" ("01" are digits) followed by "mmdd" for month and day to process, for example C011103 for November 3.)

3. Lockbox data overview

Check to see if there were any unprocessed payments (see below, in last column = Unprocess).
To list items in batch, double-click on line of batch with unprocessed payments (see below; batch 003).

Find unprocessed payment records (see below, Status column = Unprocess for 38.00 check).

4. Get customer number of payment to process

Make a note of the customer number of the payment to process (see Customer column above).

Note: If the screen shows no customer number, you need to use the SAP printed report "Cashier's Office Feed (Lockbox log of imported checks)" to get more information. The report lists all A/R (acct 10763) lockbox items for a date.

If the check amount is unique, you can get the customer number from the report. If the check amount is appears more than once in the report, you need to open another session in SAP to find out which of the customer payments has not been applied.

5. Get dunning area for payment to process

Double click on line of unprocessed item.
If no customer number displayed on the Lockbox data overview screen, screen a) displays; otherwise, screen b) displays.
1. Add to Payment advice: initial screen
  You can enter the customer number on this screen (to find customer number, see note in Step 4).
  To save it, press or ENTER
2. Change payment advice: overview
  
  From menu bar, select Environment=>line items to look up the dunning area of the customer payment/charge.
  Click twice on to return to Lockbox data overview.

6. Lockbox data overview

With unprocessed record selected, click on to POST

Note: At the beginning of a month, you may be required to change the Document Date and Posting Date on the Post with Clearing: Header screen. These processing dates need to match the current Period.

7. Post with clearing: create GL account (debit)

Enter item 1/debit:

Text ("incoming payment mm/dd/yy")

Note: To avoid retyping this entry in the next step, highlight "incoming payment mm/dd/yy" and press CTRL-C to save it on your clipboard; in the next steps, press CTRL-V to paste it into the Text field.
Begin next line item:

Posting Key (15 = incoming payment)
Account (customer number)

8. Post with clearing: create customer item (credit)

Enter item 2/credit:

Amount (*)
Dunning area (from Environment=>Line items, in step 5)
Text ("incoming payment mm/dd/yy")
to SAVE
You return to Lockbox data overview; Status of payment record changes from Unprocessed to Applied.

9. Repeat steps 4 - 8 for other unprocessed items in batch

When done, click on to return to list of batches (see step 3).
Note: The Unprocessed total in the last column is NOT reduced to zero until step 11.

10. Repeat Steps 3 - 9 for other batches with unprocessed items

When done, no Unprocessed payment items remain. To confirm this, see step 11.

11. Check for zero's in Unprocessed column

Click on to return to initial screen (step 2); then redisplay the lockbox log you processed payments for.
The Unprocessed column should display all zero's, as shown below.

12. Clear customer accounts

Finally, you need to clear the accounts (use F-32 - Clear Customer Account) for which you applied payments.
If you don't find an invoice to match the payment just applied, you'll know you made an error.