hello guys, i am new in this site and i am mot sure if this has been asked before, here's my problem.
The first column is the invoice number and the second column is the value of the invoice.
A1200 2,525.25
A1250 4,234.21
A1750 3,135.22
C2150 1,234.87
B7510 2,112.36
Problem arises when I have about 100 or mpre invoices like above and I receive a payment of 10,235.60 without details of invoices to be applied. What would be my formula to find the closest match or count to the amount I received, and how would the result indicate which invoices or amount he sum-up? I understand that the result might have a lot of options, so I might as well limit the result into 10 options only or less, and provide range of target amount between 10,000 to 10,500.
i hope my question is clear and wish somebody out there can answer me.
thanks.
A1200 2,525.25
A1250 4,234.21
A1750 3,135.22
C2150 1,234.87
B7510 2,112.36
Problem arises when I have about 100 or mpre invoices like above and I receive a payment of 10,235.60 without details of invoices to be applied. What would be my formula to find the closest match or count to the amount I received, and how would the result indicate which invoices or amount he sum-up? I understand that the result might have a lot of options, so I might as well limit the result into 10 options only or less, and provide range of target amount between 10,000 to 10,500.
i hope my question is clear and wish somebody out there can answer me.
thanks.
