[freeside-users] Freeside Queries

[Ivan Kohler]

On Wed, Sep 06, 2006 at 02:11:46PM -0500, RTS wrote:
> Yea... If I am reading that query correctly that only shows people with a
> positive balance...
> 
> I'd like to see everyone's balance even if it is zero.

Edit httemplate/search/report_receivables.cgi - you want to disable the 
bit that does "where owed > 0" (paraphrased).  Be careful with the 
other, later qualifiers that append " AND " - need to do some
"( $where ? ' AND ' : 'WHERE ')" trickery or switch to a @where array 
like most of the other searches.

Bonus points[1] if you make it an option that can be specified in 
report_receivables.html and submit a patch.

[1] Bonus points redeemable for help with future questions.

-- 
_ivan


> -----Original Message-----
> From: freeside-users-bounces at sisd.com
> [mailto:freeside-users-bounces at sisd.com] On Behalf Of Damon Vincent
> Sent: Wednesday, September 06, 2006 12:46 PM
> To: Freeside users mailing list
> Subject: Re: [freeside-users] Freeside Queries
> 
> There is a report on called accounts receivable aging which give you 
> that via the web interface.  If you are looking to query the db directly 
> I can probably post what I use for bring data into quickbooks.
> 
> RTS wrote:
> > Is there a query that anyone can share that will list my customers and
> their
> > current balance??
> >
> > Thanks
> > Randy Smith
> >
> >
> >   
> 
> _______________________________________________
> freeside-users mailing list
> freeside-users at sisd.com
> http://420.am/cgi-bin/mailman/listinfo/freeside-users
> 
> -- 
> No virus found in this incoming message.
> Checked by AVG Anti-Virus.
> Version: 7.1.405 / Virus Database: 268.11.7/438 - Release Date: 9/5/2006
>  
> 
> -- 
> No virus found in this outgoing message.
> Checked by AVG Anti-Virus.
> Version: 7.1.405 / Virus Database: 268.11.7/438 - Release Date: 9/5/2006
>  
> 
> _______________________________________________
> freeside-users mailing list
> freeside-users at sisd.com
> http://420.am/cgi-bin/mailman/listinfo/freeside-users