Calc Invoices to Pay?

Bruce Easton bruce at stn.com
Tue Mar 4 09:51:19 PST 2008


Stanley Barnett wrote:
[..]
> [Bruce wrote a bunch of stuff prior to when the requirement 
> to consider combinations was understood.]
[..]
> 
> To my knowledge selections sets cannot iterate the records and find the
> right combination.  All it can do is what Walter's SQL statement is
> doing which is the very first phase if the process, which is gathering
> all unpaid and posted invoices to be considered by the routine that
> intelligently creates a list of invoices when summed equals to the
> payment amount to the penny.  If it exactly equals to the penny, I want
> the list for human verification, otherwise it is a total failure and I
> do not want a list, other than a message saying that an exact
> combination was not possible.
> 
> Thanks,
> Stanley Barnett  -  stanley at stanlyn.com
>

Understood.  My posts showed up out of order by quite a bit.

Bruce


More information about the Filepro-list mailing list