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