sql-ledger-users — SQL-Ledger users

Re: [SL] accounting question

[Michael H. <mh...@it...>]

Thank you Joseph!
    We went through the chart of accounts with our CPA and that's  
what he said as well.
    I'll add some more detail here in case anyone else is ever  
searching.  We created an account under Current Assets and just  
called it "Distributions" with the Account Type set to "Equity".  We  
then reposted the distribution GL entries using it instead of the  
wage expense account.


On Jan 22, 2007, at 4:24 PM, Joseph A. Maffia wrote:

> Someone posted an accounting question last week about distributions  
> for an us s corp.
>
> Distributions should be shown as a seperate equity account.  
> Therefore it won't affect the profit and loss and you can close it  
> out the previous year against retained earnings.
>
>
>
> ---------------------------------------------------------------------- 
> ---
> 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] accounting question

[Joseph A. M. <ja...@jo...>]

Someone posted an accounting question last week about distributions for an us s corp. 

Distributions should be shown as a seperate equity account. Therefore it won't affect the profit and loss and you can close it out the previous year against retained earnings.

[SL] error message

[Joseph A. M. <ja...@jo...>]

I am getting the following error message when trying to post g/l transactions.
Am an accountant not computer geek. Any help appreciated.




DBD::Pg::db do failed: ERROR: could not load library "/usr/lib64/postgresql/plpgsql.so": /usr/lib64/postgresql/plpgsql.so: undefined symbol: resolve_polymorphic_argtypes

Error!
INSERT INTO gl (reference, employee_id)
VALUES ('116950461315233', (SELECT id FROM employee
WHERE login = 'cfsgadmin'))
ERROR: could not load library "/usr/lib64/postgresql/plpgsql.so": /usr/lib64/postgresql/plpgsql.so: undefined symbol: resolve_polymorphic_argtypes

[SL] New start (is the following method save ?)

[Luc v. S. <lu...@co...>]

Hello Sql-ledgerers,

I have copied the database of a environment where I need to start all 
over again (after 3 months). But I want to keep some information (like 
parts, customers suppliers, ledger etc)

I have experimented a bit and I think the following works:

-*Copy database*
-*Delete the content of all the of the following tables: *acc_trans, ap, 
ar, assembly, audittrail, business, dpt_trans, exchangerate, 
exchangerate, gifi (Does not apply in my country), gl, inventory, 
invoice, JCitems, oe, orderitems, partstax ( I will need to redo this 
because of mistakes), Status, Yearend

-*The following tables I Kept intact:* Chart, customer,customertax, 
defaults ( I know i need t alter a few things there when I will start), 
department, employee, language, makemodel, parts, partscustomer, 
partsgroup, pricegroup, project(was empty), recurring (was empty), 
Recurringemail (was empty), Recurringeprint (was empty), shipto (was 
empty),  sic (was empty), tax, translation, vendor, vendortax, warehouse,


 From this I want start all over again (not so much need to be entered),

    * Orderentries,
    * salesbookings
    * financialbookings etc


I have been playing around a bit and it seems it will work, can anybody 
comment on this exercise before I start putting in my orders, sales, 
bookings etcetera. It is allways very painfull to find out you have done 
things wrong

Tanks in advance

Luc

[SL] Cross currency invoice entry

[Ed W <li...@wi...>]

OK, so I have only sterling bank accounts, but I have an invoice from a 
supplier in USD.  I go to the bank and buy dollars using sterling and 
then wire the money to the beneficiary

....Now how to best enter this into the accounts system..?

I had previously been taking the rate that I got on my USD transaction 
and converting the invoice into stering at this rate, but it's awkward 
and error prone.  I now want to use the accrual type system and an FX 
account.

So I enter in the invoices in USD.  I then use the "payment" function to 
pay the invoice in USD, which I believe will leave me with a calculated 
GBP amount against my cash account.  Now the remaining bit is how to 
post the balancing item into an FX reserve account so that the correct 
amount of GBP is shown...?

Can anyone talk me through the best way to do this last step please?

Cheers

Ed W

Re: [SL] Can't find user guide

[William H. <wil...@gm...>]

Ryan Cloke wrote:
> I can't find any documentation for SQL-Ledger.  I finally got it 
> installed and working perfectly.  I then went to review the user guide 
> but found there isn't one.
> 
> Am I missing something?
> 
> Ryan

Hi Ryan take a look at
http://www.sql-ledger.org/cgi-bin/nav.pl?page=misc/support.html&title=Support
or
http://www.metatrontech.com/downloads/SL-basic.pdf

W

[SL] Can't find user guide

[Ryan C. <ry...@fl...>]

I can't find any documentation for SQL-Ledger.  I finally got it 
installed and working perfectly.  I then went to review the user guide 
but found there isn't one.

Am I missing something?

Ryan

Re: [SL] Apache errors

[Jeff R. <je...@jr...>]

Bingo!

You're a genius Jason, many thanks!

Jeff Roberts


Jason Rodrigues wrote:
> On Wednesday 17 January 2007 17:31, Jeff Roberts wrote:
>   
>> [Wed Jan 17 15:26:46 2007] [error] [client 192.168.24.5] malformed
>> header from script. Bad header=request id is Simplex-71 (1 fi: is.pl,
>> referer:
>> http://192.168.24.25/sql-ledger/is.pl?action=edit&id=11293&path=bin/mozilla
>> [ ... ]
>>
>> I don't even know where to start with this one. Does anyone here know
>> what's wrong or should I take this to an Apache2 forum?
>>     
>
> Is your printer command making any output?    I know you recently posted 
> something to the list re: your printer --- if you run the print command you 
> configured from the command line, does it emit any message? 
>
> If it does, you may have to add a '> /dev/null' to the command, to discard any 
> output.
>
> (hope you don't mind, but I'm having trouble mailing the list, so I put you on 
> the CC)
>
> Jason
>
>
>   

Re: [SL] Apache errors

[Jason R. <jas...@gm...>]

On Wednesday 17 January 2007 17:31, Jeff Roberts wrote:
>
> [Wed Jan 17 15:26:46 2007] [error] [client 192.168.24.5] malformed
> header from script. Bad header=request id is Simplex-71 (1 fi: is.pl,
> referer:
> http://192.168.24.25/sql-ledger/is.pl?action=edit&id=11293&path=bin/mozilla
> [ ... ]
> 
> I don't even know where to start with this one. Does anyone here know
> what's wrong or should I take this to an Apache2 forum?

Is your printer command making any output?    I know you recently posted 
something to the list re: your printer --- if you run the print command you 
configured from the command line, does it emit any message? 

If it does, you may have to add a '> /dev/null' to the command, to discard any 
output.

(hope you don't mind, but I'm having trouble mailing the list, so I put you on 
the CC)

Jason

Re: [SL] Apache errors

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

On Thursday 18 January 2007 02:24, Jeff Roberts wrote:
> Can anyone point me to which log files I'm supposed to look at or if
> anyone else has had this problem give me ahint as to where to look. I
> can always hit the back button on my browser after printing but i know
> it's not supposed to be like this.

I don't know about BSD, but most/several linux's have apache put logging 
detail into /var/log/httpd/ - into access_log and error_log. You might have 
something similar.

Your apache config file ( maybe /etc/httpd/....) will tell you where your 
logfiles are, hopefully there will be something there of use.

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

[SL] Why re-invent the wheel

[Jeff R. <je...@jr...>]

Hi Guys

Any Canadian users out there? I'm looking for the invoice.tex file for 
the NEBS cheques 9039 (cheque is in the center of the page). Either the 
old format or the new format would do. I can edit the .tex form but if 
someone has already done it why re-invent the wheel right? If anybody 
has the old version I'd be happy to create the new version and trade.

Jeff Roberts
JR Electronics

Re: [SL] Apache errors

[Jonas B. N. <jo...@gm...>]

Hi Jeff,

I expect you have had a look at the error log for the Apache webserver?

I am living with a similar problem with SQL-Ledger, every time I  
write to the system I get an error eventhough things go well.

But SQL-Ledger does not tell me anything of value.

jonasbn

On 17/01/2007, at 17.24, Jeff Roberts wrote:

> Hi All
>
> Whenever I print either Postscript or PDF to any printer I get:
>
>
>   Internal Server Error
>
> The server encountered an internal error or misconfiguration and was
> unable to complete your request.
>
> Please contact the server administrator, yo...@ex... and inform  
> them
> of the time the error occurred, and anything you might have done that
> may have caused the error.
>
> More information about this error may be available in the server  
> error log.
>
> ---------------------------------------------------------------------- 
> --
> Apache/2.0.50 (FreeBSD) PHP/5.2.0 with Suhosin-Patch Server at
> 192.168.24.25 Port 80
>
> yet the printing is accomplished just fine. I get the proper output  
> from
> both the laser and the inkjet and I can't find any errors in the  
> log files.
>
> Can anyone point me to which log files I'm supposed to look at or if
> anyone else has had this problem give me ahint as to where to look. I
> can always hit the back button on my browser after printing but i know
> it's not supposed to be like this.
>
> Jeff Roberts
>
> ---------------------------------------------------------------------- 
> ---
> 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] Apache errors

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

On Thursday 18 January 2007 02:24, Jeff Roberts wrote:
> Can anyone point me to which log files I'm supposed to look at or if
> anyone else has had this problem give me ahint as to where to look. I
> can always hit the back button on my browser after printing but i know
> it's not supposed to be like this.

I don't know about BSD, but most/several linux's have apache put logging 
detail into /var/log/httpd/ - into access_log and error_log. You might have 
something similar.

Your apache config file ( maybe /etc/httpd/....) will tell you where your 
logfiles are.

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

Re: [SL] Apache errors

[Jeff R. <je...@jr...>]

OK, I think I found the error log. If I'm correct it's 
/var/log/httpd-error.log

Here is the offending error.

[Wed Jan 17 15:26:46 2007] [error] [client 192.168.24.5] malformed 
header from script. Bad header=request id is Simplex-71 (1 fi: is.pl, 
referer: 
http://192.168.24.25/sql-ledger/is.pl?action=edit&id=11293&path=bin/mozilla&login=Jeff&sessionid=&callback=ar.pl%3faction%3dtransactions
%26direction%3dDESC%26oldsort%3dtransdate%26till%3d%26outstanding%3d%26path%3dbin%2fmozilla%26login%3dJeff%26sessionid%3d
%26summary%3d1%26title%3dAR%2520Transactions%26open%3dY%26l_transdate%3dY%26l_invnumber%3dY%26l_name%3dY%26l_amount
%3dY%26l_paid%3dY%26sort%3dtransdate

I don't even know where to start with this one. Does anyone here know 
what's wrong or should I take this to an Apache2 forum?

Keep in mind that the printer spits out the correct document, I get my 
invoices but then I get the error message. Note: If I hit "print and 
post" it prints correctly and posts correctly and then I get the error 
message.

Thanks
Jeff


Jeff Roberts wrote:
>  Hi All
>
>  Whenever I print either Postscript or PDF to any printer I get:
>
>
>  Internal Server Error
>
>  The server encountered an internal error or misconfiguration and was
>  unable to complete your request.
>
>  Please contact the server administrator, yo...@ex... and inform
>  them of the time the error occurred, and anything you might have done
>  that may have caused the error.
>
>  More information about this error may be available in the server
>  error log.
>
>  ------------------------------------------------------------------------
>  Apache/2.0.50 (FreeBSD) PHP/5.2.0 with Suhosin-Patch Server at
>  192.168.24.25 Port 80
>
>  yet the printing is accomplished just fine. I get the proper output
>  from both the laser and the inkjet and I can't find any errors in the
>  log files.
>
>  Can anyone point me to which log files I'm supposed to look at or if
>  anyone else has had this problem give me ahint as to where to look. I
>  can always hit the back button on my browser after printing but i
>  know it's not supposed to be like this.
>
>  Jeff Roberts
>
>  -------------------------------------------------------------------------
>  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
>

[SL] Accounting/SL question

[Michael H. <mh...@it...>]

Hi everybody,

    Long time lurker and occasional poster here.  I've searched  
through the archives and found only a couple meagre threads on this.
    We are an S-Corp in the United States and I own 100% of the  
shares.  I pay myself a salary which gets properly recorded in the  
Payroll Expenses account titled "Wages & Salaries".  I also receive  
distributions, which are handled differently according to IRS rules,  
(no SS/Medicare) and my CPA strongly recommended that those be  
recorded in a separate account.  This is all good and well but he  
also indicated that this money would show up as profit (to be passed  
through form K1 at the end of the year).  This has implications for  
the bank as well.  If it's recorded in an expense account like  
payroll then the business never shows a profit so they're a little  
leery of extending lines of credit and whatnot so having it show up  
as profit would be a Good Thing.
    My question then is which section of the accounts should I put it  
in?  How are other people handling this?  (Any CPAs familiar with SL  
reading this list?  :)


Thanks!

Michael

[SL] Apache errors

[Jeff R. <je...@jr...>]

Hi All

Whenever I print either Postscript or PDF to any printer I get:


  Internal Server Error

The server encountered an internal error or misconfiguration and was 
unable to complete your request.

Please contact the server administrator, yo...@ex... and inform them 
of the time the error occurred, and anything you might have done that 
may have caused the error.

More information about this error may be available in the server error log.

------------------------------------------------------------------------
Apache/2.0.50 (FreeBSD) PHP/5.2.0 with Suhosin-Patch Server at 
192.168.24.25 Port 80

yet the printing is accomplished just fine. I get the proper output from 
both the laser and the inkjet and I can't find any errors in the log files.

Can anyone point me to which log files I'm supposed to look at or if 
anyone else has had this problem give me ahint as to where to look. I 
can always hit the back button on my browser after printing but i know 
it's not supposed to be like this.

Jeff Roberts

[SL] Restarting with transactions and bookings, on a clean sheet but not having to renter, customers, suppliers, goods

[Luc v. S. <lu...@co...>]

I started using SQL-ledger in nov 2006 and have been basically using it 
to do my purchase orders and by doing that I learned gradually.

I postponed doing bookkeeing and sales bookings ( with a few exceptions 
). Now I have been reviewing my ledger and discovered there are some 
mistakes here and there. I have setup the general ledger now and 
basically want to redo my work so everything works according this ledger.

However I have not been able to easily undo all bookings and I have 
discovered that some things like services I can not alter the account at 
this moment. I have access to postgressql via PGadmin, but i am not 
knowledgable when it comes to postgress nor do I know enough about 
interdependecies within SQL-ledger.

I looked at the reverse transactions possibility but nothing seems to 
happen ( I assume this is beacuse I did not log transactions)

Next to that my database was setup in ASCIII encoding and PGadmin 
advices me to use UTF8.

The questions:  1)  Is there an easy way to start all over again 
whithout reentering all suppliers, customers, goods ?)
                        2) If not within SQl-ledger, can I just copy the 
tables out of ASCII encoded database an paste tese tables in a UTF8 
database ?

Thanks in advance for your quick reply

Luc

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

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

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

Thanks for the tips David.  It makes good sense to have these on hand
for each month end and save some hassles in case something comes up.

Thanks Dieter for mentioning the AR Outstanding report.  This is what I
was looking for.

--
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
David Boyle
Sent: Tuesday, January 16, 2007 9:29 AM
To: sql...@li...
Subject: Re: [SL] Outstanding payments on a certain date in the past

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

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


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

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

[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

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

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

[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

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