Calc Invoices to Pay?
Stanley Barnett
stanley at stanlyn.com
Tue Mar 4 07:32:10 PST 2008
> 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.
I can only think of one other exception... and that would be if the
customer had 2 or more unpaid and posted invoices with the "exact same
invoice dollar amounts", which for us is rare.
Remember that we have already filtered out all paid and on-hold
invoices, so that only invoices that can accept payments is where the
focus is.
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 Fairlight
Sent: Tuesday, March 04, 2008 8:59 AM
To: filepro-list at lists.celestial.com
Subject: Re: Calc Invoices to Pay?
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 |
_______________________________________________
Filepro-list mailing list
Filepro-list at lists.celestial.com
http://mailman.celestial.com/mailman/listinfo/filepro-list
More information about the Filepro-list
mailing list