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

[Ashley J G. <agi...@pu...>]

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.

-- 
Regards,
	Ashley J Gittins
	web: 	http://www.purple.dropbear.id.au
	jabber: agi...@pu...