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

[Lenny L. <lle...@ma...>]

I guess this is what I will have to start doing as well.  Thanks for the
tip!

--
Lenny Leblanc
628 Leila Avenue
Winnipeg, Manitoba  R2V 3N7
P: 204.338.0233
=20
-----Original Message-----
From: sql...@li...
[mailto:sql...@li...] On Behalf Of
David Boyle
Sent: Tuesday, January 16, 2007 9:25 AM
To: sql...@li...
Subject: Re: [SL] Outstanding payments on a certain date in the past

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.
>=20
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?=20
>=20
> --
> Lenny Leblanc=20
> 628 Leila Avenue
> Winnipeg, Manitoba  R2V 3N7
> P: 204.338.0233
> =20
>=20
> -----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
>=20
> 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?
>=20
> Try the balance sheet report - you can do it as at a certain date,
cash
> or=20
> accruals basis.
>=20
> The figure I expect will be the one you want is "Accounts Receivable"
> (or your=20
> local equivalent) in the "Assets" group - IANAA but I think that
figure=20
> should represent all unpaid receivable amounts at that point in time.
> You=20
> should check with your auditor or accountant if it's actually what you
> need=20
> though.
>=20


------------------------------------------------------------------------
-
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share
your
opinions on IT & business topics through brief surveys - and earn cash
http://www.techsay.com/default.php?page=3Djoin.php&p=3Dsourceforge&CID=3D=
DEVDE
V
_______________________________________________
sql-ledger-users mailing list
sql...@li...
https://lists.sourceforge.net/lists/listinfo/sql-ledger-users