sql-ledger-users — SQL-Ledger users

Re: [SL] Poll - What do you want to see?

[David J <ja...@in...>]

You can start by including the following at about line 95 of
rp.pl

$form->{title} = $myconfig{company}.' :
'.$locale->text($report{$form->{report}}->{title});

(above should be all on one line, but in this webmail its
not.)
Build on it from there.

- DJ


> This is a very good idea, can you submit a patch?
> 
> 
> el
> 
> on 3/4/07 7:32 AM David J said the following:
> > Poll or Wish list
> > 
> > IMHO, SQL-L would be greatly enhanced by having the
> > company name print on each and every report.  Thoroughly
> > , consistently, and system wide.
> > 
> > We run SQL-L for multiple clients.  Until we tweaked the
> > reports (mostly in rp.pl), we had no way of knowing
> > which printed report belonged to which company. Yes, it
> > did cause confusion.
> > 
> > Seems such a simple thing, and odd that no-one has
> > mentioned this before.
> > 
> > David J
> > 
> >

Re: [SL] Poll - What do you want to see?

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

This is a very good idea, can you submit a patch?

I change the background color of the menus for this.

el

on 3/4/07 7:32 AM David J said the following:
> Poll or Wish list
> 
> IMHO, SQL-L would be greatly enhanced by having the company
> name print on each and every report.  Thoroughly,
> consistently, and system wide.
> 
> We run SQL-L for multiple clients.  Until we tweaked the
> reports (mostly in rp.pl), we had no way of knowing which
> printed report belonged to which company. Yes, it did cause
> confusion.
> 
> Seems such a simple thing, and odd that no-one has mentioned
> this before.
> 
> David J
> 
> -------------------------------------------------------------------------
> 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

-- 
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] Poll - What do you want to see?

[Rich S. <rsh...@ap...>]

Poll or Wish list

   A menu item within SL that allows prior year data to be saved to a
separate file and deleted from the current year. After a year-end close of
books this would permit the old data to be stored but not be part of the
current data set.

   It's a low priority since reports can always be limited by date.

Rich

-- 
Richard B. Shepard, Ph.D.               |    The Environmental Permitting
Applied Ecosystem Services, Inc.        |          Accelerator(TM)
<http://www.appl-ecosys.com>     Voice: 503-667-4517      Fax: 503-667-8863

Re: [SL] GAAP and fixed asset

[Vincenzo P. <epu...@it...>]

Hello Joseph,

Thanks for your kind reply.

Actually our accountant works with us, in our office, both as an
accountant for the company but also for this projects supporting ERPs
for SMBs.

Probably the GAAP issue should be split into to separate one: the
bureaucratic and the practical.

For the bureaucratic: We had a meeting with a guy from the Egyptian
ministry of Industry and trade. They have a project that supports the
implementation of ERPs for local business. Their main customer is
Oracle, of course.

When we discussed with them of our SL project and the first question
was: is SL GAAP compliant?

Maybe is a non existing issue, but we were not able to provide a
comprehensive reply.

In my (limited) understanding, it's the configuration of a specific
installation that should make SL (and any other accounting package) GAAP
compliant or not. If this is the case, it would be nice to have these
steps detailed, in case somebody has done it already, or try to document
them gathering the existing experience.

For the practical: my dream is that everybody in the company, including
my accountant, should use SL. Avoiding as much as possible having to
export data in order to maintain the highest level of consistency. Is
this too far from the reality?

For the fixed asset issue. The practical conclusion I reached and I
would like to validate with you, was keeping a separate "location" for
those items purchased for internal usage. However my accountant tells me
that this will cause a problem since it will affect the balance. And
this probably takes us again to the previous issue: if we export the
data into Excel than we can treat it as we like, apply depreciation and
so on. But again, it's not very elegant...

Thanks again for your time,

Enzo Puliatti



Joseph A. Maffia wrote:
> Hi Enzo,
>
> I am not sure what you mean by GAAP certification.  In the U.S.  we  use
> different standards then  international standards.  Although they are
> converging.  The IAASB may use terms I am not familiar.
>
> Are you talking about an auditors report that your financial statements
> are in accordance with GAAP? In the U.S. CPAs offer an opinion not a
> certification (which implies a guarantee or a high level of assurance
> then we provide) - this opinion states whether our financial statements
> are fairly stated in accordance with generally accepted accounting
> principles.
> I assume your accountant needs to take your financial statement and
> present them in a uniform format with the audit report, i.e. footnote,
> fonts, title, page number, etc.  This is common for presentation purposes.
>
> You can help your accountant reduce his time and therefore his fees if
> you can present the financial statement in a spreadsheet so that he
> would not have to manually re-enter the information. Lastly, you would
> need to make sure that your G/L account titles are similar to what they
> use in the financial statements. You should strive to mimic his report.
> Talk to your accountant get his suggestions for changes. If your books
> are not in order because you don't know bookkeeping then you should hire
> a bookkeeper.
>
> If your question is really - what is GAAP and how do I comply with it -
> it would be more difficult to teach you. But as the Chairman I would not
> suggest that you learn GAAP and bookkeeping. You should hire someone
> familiar. I.e. GAAP requires you to capitalize certain assets that have
> a useful life greater then one year. If you bought furniture you would
> have to depreciate it over its useful life. You would have an asset
> account with an accompanying contra asset account that accumulates
> depreciation. As you can see it gets involved. In the U.S. GAAP is free.
> You can get GAAP from the body that generates it from their website.
> www. fasb.org ( this won't really help you as you don't know the
> fundamentals) and  the  most countries have  joined an international
> standard setting body  called  IFAC. Each country has joined and the
> GAAP and audit standards would be covered by them. Good luck.
>
> With respect to fixed assets, Sql doesn't have a subledger for fixed
> assets that can maintain details about each piece of equipment,
> machinery or furniture. Perhaps you can request it as a future project.
>
> If I am totally off mark with your GAAP certification question- please
> educate me.
>
> Joe
>
> www.joemaffia.com
>
>
>
> Vincenzo Puliatti wrote:
> >> Good morning,
> >>
> >> My name is Enzo Puliatti. I am the Chairman of IT Synergy (
> www.itsyn.com ). We have an ongoing project aimed to spread the usage of
> SQL-Ledger for SMEs in Egypt and we are working on many localization and
> customization issues. However, we have recently faced a bureaucratic
> >> issue and we are trying to find out if there is any experience on GAAP
> certification for SQL-Ledger or at least a clear "how-to do". Have you
> done anything in this sense in your  country or are you aware of any
> successful or ongoing effort in this senses?
> >> I do understand that this may be different from country to country but
> we would like to start from some established experience. If nobody has
> collected these procedure we are most willing to collect all information
> and share it with all you.
> >> For those of you that (like me) are not to familiar with accounting
> procedures and rules, the  idea is to be able to completely replace
> manual bookkeeping (or "hybrid") with a fully computerized one using
> SQL-Ledger. I personally don't like the idea of using SL in my company
> and then having the accountant manually copying the information in a
> different format to present it to the relevant authorities.
> >> A second issue is related to management of fixed assets. I have seen
> several scattered posting about this issue without a clearly defined
> procedures. This topic is also not mentioned in the manual and other
> documentation that I have found online.
> >> The basic question is: how to treat the purchasing, inventorying and
> depreciation of fixed assets and other consumable that are meant to be
> used for the company itself and not for resale?
> >> Thanks and regards,
> >> Enzo Puliatti
> >>
>
> -------------------------------------------------------------------------
> 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
>
> -- 
>
> _____________
> Vincenzo Puliatti
> Chairman,IT Synergy
> Cairo Smart Village, Egypt
> +20 2 5371020
> www.itsyn.com
>

[SL] Can't open perl script / File name too long -> Premature end of script headers

[Antony G. <an...@wa...>]

Hi,

I have seen the following intermittently over the past few years with
SL, and finally, it's annoying me enough to ask the list.

The web browser asks me if I want to save or open the .pl file as if I
had initiated a download.  The errors below appear in the apache error log.

I'd appreciate any assistance to debug this - can't believe I'm the only
one.  SL 2.6.3, Apache 2.2.3, Perl 5.8.8.

[Sun Mar 04 14:32:04 2007] [error] [client 82.68.107.174] Can't open
perl script
"ct.pl%3faction%3dlist_names%26direction%3dDESC%26oldsort%3dname%26db%3dvendor%26path%3dbin%2fmozilla%26login%3droma%26sessionid%3d1173017171%26status%3dall%26l_subtotal%3d%26l_name%3dY%26l_contact%3dY%26l_phone%3dY%26l_email%3dY%26l_amount%3dY%26l_tax%3dY%26l_total%3dY%26name%3dJean-Philippe%2520Blangy%26sort%3dname":
File name too long, referer:
https://xxx.wayforth.co.uk/sql-ledger/ct.pl?action=edit&id=11379&db=vendor&path=bin/mozilla&login=roma&sessionid=1173017171&status=all&callback=ct.pl%253faction%253dlist_names%2526direction%253dDESC%2526oldsort%253dname%2526db%253dvendor%2526path%253dbin%252fmozilla%2526login%253droma%2526sessionid%253d1173017171%2526status%253dall%2526l_subtotal%253d%2526l_name%253dY%2526l_contact%253dY%2526l_phone%253dY%2526l_email%253dY%2526l_amount%253dY%2526l_tax%253dY%2526l_total%253dY%2526name%253dJean-Philippe%252520Blangy%2526sort%253dname
[Sun Mar 04 14:32:04 2007] [error] [client 82.68.107.174] Premature end
of script headers: ct.pl, referer:
https://xxx.wayforth.co.uk/sql-ledger/ct.pl?action=edit&id=11379&db=vendor&path=bin/mozilla&login=roma&sessionid=1173017171&status=all&callback=ct.pl%253faction%253dlist_names%2526direction%253dDESC%2526oldsort%253dname%2526db%253dvendor%2526path%253dbin%252fmozilla%2526login%253droma%2526sessionid%253d1173017171%2526status%253dall%2526l_subtotal%253d%2526l_name%253dY%2526l_contact%253dY%2526l_phone%253dY%2526l_email%253dY%2526l_amount%253dY%2526l_tax%253dY%2526l_total%253dY%2526name%253dJean-Philippe%252520Blangy%2526sort%253dname

Re: [SL] Poll - What do you want to see?

[David J <ja...@in...>]

Poll or Wish list

IMHO, SQL-L would be greatly enhanced by having the company
name print on each and every report.  Thoroughly,
consistently, and system wide.

We run SQL-L for multiple clients.  Until we tweaked the
reports (mostly in rp.pl), we had no way of knowing which
printed report belonged to which company. Yes, it did cause
confusion.

Seems such a simple thing, and odd that no-one has mentioned
this before.

David J

Re: [SL] Poll - What do you want to see?

[David J <ja...@in...>]

Joe
Your suggestion has my vote too.
It has been my intention to write some simple code for this
report, but just never seem to get around to it.
David J


"How to produce a traditional "General Ledger" transaction
listing ?
The kind of report that accountants and auditors have used
for generations.
Most GL systems permit the selection of transactions for
this report by account range, and/or date range.
The report then lists all filtered GL transactions (with ALL
details), sorted by account number (separated by a line
break, account code and description each time the account
code changes).  Transactions sorted into date order within
each account.  And the better systems also give a checkbox
for separate page for each account."


> A proper General ledger that is grouped by account and
> then date by default.
> 
> Joe
> 
> 
> www.joemaffia.com
> 
>

Re: [SL] Output reports to csv

[Wray C. <wr...@au...>]

For what it is worth, I find this mailing list useful when it contains
technical discussion of SQL ledger.  I don't find it useful when it
contains flaming and sniping.

> I didn't ask you to advise anyone, I asked you not to try and be one.
>
> el
>
> on 3/3/07 12:46 AM Christopher A. Bailey said the following:
>> I wouldn't advise anyone on this list to try to be an idiot. The good
>> doctor has already filled that position.
>>
>> -Chris
>>
>> ----- Original Message -----
>> From: "Dr Eberhard Lisse" <el...@li...>
>> To: da...@ke...
>> Cc: sql...@li...
>> Sent: Friday, March 2, 2007 7:45:08 AM (GMT-0800) America/Los_Angeles
>> Subject: Re: [SL] Output reports to csv
>>
>> Please don't try to be an idiot.
>>
>> el
>>
>> on 3/2/07 12:40 PM david said the following:
>>> On Fri, 2007-03-02 at 12:18 +0200, Dr Eberhard Lisse wrote:
>>>> It is almost trivial, to put this statement of mine into a perl
>>>> script,
>>>> and using the appropriate CPAN module, to generate Excell or
>>>> OpenOffice
>>>> spreadsheets.
>>>>
>>>
>>> It's NOT trivial. I'm sure I could manage it, and I'm sure you, being
>>> the ultimate renaissance man, could manage it too.. but I have to say
>>> that CSV export is a very sensible addition to the wish list.
>>>
>>> By your reasoning, there shouldn't be an invoice function in SL because
>>> anyone could do their own. Please try not to be a pompous ass.
>>
>> -------------------------------------------------------------------------
>> 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
>>
>>
>> -------------------------------------------------------------------------
>> 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
>
> --
> 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
>
> -------------------------------------------------------------------------
> 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
>
>


Wray Cason "Wrayman"
Auxilium Computing
www.auxiliumcomputing.com
wr...@au...
main: 206-595-2080
fax:  425-895-9825
msn: wr...@pi...
aim: AuxiliumWrayman
yahoo: wraycason
skype: wrayman

Re: [SL] Poll - What do you want to see?

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

I expect nothing. I take what I get :-)-O

But, again, a standalone program running on WIndoze, Mac and Linux would
be rather nice.



on 3/2/07 10:21 PM ma...@hu... said the following:
>> What I would like to have is a non web front end (perhaps with SQLite3)
>> as an executable for the Mac, Linux (and Windoze) :-)-O.
>>
> 
> Funny, but I am working on a command line tool for SL.
> 
> I'm curious what interface you expect.
> 
> Here's what I am planning:
> 
> $ sl ofx2txt feb.ofx | sl txt2gl -a 1060
> 
> ~/.slrc config (host, user, pass, etc).
> ~/.sl/coa.txt stores chart of accounts (dumped via psql)
> ~/.sl/txt2gl.txt map trx names to SL account id's.
> 
> I've got the ofx2txt command nearly done.

Re: [SL] Output reports to csv

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

I didn't ask you to advise anyone, I asked you not to try and be one.

el

on 3/3/07 12:46 AM Christopher A. Bailey said the following:
> I wouldn't advise anyone on this list to try to be an idiot. The good doctor has already filled that position.
> 
> -Chris
> 
> ----- Original Message -----
> From: "Dr Eberhard Lisse" <el...@li...>
> To: da...@ke...
> Cc: sql...@li...
> Sent: Friday, March 2, 2007 7:45:08 AM (GMT-0800) America/Los_Angeles
> Subject: Re: [SL] Output reports to csv
> 
> Please don't try to be an idiot.
> 
> el
> 
> on 3/2/07 12:40 PM david said the following:
>> On Fri, 2007-03-02 at 12:18 +0200, Dr Eberhard Lisse wrote:
>>> It is almost trivial, to put this statement of mine into a perl script,
>>> and using the appropriate CPAN module, to generate Excell or OpenOffice
>>> spreadsheets.
>>>
>>
>> It's NOT trivial. I'm sure I could manage it, and I'm sure you, being
>> the ultimate renaissance man, could manage it too.. but I have to say
>> that CSV export is a very sensible addition to the wish list.
>>
>> By your reasoning, there shouldn't be an invoice function in SL because
>> anyone could do their own. Please try not to be a pompous ass.
> 
> -------------------------------------------------------------------------
> 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
> 
> 
> -------------------------------------------------------------------------
> 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

-- 
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] Output reports to csv

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

Paul,

you assume that the accountant uses SL. Very few do. But the *DO* use Excel.

And with regards to the renaissance nonsense-man, this took me 10 
minutes, while fink was pulling the preadsheet::WriteExcel module:

#!/usr/bin/perl
use lib '/sw/lib/perl5';
use DBI;
$host = 'localhost';
####################
$dbase = "";
####################
use Spreadsheet::WriteExcel;
my $excel = new Spreadsheet::WriteExcel( "gl.xls" );
my $sheet  = $excel -> addworksheet("gl");
$db  = DBI->connect("dbi:Pg:dbname=$dbase;host=$host", $undef, $undef);
$query = qq|SELECT  c.accno, c.description, ac.transdate, g.id,
     rount(ac.amount::numeric,2), g.reference,
     g.description, substr(g.notes,1,55), ac.memo
FROM gl g
JOIN acc_trans ac ON (g.id = ac.trans_id)
JOIN chart c ON (ac.chart_id = c.id)
LEFT JOIN department d ON (d.id = g.department_id)
WHERE 1 = 1
     AND ac.transdate >= '2005-07-01'
     AND ac.transdate <= '2006-06-30'
UNION ALL
SELECT c.accno,  c.description, ac.transdate, a.id,
     round(ac.amount::numeric,2) as Amount,
     a.invnumber,
     ct.name, substr(a.notes,1,55) as Notes,
    ac.memo
FROM ar a
JOIN acc_trans ac ON (a.id = ac.trans_id)
JOIN chart c ON (ac.chart_id = c.id)
JOIN customer ct ON (a.customer_id = ct.id)
LEFT JOIN department d ON (d.id = a.department_id)
WHERE 1 = 1
    AND ac.transdate >= '2005-07-01'
    AND ac.transdate <= '2006-06-30'
UNION ALL
SELECT c.accno,  c.description, ac.transdate,  a.id,
     round(ac.amount::numeric,2) as Amount,
     a.invnumber,
     ct.name, substr(a.notes,1,55) as Notes,
    ac.memo
FROM ap a
JOIN acc_trans ac ON (a.id = ac.trans_id)
JOIN chart c ON (ac.chart_id = c.id)
JOIN vendor ct ON (a.vendor_id = ct.id)
LEFT JOIN department d ON (d.id = a.department_id)
WHERE 1 = 1
    AND ac.transdate >= '2005-07-01'
    AND ac.transdate <= '2006-06-30'
ORDER BY 1, 3, 4|;
$dbh = $db->prepare($query);		
$in = $dbh->execute or die;		
$line = 0;
while (@record = $dbh->fetchrow_array) {
     for ($column=0; $column<=7; $column++) {
	$sheet->write($line,$column,$record[$column]);	
     }
     $line++;
}

el


on 3/3/07 11:48 AM Paul Tammes said the following:
> C. Duncan Hudson schreef:
>> david wrote:
>>   
>>> On Fri, 2007-03-02 at 12:18 +0200, Dr Eberhard Lisse wrote:
>>>   
>>>     
>>>> It is almost trivial, to put this statement of mine into a perl script,
>>>> and using the appropriate CPAN module, to generate Excell or OpenOffice
>>>> spreadsheets.
>>>>
>>>>     
>>>>       
>>> It's NOT trivial. I'm sure I could manage it, and I'm sure you, being
>>> the ultimate renaissance man, could manage it too.. but I have to say
>>> that CSV export is a very sensible addition to the wish list. 
>>>   
>>>     
>> I believe it is sensible, and I would say should be required - because 
>> every other accounting package does it.  It has has been discussed many 
>> times on the list before, and we always get the 'Just cut and paste' 
>> responses.  And then eventually Dieter will chime in and say, "you have 
>> the source add it".
>>
>> Dunc
>>
>>   
> Being both a bookkeeper and a user I might be a bit prejudiced, but if 
> your accountant or bookkeeper is not able to use the sql-reports that 
> are built-in that should be reason for concern. The management can not 
> read a trial balance or a profit and loss account, that is why they like 
> to see it in excel or even better a pie-diagram or something equally simple.
> 
> If your accountant needs the same treatment, you probably hired a 
> manager and not a person with bookkeeping skills?
> Anyway, install a generic printer (yes, i am talking history) and print 
> to file should do almost any trick.
> If the copy paste to open office is too much of a hassle that is. Yes, 
> it works, open office and firefox...
> 
> Greetings from Holland,
> Paul Tammes
> 
> 
> -------------------------------------------------------------------------
> 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

-- 
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] Output reports to csv

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

Use the Excewrite module or whatever it is called these days,
write the hedaings, add the formats, use the DBI module,
prepare and execute the statement, read through every record
and write to the spreadsheed.

el

on 3/3/07 12:25 PM Russell Davie said the following:
> On Fri, 02 Mar 2007 12:18:46 +0200
> Dr Eberhard Lisse <el...@li...> wrote:
> 
>> It is almost trivial, to put this statement of mine into a perl script,
>> and using the appropriate CPAN module, to generate Excell or OpenOffice
>> spreadsheets.
>>
> 
> Could you please detail the steps to enable this?
> 
> This would be very useful.
> 
> TIA
> 
> Russell
> 
> 
> 

-- 
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] Poll - What do you want to see?

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

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

A proper General ledger that is grouped by account and then date by default.

Joe


www.joemaffia.com



C. Duncan Hudson wrote:
> ATM Logic wrote:
>>> After my last post I got to thinking...  It seems (to me)
>>> that the same items come up over and over on the list.  There
>>>    =

>> SL does all we need and more...  About the only wish I could ever want to
>> see is perhaps an ISO of a small, secure Linux Distro with SL built in,
>> capable of updateing Latex etc without breaking itself...  However this
>> would really only save me about a hour or so once every 3 years when I
make
>> enough changes that I require a reinstall of SL
>>
>>  =

> You're right it wouldn't save you much time, but it's not a bad idea. =

> Personally I don't find installing Apache and Postgres very daunting,
> but I found Latex to be a bear.  I'm sure there's alot of people out
> there that would download and use SQL-Ledger if there was an ISO image -
> because what alot of us take for granted as being straight forward can
> be a nightmare to others.  It would be simple to make a turnkey business
> out of it too.
>
> Dunc
>
> -------------------------------------------------------------------------
> 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=
DEVDEV
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.2 (GNU/Linux)
Comment: Using GnuPG with SUSE - http://enigmail.mozdev.org

iD8DBQFF6Yf/1Zo2InkR90QRAkRHAJ9iZ6BDFAY02IH/S977qE3RUWcRywCfTblV
9ql3+6i5TX6TxUqOWRGcYco=3D
=3DhlPN
-----END PGP SIGNATURE-----

Re: [SL] A couple of practical POS questions

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

On Fri, 2 Mar 2007, Matt Jackson wrote:
> Hello, all.

Hi Matt!

> I sell inventory items.
> I assume this means my process, starting from the beginning is:
>
> 1. Add my vendors

Yep - just a quick tip that might help you later - the "start date" you have 
on your vendors (defaults to the day you create them) will dictate how far 
you can back-date transactions for them. you might want to manually fudge 
that date if you plan to enter backdated purchases (eg, 01/01/1998 or 
whatever)

> 2. Add my items
>
> 3. (confused here) Add items I have ordered and their prices *at that time*
> (they change). I order 6 of this, 8 of that, etc. all on a single invoice
> from my supplier. Can I enter these "orders" with their particular order
> numbers/dates in that fashion in SQL Ledger? The only thing I was able to
> find was under "Order Entry > Purchase Order" I could enter one
> item/number/description, but not many. How does this work?

This is the first bit of SL "philosophy" for lack of a better word. Each time 
you enter an item (or a payment, or a line on something) press "Update". That 
will do the lookup (eg, if you enter a product code, update will look up the 
product, add the description and cost etc). After you update, you will find 
another line ready to be entered.

The golden rule: if you've done something, press update.

> Next, when I sell an item:
>
> 1. Go to POS > Sale
>
> 2. Enter order info
>
> BUT...
>
> - why is there only the "Record In: Accounts Receivable" option? Why can't
> I record it in checking account if I received a check? That is a different
> sort of asset.

That's a bit of an accounting question - the "Record in" shows where the sale 
gets recorded, which typically will be in something like "Accounts 
Receivable". You don't sell stuff to your bank account, you sell it to your 
clients, aka debtors, aka accounts receivable.

> - Why is there only one "record" for an item number/description/quantity,
> etc.? What if they order many items in one order? Is there a way to add
> more lines for more items?

Golden rule - click update :-)

> - Why do the "amount / source / memo" fields below that lead to my checking
> and petty cash accounts? Does the money "technically" go from AR to the
> asset account all within one invoice? Why not directly into cash or
> checking acct?

It's called double-entry accounting, and I'm not the right person to teach it 
to anyone, but essentially any action must affect two accounts equally and 
oppositely. If you receive money from a customer, it increases your bank 
account (that's one ledger entry) and reduces the amount in "accounts 
receivable", the other ledger entry.

Take a look at your "chart of accounts", "balance sheet" and "income 
statement" - you might want to turn on the "account number", headings and 
subtotal options in those reports.

Bear in mind that the POS interface is for a special case, where payment is 
done at the same time as invoicing. So normally, you'd invoice a customer 
(sale goes onto AR), then at a later time, they will pay you 
(amount "transfers" from AR to bank account). In the POS screen this is done 
as one step, but behind the scenes the transactions are the same.

Also, any general accounting book or information will help out with 
understanding why it's done the way it is. A pretty useful looking resource I 
came across is http://www.dwmbeancounter.com/tutorial/Tutorial.html
It might go a bit deep (I learnt most of this sort of stuff from various 
places so haven't gone right through it yet) but if you grok that you'll be 
very well armed to understand the accounting principles behind how SL works.

I hope though that this gives you enough to work out what's going on a dig a 
bit deeper with SL, let us know if anything's unclear.

> Thanks,
>
> Matt Jackson

You're welcome! :-)

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

Re: [SL] Output reports to csv

[Richard C <ric...@gm...>]

From: Dr Eberhard Lisse <el...@li...>
Date: Mar 3, 2007 10:34 PM
Subject: FWD: Re: [SL] Output reports to csv
>
> Do you do DIY brain surgery too?

No, I am an Obstetrician and Gynaecologist, so if you had asked about
Hysterectomies or Cesarean Sections I would have said yes :-)-O

el


Well, don't give up your day job.

Re: [SL] Output reports to csv

[Russell D. <rj...@ex...>]

On Fri, 02 Mar 2007 12:18:46 +0200
Dr Eberhard Lisse <el...@li...> wrote:

> It is almost trivial, to put this statement of mine into a perl script,
> and using the appropriate CPAN module, to generate Excell or OpenOffice
> spreadsheets.
> 

Could you please detail the steps to enable this?

This would be very useful.

TIA

Russell



-- 
Please, if possible, don't send me MS Word or Powerpoint attachments.
Send plain text, rich text format, html, or pdf instead.
Why? See: http://www.gnu.org/philosophy/sylvester-response.html

Re: [SL] Output reports to csv

[Paul T. <pt...@wa...>]

C. Duncan Hudson schreef:
> david wrote:
>   
>> On Fri, 2007-03-02 at 12:18 +0200, Dr Eberhard Lisse wrote:
>>   
>>     
>>> It is almost trivial, to put this statement of mine into a perl script,
>>> and using the appropriate CPAN module, to generate Excell or OpenOffice
>>> spreadsheets.
>>>
>>>     
>>>       
>> It's NOT trivial. I'm sure I could manage it, and I'm sure you, being
>> the ultimate renaissance man, could manage it too.. but I have to say
>> that CSV export is a very sensible addition to the wish list. 
>>   
>>     
> I believe it is sensible, and I would say should be required - because 
> every other accounting package does it.  It has has been discussed many 
> times on the list before, and we always get the 'Just cut and paste' 
> responses.  And then eventually Dieter will chime in and say, "you have 
> the source add it".
>
> Dunc
>
>   
Being both a bookkeeper and a user I might be a bit prejudiced, but if 
your accountant or bookkeeper is not able to use the sql-reports that 
are built-in that should be reason for concern. The management can not 
read a trial balance or a profit and loss account, that is why they like 
to see it in excel or even better a pie-diagram or something equally simple.

If your accountant needs the same treatment, you probably hired a 
manager and not a person with bookkeeping skills?
Anyway, install a generic printer (yes, i am talking history) and print 
to file should do almost any trick.
If the copy paste to open office is too much of a hassle that is. Yes, 
it works, open office and firefox...

Greetings from Holland,
Paul Tammes

Re: [SL] Poll - What do you want to see?

[david <da...@ke...>]

On Fri, 2007-03-02 at 09:49 -0500, C. Duncan Hudson wrote:
> After my last post I got to thinking...  It seems (to me) that the same 
> items come up over and over on the list.  There is continued development 
> of the application (and that's wonderful), but is it providing what 
> people are really looking for, wanting, needing?  What are the two 
> biggest things everyone wants fixed or added to SQL-Ledger?
> 
> My two biggest wants, needs are:  Sales tax flexibility - I need to be 
> able to make a taxed customer tax free (on occasion) and vice versa.  My 
> next wish would just make my life easier - I wish you could search (on 
> POs, Sales Orders and Invoices) by Shipto.


Search! If there is a field for it, you should be able to search for it.
It's what computers do best. What's wrong with a search page that lists
every field on the system similar to, or an extension of, the GL report.

Export would be nice - pretty much on any report at all. If you can
report it, I think you should be able to turn it into a spread sheet.
Perhaps a menu item that you click on and it exports the current report.
I know you can cut/paste, but that's really not very slick for a user.

Tax by line item: I'm not on the latest version so perhaps this has been
fixed? Last time I saw a post from Dieter (some time ago) he said that
it wasn't necessary. It IS necessary.

Please don't tell me that I can write a script or use a postgresql
function or do it myself - I'm not a programmer and shouldn't have to
be. I shouldn't have to be a geek either..

Re: [SL] Output reports to csv

[Christopher A. B. <cb...@ge...>]

I wouldn't advise anyone on this list to try to be an idiot. The good doctor has already filled that position.

-Chris

----- Original Message -----
From: "Dr Eberhard Lisse" <el...@li...>
To: da...@ke...
Cc: sql...@li...
Sent: Friday, March 2, 2007 7:45:08 AM (GMT-0800) America/Los_Angeles
Subject: Re: [SL] Output reports to csv

Please don't try to be an idiot.

el

on 3/2/07 12:40 PM david said the following:
> On Fri, 2007-03-02 at 12:18 +0200, Dr Eberhard Lisse wrote:
>> It is almost trivial, to put this statement of mine into a perl script,
>> and using the appropriate CPAN module, to generate Excell or OpenOffice
>> spreadsheets.
>>
>
>
> It's NOT trivial. I'm sure I could manage it, and I'm sure you, being
> the ultimate renaissance man, could manage it too.. but I have to say
> that CSV export is a very sensible addition to the wish list.
>
> By your reasoning, there shouldn't be an invoice function in SL because
> anyone could do their own. Please try not to be a pompous ass.

-------------------------------------------------------------------------
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] Poll - What do you want to see?

[<ma...@hu...>]

> What I would like to have is a non web front end (perhaps with SQLite3)
> as an executable for the Mac, Linux (and Windoze) :-)-O.
>

Funny, but I am working on a command line tool for SL.

I'm curious what interface you expect.

Here's what I am planning:

$ sl ofx2txt feb.ofx | sl txt2gl -a 1060

~/.slrc config (host, user, pass, etc).
~/.sl/coa.txt stores chart of accounts (dumped via psql)
~/.sl/txt2gl.txt map trx names to SL account id's.

I've got the ofx2txt command nearly done.

m

Re: [SL] Poll - What do you want to see?

[C. D. H. <Du...@Du...>]

Rich Shepard wrote:
> On Fri, 2 Mar 2007, C. Duncan Hudson wrote:
>
>   
>> Wow!  Lucky you.  Perhaps, then, if SQL-Ledger does absolutely everything
>> that you need you might want to suggest new career opportunities for
>> Dieter!
>>     
>
> Dunc,
>
>    Why? I'm only one user. You and others can provide him with sufficient
> paying work to prevent him from ever retiring.
>
>   
Personally, I can't afford the $22,000.00 usd quote to add sales tax 
flexibility to the application - so it won't be me keeping him from 
retiring.

Dunc

Re: [SL] Poll - What do you want to see?

[Rich S. <rsh...@ap...>]

On Fri, 2 Mar 2007, C. Duncan Hudson wrote:

> Wow!  Lucky you.  Perhaps, then, if SQL-Ledger does absolutely everything
> that you need you might want to suggest new career opportunities for
> Dieter!

Dunc,

   Why? I'm only one user. You and others can provide him with sufficient
paying work to prevent him from ever retiring.

-- 
Richard B. Shepard, Ph.D.               |    The Environmental Permitting
Applied Ecosystem Services, Inc.        |          Accelerator(TM)
<http://www.appl-ecosys.com>     Voice: 503-667-4517      Fax: 503-667-8863

Re: [SL] Poll - What do you want to see?

[C. D. H. <Du...@Du...>]

Rich Shepard wrote:
> On Fri, 2 Mar 2007, C. Duncan Hudson wrote:
>
>   
>> After my last post I got to thinking...  It seems (to me) that the same
>> items come up over and over on the list.
>>     
>
> Dunc,
>
>    SL does very much more than we need, so there's nothing I could contribute
> to a wish list.
>
>    However, your observation certainly argues for a wiki where a FAQ, various
> HOWTOs, and examples of setting up and using SL in different industries and
> companies can be documented by all users.
>
>    This wiki would be a resource to answer the questions that keep repeating
> like onions on a cheap hamburger.
>
>   
Wow!  Lucky you.  Perhaps, then, if SQL-Ledger does absolutely 
everything that you need you might want to suggest new career 
opportunities for Dieter!

Dunc

Re: [SL] Poll - What do you want to see?

[C. D. H. <Du...@Du...>]

ATM Logic wrote:
>> After my last post I got to thinking...  It seems (to me) 
>> that the same items come up over and over on the list.  There 
>>     
>
> SL does all we need and more...  About the only wish I could ever want to
> see is perhaps an ISO of a small, secure Linux Distro with SL built in,
> capable of updateing Latex etc without breaking itself...  However this
> would really only save me about a hour or so once every 3 years when I make
> enough changes that I require a reinstall of SL
>
>   
You're right it wouldn't save you much time, but it's not a bad idea.  
Personally I don't find installing Apache and Postgres very daunting, 
but I found Latex to be a bear.  I'm sure there's alot of people out 
there that would download and use SQL-Ledger if there was an ISO image - 
because what alot of us take for granted as being straight forward can 
be a nightmare to others.  It would be simple to make a turnkey business 
out of it too.

Dunc

Re: [SL] Poll - What do you want to see?

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

What I would like to have is a non web front end (perhaps with SQLite3)
as an executable for the Mac, Linux (and Windoze) :-)-O.

Because there would be a market :-)-O

el

on 3/2/07 6:08 PM ATM Logic said the following:
>> After my last post I got to thinking...  It seems (to me) 
>> that the same items come up over and over on the list.  There 
> 
> SL does all we need and more...  About the only wish I could ever want to
> see is perhaps an ISO of a small, secure Linux Distro with SL built in,
> capable of updateing Latex etc without breaking itself...  However this
> would really only save me about a hour or so once every 3 years when I make
> enough changes that I require a reinstall of SL