Re: [SL] Outstanding payments on a certain date in the past

[David B. <dav...@sb...>]

On Tue, 2007-01-16 at 09:06 -0600, Lenny Leblanc wrote:
> I am looking for something similar but I also need the list of
> outstanding invoices (at that time) along with the actual figure.  I
> guess this is seen as proof to back up the number.
> 
This will not help you after the fact, but each month as part of my
month end procedures I generate these reports and save as html.  I
haven't seen any method of bringing this information back (in itemized
format) unless you had a backup from that time.

David Boyle
NAPCO

> Anyone come across this yet? 
> 
> --
> Lenny Leblanc 
> 628 Leila Avenue
> Winnipeg, Manitoba  R2V 3N7
> P: 204.338.0233
>  
> 
> -----Original Message-----
> From: sql...@li...
> [mailto:sql...@li...] On Behalf Of
> Ashley J Gittins
> Sent: Tuesday, January 16, 2007 6:28 AM
> To: sql...@li...
> Subject: Re: [SL] Outstanding payments on a certain date in the past
> 
> On Tuesday 16 January 2007 19:48, Dr Eberhard W Lisse wrote:
> > Hi,
> >
> > My auditors need the amounts from invoices that were created before
> (for
> > example) 2006-07-01 and paid after 2006-06-30. In other words, they
> need
> > the total amount outstanding on 2006-06-30.
> >
> > I can probably hack up a SQL statement to access the database
> directly,
> > but I wonder if SQL-Ledger can be coaxed into doing this from the
> front
> > end?
> 
> Try the balance sheet report - you can do it as at a certain date, cash
> or 
> accruals basis.
> 
> The figure I expect will be the one you want is "Accounts Receivable"
> (or your 
> local equivalent) in the "Assets" group - IANAA but I think that figure 
> should represent all unpaid receivable amounts at that point in time.
> You 
> should check with your auditor or accountant if it's actually what you
> need 
> though.
>