cancel
Showing results for 
Search instead for 
Did you mean: 

Customizations to Locbox program in SAP

polaggari
Active Participant
0 Kudos

Hi,

Could anyone please tell me some customizations you have done to Lockbox program.

specifically for your project needs, the reason why you did it, how you did & how it improved you matching rate of customer invoices or clearing etc.

the reason why I am asking this question is because we have implemented the standard lockbox functionality for our client, it is working pretty fine but the client is not satisfied with the match rate he is getting for clearing customer invoices.

you could give any possible suggestion apart from the standard lockbox functionality you have implemented not only just for match rate.

Thanks in advance.

Accepted Solutions (0)

Answers (1)

Answers (1)

sanilbhandari
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hi


Did you analyze the reason why the matches are failing? In our case, the file from the bank had a single payment for multiple invoices and some times also contained on account payment from the customer. Based on business requirements,we had implemented an enhancement to clear invoices on first in first out basis. So you first need to tell what is the issue in your cases and why the matching for invoices against the payment amount is failing.

regards


Sanil Bhandari

polaggari
Active Participant
0 Kudos

Hi Sanil,

thanks for your reply.

match rate is not falling for us. We just are looking for improvement in match rate.

1. how to identify customer - we use MICR and customer invoice number in order, is there anything else that could be looked at.

2. how to identify a open invoice for clearing - based on document/reference document number but is there any thing else that could be looked at.

3. and once the customer is identified - exactly matched open items will be cleared, next we can go for residual/partial payments, can be looked at clearing invoices by earliest date or leaving the balances on account.  apart from all these option is there anything we could think of?

and coming to your case  while uploading in FLB2 if we specify algorithm as 003: distribute by earliest date, wouldn't that suffice to clear the invoice on first in first out basis. why did u go for an enhancement?

and also I believe only if you select algorithm 003 in FLB2 there will be partial/residual payments or else it will be on account posting.