Open FLB1 transaction:
This screen has to be filled with the last working date:
Then, click on , afterwards, the following screen will appear:
We have to extract a report from FLB1 on a daily basis before start the cash application in order to verify our Automatic Match made by the system to be considered in our KPI of Auto Cash.
In order to extract this report, please, click on the following screen will appear:
Then, click on and select "spreadsheet". This file should be saved on Drive O, Folder "NAM-Daily Reports".
Now, we can start the cash application clicking again on .
The Lockbox transaction is organized as follows:
- Canadian Receivables (checks and electronic transfers), NAFTA FACA;
- US Checks, NAFTA FAUS;
- US Electronic Transfers, NAFTA FAUS;
There are three available statuses:
- Applied (Green Sign)
- Unprocessed (Red Sign)
- Posted on Account (Blue Sign)
Based on the list of entries not yet posted (red and blue items), the bank and the currency that has to be processed should be selected by double clicking on the item.
Example:
Remark : As soon as the payments are posted, the amounts become green on FLB1 transaction statement.
Processing Payments Posted on Account (Blue Sign):
This status is when system identified the customer account and post the funds there, however, system was not able to identify the invoices. To process a payment, click twice on the concerned line and afterwards on the floppy disk . This will have to be done for each blue item.
Having the name of the customer or the invoice number, the system is able to identify the customer account itself. However if all the details are not displayed in the statement, the system is not able to perform the matching. We should search in the JP Morgan Bank Statement, the amount of the payment that need to be posted to get more information about this payment.
In the bank statement below, there is mentioned the customer name and the invoice number:
Therefore, the following screen appears suggesting already the customer number in the Account field:
Thus, we should select the correct invoice by double-clicking on the amount in the “USD Gross” column. The payment will be selected.
The amount is now displayed in blue.
At the bottom of the screen, the “Amount entered” (corresponding to the amount of the payment) is equal to the “Assigned” amount (our invoice selection), meaning that the payment matches perfectly with the invoice. In this case, the “Not assigned” field (at the bottom of the screen) is equal to “0”, meaning that the transaction can be validated by clicking on the floppy disk (at the top of the screen).
If the “Not assigned” field does not equal to “0”, different explanations are possible:
The amount could be a banking fee, a discount , etc. Therefore an analysis should be done to find the reason of the discrepancy.
The difference must be posted by using the procedure “Management of Payment discrepancies”.
Processing Unprocessed Payments - Not Posted on Account (Red Sign):
In case system cannot identify customer account due to lack of information, there are several possibilities to find it but the most common one is searching:
- by invoice number : Z3F_FA_CNTR_DISPLAY
- by customer name : Click on the floppy disk on the payment.
- using “Specificities of NAM Customers ” database : Google drive













