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

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

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.

Anyone come across this yet?=20

--
Lenny Leblanc=20
628 Leila Avenue
Winnipeg, Manitoba  R2V 3N7
P: 204.338.0233
=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

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=20
accruals basis.

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
Regards,
	Ashley J Gittins
	web: 	http://www.purple.dropbear.id.au
	jabber: agi...@pu...

------------------------------------------------------------------------
-
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