Filtering Records Based On A Criteria Value

amjadinsaudia 

Background of the problem:

We have received payment form a customer who has many bills outstanding, may be hundreds of bills are outstanding. Upon receipt of payment, we need to identify bills those make sum of this payment which we received.

An altogether different solution, coming at it from a different direction.

• Do you charge interest on unpaid balances beyond a certain time limit? (Doing so would alter the payable amount of original invoices.)
• Is there any reason why you can't just apply any given payment to the oldest of the outstanding bills, then the next oldest, in sequence, until the point where a given outstanding bill is not fully covered. At that point, that last of the series gets partially paid, but now becomes the oldest, to be paid off in the same manner with whatever payment comes in next.
• In other words, what makes it so important that you seek out the exact combination that equals the payment? And what do you do if there are multiple combinations, which is certainly possible if there are hundreds of such outstanding bills?
• And if there IS a reason to seek out the exact combination, why not require the customer to identify the bills being paid? Presumably the customer knows, since you are assuming that the customer is paying a specific combination.
• To have the customer identify them seems entirely reasonable, especially given the possibility (probability) that you might (mathematically) identify one or two in error, given the volume of outstanding bills.