Finance Question- matching sales value date with that of amount received date

Originally Posted by paradise2sr

Dear Sir,



My ultimate aim is to calculate Total discount amount based on the criteria stated in next worksheet.

With Best Rgds,
Suresh

I understand precisely the ultimate aim.
What I don't understand is how you expect the system to match Receipts in column F to whichever Bill number in column E they relate. This is a fundamental requirement.

I think you need to tell us in narrative form what steps you take in your mind when you are generating the working details that you show in K5:K7. Unless we know how you do this manually there is no way we can get a 'system' to do it.