[freeside] Invoicing issue

[ivan]

On Fri, Jul 20, 2001 at 05:25:38PM -0400, Steve Poirier wrote:
> But in accounting, i am far from beeing an expert. Sorry for any dumb questions.
> I first though that "Open invoices" were "Pending Invoices" with positive balance.
> And though the same thing about 30, 60 and 120 days. (For example: 60 days open invoices
> are unpaid or partially paid invoices aging from than 60 days.)

That would be the intent, yes.

> I think i get it wrong.
> Because even 0 balance invoices are still displayed in "Open invoices".

Invoices with "0 balance", or invoices with negative balance?

What do you see if you query the database directly on one of the "0
balance" invoices?

> I readed the documentation many times and readed almost all threads but i'm still
> unsure. Is this "Pending invoices" with different aging? If it is not, is there any
> existing 'add-ons' to FreeSIDE to generate this kind of reports.  Any hints on how
> to query the DB

htdocs/docs/schema.html should tell you what you need to know about
querying the database directly.

-- 
meow
_ivan