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