Calc Invoices to Pay?

[Stanley Barnett]

> Oh, it can't be all that bad.  After all, if you have 35 invoices,
there are only 34,359,738,367 possible 
> combinations.  (Though you don't actually have to check all of them if
you code it correctly.)

Yes Ken, that looks correct and the number will be substantially smaller
if you keep track of and skip previous calculations.

Any suggestion on coding this, or better yet, has someone already
created it? 

Thanks,
Stanley Barnett  -  stanley at stanlyn.com
Stan-Lyn & Associates, Inc.  -  http://www.StanLyn.com
Office: (859) 402-8165  -  Cell: (606) 568-5412

-----Original Message-----
From: filepro-list-bounces+stanley=stanlyn.com at lists.celestial.com
[mailto:filepro-list-bounces+stanley=stanlyn.com at lists.celestial.com] On
Behalf Of Kenneth Brody
Sent: Tuesday, March 04, 2008 11:06 AM
To: Fairlight
Cc: filepro-list at lists.celestial.com
Subject: Re: Calc Invoices to Pay?

Quoting Fairlight (Tue, 4 Mar 2008 10:47:54 -0500):

> The honourable and venerable Stanley Barnett spoke thus:
>>
>> > he's matching one sum against multiple cheques.
>>
>> No, I'm looking for "all the unpaid and posted invoices" whose totals

>> adds up to the check payment amount.
>
> Yeah, but if you have a pool of 35 invoices that are unpaid and get a 
> lump sum payment of $1074.37, the way I understand it you're looking 
> to automatically find the combination of invoices that equals that 
> amount and flag them paid.
>
> Which is what I -meant- by one sum (the payment) against multiple 
> cheques (actually invoices, now that I reread).  But the permutation 
> game is a headache and 3/4.

Oh, it can't be all that bad.  After all, if you have 35 invoices, there
are only 34,359,738,367 possible combinations.  (Though you don't
actually have to check all of them if you code it correctly.)

-- 
KenBrody at BestWeb dot net        spamtrap:
<g8ymh8uf001 at sneakemail.com>
http://www.hvcomputer.com
http://www.fileProPlus.com
_______________________________________________
Filepro-list mailing list
Filepro-list at lists.celestial.com
http://mailman.celestial.com/mailman/listinfo/filepro-list