Enterprise Resource Planning Blogs by Members
Gain new perspectives and knowledge about enterprise resource planning in blog posts from community members. Share your own comments and ERP insights today!
cancel
Showing results for 
Search instead for 
Did you mean: 
dgkrishnan
Explorer
3,701
Lock Box implementation for unique customer use case

Objective: This Article explains the implementation and use case of Lockbox functionality

Business need for implementing Lockbox for incoming check payments

 

  • Elimination of manual scanning and manual processing of incoming checks resulting in processing error and delay


 

  • Manual reversal of dis-honored or voided checks is time consuming, labor intensive and also results in overhead incurred from bank charging additional fee


 

  • Unable to have clear visibility on the availability of liquidity


 

  • Unable to manage higher volume and timely processing of incoming checks


 

  • Chargeback were handled manually


 

  • Unable to record chargebacks automatically and additional time being spent on accounting for and reconciling chargebacks


 

Unique client requirement / Use case:

In existing process, the client was handling multiple manual steps from scanning to the manual posting, clearing and reversal in case of check returned

Charge backs where handled manually and at times were missed out without system process.

Process flow diagram - Picture 1


 

Business Process

Scenario 1:

Multiple chargebacks with multiple reason code in a single Lockbox file – Integration with dispute management with multiple dispute cases created per reason code

In this scenario we will receive single check payment for multiple invoices from a single customer. The customer applies multiple external charge back codes for short payment. The external reason/chargeback codes are converted to internal reason codes and are populated on the incoming (payment) AR document. The system posts separate line item for each chargeback code in AR document and for each of the reason code system captures the reference information from lockbox file in the text field of incoming AR payment document. Disputes are created in FSCM- dispute management for each of the reason code.  When the disputes are created the internal reason codes in AR are converted to reason codes defined in dispute management and the incoming check number is captured in the title of each dispute case.

Customer master / Business Partner updated with MICR information-Transaction code-XD02 / BP

It is important to have customer master/BP updated with MICR information. if the incoming lockbox file is not able to find the open invoice match, the system will post it to the customer account based on the MICR information.

If the incoming lockbox file has a cutomer invoice match and also has the MICR information populated and if it is missing in customer master/BP, the  system will create a batch input session to update the customer master/BP with the MICR information. BP - Refer Picture 2

Picture 2


 

Business Partner updated with reason code conversion-Transaction code-BP

The reason code conversion is used to map the external reason codes with internal reason code in customizing to process the chargebacks - Refer Picture 3

Picture 3


 

Customer invoice postings1- Transaction code-FB70

The customer invoice can be posted in AR or can be initiated in sales & distribution using sales order for outgoing sales. For demonstrating the lockbox process in the example we have posted the invoice using FB7O in AR module. - Refer Picture 4

Picture 4

 


 

Customer invoice posting2- Transaction code- FB70

This is again customer invoice posted in the AR.

We have posted multiple customer invoices to demonstrate the process of multiple chargebacks with multiple customer invoices - Refer Picture  5

Picture 5


Sample lockbox file with multiple chargebacks codes.

This is the incoming lockbox file from the bank. This file has incoming payments for invoices referenced above. This file also includes the short payments on those invoices with multiple reason codes - Refer Picture 6

Picture 6


 

Lockbox file processing log- showing partial payment for the invoices owed- Transaction FLB2

The system was able to find the open invoices and partially applied the payment and posted the GL  and AR document- Refer Picture 7

Picture 7


 

Lockbox-Log of imported checks- Showing multiple chargebacks.

Further lockbox processing log showing the system identified the invoices based on the reference numbers captured in the invoices. The items that are listed as documents not found are the customer change backs with the check amount showing the net payment after deducting the charge back amounts - Refer Picture 8


Picture 8


 

Lockbox Process Checks-Transaction FLB1- Showing GL document in posting area1 and AR document under incoming customer payments. The GL document represents the posting on bank clearing account  and the AR  document represents the posting to the customer account for incoming payment - Refer Picture 9

Picture 9


 

GL document- for bank clearing – Transaction FB03.

This is the display of GL document posted in posting area1, this document debits the bank accounts and credits the bank clearing account - Refer Picture 10

Picture 10


AR document with reason codes and reference from lockbox file captured in Text field.

The AR document created credited the bank clearing account so it balances out to zero and also clears the open item and posts the shot payments with respective reason codes captured in the reason code field. The internal reason codes are derived from the mapping of external reason codes using the “reason code conv” version populated in the BP master data Refer Picture 11

Picture 11


 

Three separate disputes created for three different charge back codes- Transaction-

The system created three separate dispute cases for the three short payments in dispute management. The disputes can be created by executing the transaction manually or having it created through batch job setup - Refer Picture 12

Picture 12


 

Disputes displayed in transaction – UDM_DISPUTE. The reason codes converted to internal dispute codes

The disputes created above can be displayed individually using the display transaction code. When a dispute is created, the AR reason codes are converted into the internal dispute codes - Refer Picture 13

Refer Picture 13


 

Three separate disputes created with three internal dispute management codes. The dispute cases created will have the case type, case ID assigned, the priority defined as-High, Medium ,Low and will also populate the coordinator and the person responsible for the dispute case along with the disputed amount - Refer Picture 14 (3 images)

Picture 14


 


 


Customer line-item display- showing all the related line items with dispute case ID’s and the reference captured from lockbox file in Text field. The cleared items represent the invoices cleared by the incoming lockbox file and the open items represent the short payments. Though there were short payments for the original invoices system will clear them for the full amount and then creates the open items for short payments - Refer Picture 15

Picture 15


Scenario 2:

 

Single check payment for multiple customer invoices from multiple customers

Multiple customer numbers were created to represent customer per brand to accommodate credit management at the brand level

Scenario Description- In this scenario we will receive single check payment for multiple customer invoices from multiple customers. The system will read the Legacy invoice numbers from the reference filed captured in SAP AR invoices and apply the incoming payments and clear the open invoices

Master Data Updates:

Customer1-Updated with MICR information- Transaction XD02 / BP-

Customer master / Business Partner updated with MICR information-Transaction code-XD02 / BP

It is important to have customer master/BP updated with MICR information. if the incoming lockbox file is not able to find the open invoice match ,the system will post it to the customer account based on the MICR information.

If the incoming lockbox file has a customer invoice match and also has the MICR information populated and if it is missing in customer master/BP, the  system will create a batch input session to update the customer master/BP with the MICR information - Picture 16

Picture 16


 

Business Partner updated with reason code conversion-Transaction code-BP.

The reason code conversion is used to map the external reason codes with internal reason code in customizing to process the chargebacks - Picture 17

Picture 17


 

Customer2: Customer master / Business Partner updated with MICR information-Transaction code-XD02 / BP

It is important to have customer master/BP updated with MICR information. if the incoming lockbox file is not able to find the open invoice match,the system will post it to the customer account based on the MICR information.

If the incoming lockbox file has a cutomer invoice match and also has the MICR information populated and if it is missing in customer master/BP, the  system will create a batch input session to update the customer master/BP with the MICR information2 - Picture 18

Picture 18


 

Customer2 BP updated with lockbox reason code conv.- Transaction BP

The reason code conversion is used to map the external reason codes with internal reason code in customizing to process the chargebacks - Picture 19

Picture 19


Customer Invoice posting on customer1 with Legacy reference number- Transaction FB70

The customer invoice can be posted in AR or can be initiated in sales & distribution using sales order for outgoing sales. For demonstrating the lockbox process in the example we have posted the invoice using FB7O in AR module - Picture 20

Picture 20


Customer Invoice posting on customer2 with Legacy reference number-Transaction FB70

We have posted multiple invoices on multiple customers with in the same company code to demonstrate the process of single incoming check payment for open invoices from these customers - Picture 21

Picture 21


Sample lockbox file with reference numbers and the amounts for the two customers and the two customer invoices posted in the preceding steps - Picture 22

Picture 22


File Saved as .txt  Picture 23

Refer Picture 23


Lockbox processing- Transaction FLB2.

This transaction is executed to manually import the lockbox file into the system for processing. This can be scheduled as a job as well to have the system read it from the ftp folder and process it - Picture 24

Picture 24


Lockbox processing log: This is the lockbox processing log. Once the file is processed the system creates the log to show the GL and AR documents created and the total amount processed along with the check number and payment advice number -  Picture 25

Picture 25


When we hit a back button on the previous step, documents found using references on AR invoices applied. The system will show the details on the amount that was applied along with the message “document found” - Picture 26

Picture 26


Post processing Lockbox Data- FLB1

This is the  post processing screen that lists the GL document in posting area 1 and the AR document created under “Incoming Customer Payments” - Picture 27

Picture 27


 

GL Document for bank clearing account- Posted in Posting Area1- Transaction FB03

This is the display of GL document posted in posting area1, this document debits the bank accounts and credits the bank clearing account Picture 28

Picture 28


 

AR Document- Incoming customer payments. Single check applied to multiple customers- Transaction FB03

The AR document created credited the bank clearing account so it balances out to zero and also clears the open item - Picture 29

Picture 29


Customer line item report- Transaction FBL5N

Customer line-item display- showing all the related line items. The open invoices, incoming payments and clearing document created. The check number has been captured in the text field - Picture 30

Picture 30


 

Business Benefits derived by implementing the above scenarios:

  • Incoming checks are now handled through lockbox process and no manual intervention is required eliminating user error.  With the automatic processing the client can now handle larger volume and multiple brands centrally


 

  • With the implementation of Lockbox, incoming checks are processed automatically along with customer chargeback which was a manual process in legacy and this has minimized processing time and reconciliation issues, resulting in “Fast Close” for Accounts Receivable process


 

  • In EBS, all lockbox related transactions are easily identified and reconciled against the postings from the bank statement


 

  • With the integration of Lockbox with dispute management, with the processing of Lockbox file, chargebacks are posted automatically which create the dispute cases in dispute management


 

  • With Lockbox automation, Accounts Receivable team is able to focus on other important tasks and customer service-related activities

1 Comment
Labels in this area