Calc Invoices to Pay?
Fairlight
fairlite at fairlite.com
Tue Mar 4 05:58:56 PST 2008
At Tue, Mar 04, 2008 at 08:47:19AM -0500 or thereabouts,
suspect Walter Vaughan was observed uttering:
> Fairlight wrote:
>
> > <>This public service announcement was brought to you by Stanley Barnett:
> >
> > I need a routine that can find the correct invoices quickly by only
> > supplying the check amount. We are assuming the customer did not
> > partial pay an invoice.
> >
> >
> >I don't think that's possible to do with 100% accuracy.
> >
> Hum... perhaps this is a place that fpSQL might be of help.
> You should be able to find things like this that would not require
> writing code or understanding selection set development.
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.
> ...SCO Unix free now for 9 days...long live BSD !
Grats!
mark->
--
Fairlight-> ||| "There's an unceasing wind that | Fairlight Consulting
__/\__ ||| blows through this night / There's |
<__<>__> ||| dust in my eyes that blinds my | http://www.fairlite.com
\/ ||| sight / Theres a silence that | info at fairlite.com
||| speaks so much louder than words / |
||| Of promises broken..." -- |
||| Gilmour/Floyd |
More information about the Filepro-list
mailing list