We get checks with a specific amount but with no listing of what is being paid. Basically what I am looking for, if possible is to see what combination of invoice amounts will lead to a specific number (check amount). Thanks for any help.
We get checks with a specific amount but with no listing of what is being paid. Basically what I am looking for, if possible is to see what combination of invoice amounts will lead to a specific number (check amount). Thanks for any help.
could you be more specific, please
I have a customer with a list of some 20 open invoices of various amounts. I receive a check from the customer with a specific amount. I need to find a way to see if there is a set of numbers from the open invoices that will match the specific check amount.
function match
What's the reasonable maximum number of open invoices?
What's the reasonable maximum number of open invoices that a given check could cover?
Entia non sunt multiplicanda sine necessitate
Do you use a date field in your data? Will the customer be paying off the oldest invoice first? What if there are multiple ways to add different invoices to the payment amount? What is there is NO way to add any/all of the invoices to the payment amount?
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks