sql-ledger-users

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

[Dr E. W L. <el...@li...>]

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?

greetings, el

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

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

[Dieter S. <dsi...@sq...>]

this is what the AR Outstanding report is for.

-- 
Dieter Simader       http://www.sql-ledger.com   Tel: (780) 472-8161
DWS Systems Inc.        Accounting Software      Fax: (780) 478-5281
============== On a clear disk you can seek forever ================

On Tue, 16 Jan 2007, 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?
>
> greetings, el
>
> -------------------------------------------------------------------------
> 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=join.php&p=sourceforge&CID=DEVDEV
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>

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

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

On Tue, 2007-01-16 at 08:13 -0700, Dieter Simader wrote:
> this is what the AR Outstanding report is for.
> 

My mistake...I hadn't tried that before.  That report does indeed show
items that were open as at the end date specified.

As an aside, your jurisdictions will possibly differ, but I have gotten
in the habit of generating needed reports at month end.  These reports
include A/R Aging, Inventory (extended) A/P Open, Open Receiving
(received but no vendor invoice yet), my tax reports and a few others.
Again, that's just me.

David Boyle
NAPCO

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

[Dr E. L. <el...@li...>]

Thank very much.

There is so much to learn :-))-O

el

on 1/16/07 5:13 PM Dieter Simader said the following:
> this is what the AR Outstanding report is for.


-- 
Dr. Eberhard W. Lisse  \        / Obstetrician & Gynaecologist (Saar)
el...@li... el108-ARIN / *     |   Telephone: +264 81 124 6733 (cell)
PO Box 8421             \     /   Please do NOT email to this address
Bachbrecht, Namibia     ;____/        if it is DNS related in ANY way