Calc Invoices to Pay?

[Stanley Barnett]

> Select * from invoice

This is the easy part as your SQL statement easily finds the qualifying
invoices that needs to be calculated in order to find the combination of
invoices that sums up to the Customer payment check amount. What I'm
looking for is the routine that iterates the hundreds or thousands of
combinations that totals the payment amount.

> So if they are looking for information in ways that the system as
configured does not supply, why not teach them to use a tool that
leverages that pool of talent and available training.  It's all about
the tools in the toolbox. Some make better hammers and some make better
pry-bars.

I totally agree...

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 Walter Vaughan
Sent: Tuesday, March 04, 2008 9:48 AM
To: filePro
Subject: Re: Calc Invoices to Pay?

Fairlight wrote

>I think you missed a critical part.  He's not just matching individual 
>checque amounts, he's matching one sum against multiple cheques.  
>Please show me the SQL statement that would come even remotely 
>close--because I don't believe it exists even in Oracle, much less
fPSQL.
>  
>
Select * from invoice
where
    customer number is "what it is"
    and status_flag is "unpaid"
    and amount between "Low value" and "High value"
order by
    date

That should find the invoices that have not been paid that could
accomodate a range, rather than a specific value.

Me? A selection set or table would be fine, but the reality is that
there are a million more places to learn how to write a SQL query than
how to use filePro's native tools. So if they are looking for
information in ways that the system as configured does not supply, why
not teach them to use a tool that leverages that pool of talent and
available training.

It's all about the tools in the toolbox. Some make better hammers and
some make better pry-bars.

--
Walter
_______________________________________________
Filepro-list mailing list
Filepro-list at lists.celestial.com
http://mailman.celestial.com/mailman/listinfo/filepro-list