sql-ledger-users — SQL-Ledger users

[SL] Links to good double-entry explanations

[John H. <jo...@dh...>]

I'm collecting links to good explanations of double-entry bookkeeping for
the manual.  Suggestions?
-- 
John Hasler 
jo...@dh...
Elmwood, WI USA

Re: [SL] XML interface to SQL-Ledger/LedgerSMB

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

There does seem to be some increasing momentum towards XBRL.
http://www.xbrl.org/au/ 

- David J


> There was an article in the Financial Times on Oct 4th
> featuring XBRL (an XML application). Seems to be the wave
> of the future for financial reporting. See:
> 
>   
>
http://www.ft.com/cms/s/7fa7c764-5345-11db-99c5-0000779e2340.html
> 
> If you Google XBRL, there are lots of open source docs.
> 
> Bob G

Re: [SL] Moving SQL-Ledger to another server

[Mark B. <ma...@ga...>]

On Wed, Oct 11, 2006 at 04:57:52PM -0600, Danita Zanre wrote:

> I need to move my SQL-Ledger.  With the "backup" that I email
> myself every day, how difficult will this be to bring into a
> new postgresql install (I'm not that good with database
> backups, Linux, etc.).  I know I will need to move my
> customized templates, etc. over too.  Just mostly concerned
> about making sure I get the database moved properly.  
> 
> Any pointers appreciated.

I just did this.  The only problem I had was importing the Sql
Ledger backup file into Postgres as the sql-ledger user.

Also, the install docs don't exactly match how PostgreSql works.
For example, when creating a new user the prompts are different.
It's close, but not exact.  I just used the command-line args
then said "no" when Postgres asked me if the sql-ledger user
should be a superuser.

Those were my only two issues.  You can search the recent
archives for the details.

m

[SL] Moving SQL-Ledger to another server

[Danita Z. <da...@ca...>]

I need to move my SQL-Ledger.  With the "backup" that I email myself every =
day, how difficult will this be to bring into a new postgresql install =
(I'm not that good with database backups, Linux, etc.).  I know I will =
need to move my customized templates, etc. over too.  Just mostly =
concerned about making sure I get the database moved properly. =20

Any pointers appreciated.

Thanks.

Danita

Re: [SL] R: Is it possible to define parts without vendor invoice

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

Modify the chart of accounts and add the neccessary accounts.

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

On Tue, 10 Oct 2006, Gianluca Cecchi wrote:

> I selected Italy_cc2424-chart during creation of my dataset.
> Do you mean that this chart of accounts is incomplete for a fresh start?
> In the mean time I will try create other datasets with other charts to check and compare behaviour....
>
> Thanks
> Gianluca

[SL] R: Is it possible to define parts without vendor invoice

[Gianluca C. <gc...@pe...>]

I selected Italy_cc2424-chart during creation of my dataset.
Do you mean that this chart of accounts is incomplete for a fresh start?
In the mean time I will try create other datasets with other charts to =
check and compare behaviour....

Thanks=20
Gianluca
 =20

> -----Messaggio originale-----
> Da: sql...@li...=20
> [mailto:sql...@li...] Per=20
> conto di David Boyle
> Inviato: marted=EC 10 ottobre 2006 16.24
> A: sql...@li...
> Oggetto: Re: [SL] Is it possible to define parts without=20
> vendor invoice
>=20
> On Tue, 2006-10-10 at 12:28 +0200, Gianluca Cecchi wrote:
> > Can I predefine in my new environment the parts, without having to=20
> > create vendor invoice before?
> > Trying to add an article initially I get  the error message:
> >=20
> > Cannot create Part;COGS account does not exist!=20
> >=20
> Sounds like you haven't created your chart of accounts yet. =20
> You need to have an Inventory account, Income account and a=20
> COGS account set up prior to adding items.  Each item must be=20
> tied to these accounts and if they don't exist yet, it will=20
> balk at you.
>=20
> HTH,
> David Boyle
> NAPCO
>=20
> > And I don't remember if there is a workaround... or I'm missing=20
> > anything Thanks in advance.
> >=20
> >=20
> > Gianluca
> >=20
> ----------------------------------------------------------------------
> > --- Take Surveys. Earn Cash. Influence the Future of IT Join=20
> > SourceForge.net's Techsay panel and you'll get the chance to share=20
> > your opinions on IT & business topics through brief surveys -- and=20
> > earn cash=20
> >=20
> =
http://www.techsay.com/default.php?page=3Djoin.php&p=3Dsourceforge&CID=3D=
DEV
> > DEV _______________________________________________
> > sql-ledger-users mailing list
> > sql...@li...
> > https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>=20
>=20
> --------------------------------------------------------------
> -----------
> Take Surveys. Earn Cash. Influence the Future of IT Join=20
> SourceForge.net's Techsay panel and you'll get the chance to=20
> share your opinions on IT & business topics through brief=20
> surveys -- and earn cash=20
> http://www.techsay.com/default.php?page=3Djoin.php&p=3Dsourceforge
> &CID=3DDEVDEV
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>=20

Re: [SL] Is it possible to define parts without vendor invoice

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

On Tue, 2006-10-10 at 12:28 +0200, Gianluca Cecchi wrote:
> Can I predefine in my new environment the parts, without having to
> create vendor invoice before?
> Trying to add an article initially I get  the error message:
> 
> Cannot create Part;COGS account does not exist! 
> 
Sounds like you haven't created your chart of accounts yet.  You need to
have an Inventory account, Income account and a COGS account set up
prior to adding items.  Each item must be tied to these accounts and if
they don't exist yet, it will balk at you.

HTH,
David Boyle
NAPCO

> And I don't remember if there is a workaround... or I'm missing anything
> Thanks in advance.
> 
> 
> Gianluca 
> -------------------------------------------------------------------------
> 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] dataset newer than version

[Philippe <psc...@mi...>]

Hello,

I have upgraded postgres from 7.4 to 8.1 recently, I'm absolutely sure
I've login in after, checking my data and found everything fine. One week=
s
later, I want to login again, but I stuck with this message :

Error!

Dataset is newer than version!

the VERSION file in the sql-ledger root directory contains the string 2.6=
.19

What the problem ?

Regards

Philippe

Re: [SL] Is it possible to define parts without vendor invoice

[GeorgeOsvald <geo...@ya...>]

On Tuesday 10 October 2006 20:28, Gianluca Cecchi wrote:
> Can I predefine in my new environment the parts, without having to
> create vendor invoice before?
> Trying to add an article initially I get  the error message:
>
> Cannot create Part;COGS account does not exist!
>
> And I don't remember if there is a workaround... or I'm missing anything
> Thanks in advance.
>

You can create a part without vendor invoice but the quantity will be zero. To 
get parts to your inventory you will have to purchase them from a vendor.

[SL] Is it possible to define parts without vendor invoice

[Gianluca C. <gc...@pe...>]

Can I predefine in my new environment the parts, without having to
create vendor invoice before?
Trying to add an article initially I get  the error message:

Cannot create Part;COGS account does not exist!=20

And I don't remember if there is a workaround... or I'm missing anything
Thanks in advance.


Gianluca=20

Re: [SL] income statement doesn't match tax collected report

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

Hi Ryan
Unfortunately, IAAA and understand BAS and GST.
Do you ever receive money from customers that you record in
SL without allocating the amount to a customer invoice ?
We've spent some quality time just today looking at this
issue, and would be a coincidence if thats whats causing
your bother also.
Cheers
- David J (also from Sydney)

BTW, we don't see this as an SL problem or insect.  The
exact same issues emerge with a manual accounting system. 
The solution is to understand the accounting implications of
your entries.

> Hi Everyone
> 
> I am having a problem when using SQL Ledger for preparing
> my quarterly GST return (BAS). When I take the income
> statement for the period (on a cash basis) and compare the
> sales figures from this to the 'tax collected report'
> (also on a cash basis) the amount of sales are slightly
> larger (about 5%) in the income statement.
> 
> I don't understand where this discrepancy is coming from
> as we have no GST-free sales. The only explanation I can
> think of is if we have unintentionally left GST collected
> off one of our services, but I went through them and was
> unable to find any that didn't have GST.
> 
> Does anyone have any idea what might be causing different
> figures in these two reports?
> 
> Cheers,
> Ryan
> -- 
> 
>

[SL] income statement doesn't match tax collected report

[Ryan J. <rya...@ne...>]

Hi Everyone

I am having a problem when using SQL Ledger for preparing my quarterly
GST return (BAS). When I take the income statement for the period (on a
cash basis) and compare the sales figures from this to the 'tax
collected report' (also on a cash basis) the amount of sales are
slightly larger (about 5%) in the income statement.

I don't understand where this discrepancy is coming from as we have no
GST-free sales. The only explanation I can think of is if we have
unintentionally left GST collected off one of our services, but I went
through them and was unable to find any that didn't have GST.

Does anyone have any idea what might be causing different figures in
these two reports?

Cheers,
Ryan
-- 

Re: [SL] Importing some AP transactions from CSV file.

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

Stroller
Your import script will prolly need to update ALL the
relevant SL tables, including balanced DR and CR entries for
the GL table, else you'll throw the whole system into OOB.
For your 100 or so entries, I suspect that you'll be better
to enter them manually.
Perhaps become familiar with the SL keyboard shortcuts
(Alt-O) to post, etc, so that your data entry can be
achieved smoothly and swiftly, rather than being mousebound.
My $0.02 only (GST and VAT included).
- David J 
(via webmail)

[OOB =3d Out of balance]
> Hi there,
> 
> I have about 100 transactions in a spreadsheet. I can
> export these to   CSV file with the fields in any order
> and the date in any format.
> 
> EG:
>    26/10/05,=a320.90,Joe Smith
> or
>    32.06,2005-10,26,Willy Gates
>    (where the amount of the transaction is =a332.06)
> 
> These are costs of shipping of various items to customers
> - they   constitute only postage paid to the local
> logistics company.   Therefore I want to enter them into
> SL as AP transactions, all   against the same vendor
> number (54) and account (7500), all invoice   number "-".
> 
> Is it possible easily to import these all into SL, please?
> 
> In each case the amount & date of the transaction should
> be read from   the CSV file and the full amount marked as
> paid on the same day.   There should be only one item in
> each transaction, with a description   either of "Post &
> packing" or "Post & packing, $CUSTOMER" (where   $CUSTOMER
> is read from the CSV file).
> 
> I don't think the Generic import script at [1] will do the
> job. I   have no doubt that I could learn enough Perl to
> perform the import,   but since I've never used perl
> before it'd surely take me more than   the two hours or so
> required for me to type these entries in   manually. I'm
> ok in Bash so could probably write a shell script if  
> someone could suggest a format for dumping in via `psql`.
> 
> As this is a one-off and only 100 or so transactions this
> isn't   terribly important, but if someone has an import
> script laying around   which I could use to add
> transactions then you'd save me some time   wasted typing
> & I'd be grateful.
> 
> Stroller.
> 
> 
> 
> [1] http://www.sql-ledger.org/cgi-bin/nav.pl?page=3dmisc/ 
> conversions.html&title=3dConversions
> ----------------------------------------------------------

Re: [SL] sql-ledger/users/root login.conf

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

It is a configuration file for the administrator.

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

On Mon, 9 Oct 2006, Torben Brosten wrote:

> Hi,
>
> When upgrading a system from 2.6.7 to 2.6.19, there is a new file:
>
>   sql-ledger/users/root login.conf
>
> What is its purpose?  It does not show up in the admin.pl page's user list.
>
> Torben
>
>
> -------------------------------------------------------------------------
> 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] sql-ledger/users/root login.conf

[Torben B. <to...@ka...>]

Hi,

When upgrading a system from 2.6.7 to 2.6.19, there is a new file:

  sql-ledger/users/root login.conf

What is its purpose?  It does not show up in the admin.pl page's user list.

Torben

Re: [SL] FTP installation

[Fabien A. <fab...@gm...>]

I'm trying to install SQL leger via FTP.



I'm using FileZilla, Zipgenius, webshell4 and my ISPphpPgAdmin. I have a
cgi-bin folder and the CGI dir function.



I uploaded sql ledger files to my cgi-bin, I created an .htaccess file. I
was able to set up a PostgreSQL database and run the admin.pl. I created the
dataset and a sql ledger user and I succeed with that.

But I cannot run the login.pl, I get the 500  Internal server error and I
cannot carry on. What I can do to solve this problem?



Should I use ASCII or binary transfer type for the .htaccess file?

Should I CHMOD some files or folder? And which files and/ or folder?

Do I need to set up .htpasswd file for both users and templates directories?



Thanks in advance and I really appreciate your help.



Kind regards,


2006/10/8, Fabien Adouani <fab...@gm...>:
>
> Paul,
>
> The database was created via PgAdmin, from the admin.pl the dataset and a
> user have been set up with success. But when trying to connect as user by
> using login.pl  I get the 500 error web page. Did you have some help?.
>
> Thanks
>
> 2006/10/8, Paul Tammes <pt...@wa...>:
> >
> > -----BEGIN PGP SIGNED MESSAGE-----
> > Hash: SHA1
> >
> > Fabien Adouani wrote:
> >
> >
> > Fabien,
> >
> > you created a user for PostgreSQL database (sql-ledger I suppose, that
> > is the default in howto and faq iirc) and so you can login to the
> > admin.pl.
> >
> > Did you also create a database, either via admin.pl or via PgAdmin, and
> > add a user for that database via admin.pl? Before you did that, a login
> > will be as futile as resistance to the Borg...
> > > Thank you for your previous answer, I appreciated.
> > >
> > > I'm trying to install SQL leger via FTP.
> > >
> > >
> > >
> > > I'm using FileZilla, Zipgenius, webshell4 and my ISPphpPgAdmin. I have
> > a
> > > cgi-bin folder and the CGI dir function.
> > >
> > >
> > >
> > > I uploaded sql ledger files to my cgi-bin, I created an .htaccess
> > file. I
> > > was able to set up a PostgreSQL database and run the admin.pl. I
> > created a
> > > sql ledger user and I succeed with that. But I cannot run the login.pl,
> > I
> > > get the 500 error and I cannot carry on. What I can do to solve this
> > > problem?
> > >
> > >
> > >
> > > Should I use ASCII or binary transfer type for the .htaccess file?
> > >
> > > Should I CHMOD some files or folder? And which files and/ or folder?
> > >
> > > Do I need to set up .htpasswd file for both users and templates
> > directories?
> > >
> > >
> > >
> > > Thanks in advance and I really appreciate your help.
> > >
> > >
> > >
> > > Kind regards,
> > >
> > >
> > >
> > > Fabien
> > >
> > >
> > > 2006/10/6, Dieter Simader <dsi...@sq...>:
> > >> Installing via ftp is quite easy but your ISP must play along.
> > >>
> > >> a) you must be able to configure your virtual server to run perl
> > scripts
> > >> from the directory where you set up SQL-Ledger
> > >> b) plpgsql must be installed in template1 or at least your ISP must
> > >> cooperate and install the language handler for your database
> > >>
> > >> Once you've got all this in place upload the compressed file an
> > ungzip. If
> > >> you cannot do that ungzip locally and upload the sql-ledger folder.
> > >>
> > >> Then create a .htaccess file in the sql-ledger folder and put this in
> > >> the file
> > >>
> > >> DirectoryIndex login.pl
> > >> Options +ExecCGI
> > >>
> > >> Use the program as you would on a private server. admin.pl works just
> > the
> > >> same. The only difference is that you supply the name of the database
> > >> instead of letting the program create one for you. You are most
> > likely not
> > >> allowed to create new databases outside of pgadmin or whatever your
> > ISP
> > >> uses so you create a new database with pgadmin and enter the name of
> > the
> > >> database in the admin screen when you create a new dataset.
> > >>
> > >> --
> > >> Dieter Simader       http://www.sql-ledger.com   Tel: (408) 898-4421
> > >> DWS Systems Inc.        Accounting Software      Fax: (780) 478-5281
> > >> ============== On a clear disk you can seek forever ================
> > >>
> > >> On Fri, 6 Oct 2006, Fabien Adouani wrote:
> > >>
> > >>> Hi,
> > >>>
> > >>> I'm trying for more than 2 weeks to install Sql-ledger on my shared
> > >>> web server ( www.surftown.com). As I don't have the access to the
> > >>> server's configuration files,
> > >>>
> > >>> I'm trying with the FTP installation but without success.
> > >>>
> > >>>
> > >>>
> > >>> I'm getting this with admin.pl:
> > >>>
> > >>>
> > >>>
> > >>> 500 Internal Server Error
> > >>>
> > >>> The server encountered an internal error or misconfiguration and was
> >
> > >>> unable to complete your request.
> > >>>
> > >>> Please contact the server administrator, xx...@xx... 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/1.3.37 Server at xxx.com Port 80
> > >>>
> > >>>
> > >>>
> > >>> My questions are:
> > >>>
> > >>>
> > >>>
> > >>> If it's possible for me to run SQL-ledger on surftown Linux advance
> > >> package?
> > >>> What should I do more to be able to run a smooth installation?
> > >>>
> > >>>
> > >>>
> > >>> Linux Advance package:
> > >>>
> > >>> PHP4
> > >>>
> > >>> Sun ASP
> > >>>
> > >>> MySQL 4 Databases
> > >>>
> > >>> phpMyAdmin
> > >>>
> > >>> PostgrSQL 7.3 Databases
> > >>>
> > >>> phpPgAdmin
> > >>>
> > >>> Egne CGI-scripts
> > >>>
> > >>>
> > >>>
> > >>> Thank you for your help
> > >>>
> > >>>
> > >>>
> > >>>
> > >>
> > >>
> > -------------------------------------------------------------------------
> > >> 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
> > >>
> > >
> > >
> > >
> >
> > -----BEGIN PGP SIGNATURE-----
> > Version: GnuPG v1.4.2 (GNU/Linux)
> > Comment: Using GnuPG with SUSE - http://enigmail.mozdev.org
> >
> > iD8DBQFFKUky4ruw/FH66T8RAhEjAJ0X51dt0bWv8/LkMCkUOyGKzabWCACgjzhT
> > q4a5c9xDeuI5o5r2to+p23Q=
> > =n3Qn
> > -----END PGP SIGNATURE-----
> >
> > -------------------------------------------------------------------------
> >
> > 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
> >
>
>
>
> --
> Fabien Adouani
> Sweden




-- 
Fabien Adouani
Sweden

Re: [SL] FTP installation

[Fabien A. <fab...@gm...>]

Paul,

The database was created via PgAdmin, from the admin.pl the dataset and a
user have been set up with success. But when trying to connect as user by
using login.pl  I get the 500 error web page. Did you have some help?.

Thanks

2006/10/8, Paul Tammes <pt...@wa...>:
>
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> Fabien Adouani wrote:
>
>
> Fabien,
>
> you created a user for PostgreSQL database (sql-ledger I suppose, that
> is the default in howto and faq iirc) and so you can login to the admin.pl
> .
>
> Did you also create a database, either via admin.pl or via PgAdmin, and
> add a user for that database via admin.pl? Before you did that, a login
> will be as futile as resistance to the Borg...
> > Thank you for your previous answer, I appreciated.
> >
> > I'm trying to install SQL leger via FTP.
> >
> >
> >
> > I'm using FileZilla, Zipgenius, webshell4 and my ISPphpPgAdmin. I have a
> > cgi-bin folder and the CGI dir function.
> >
> >
> >
> > I uploaded sql ledger files to my cgi-bin, I created an .htaccess file.
> I
> > was able to set up a PostgreSQL database and run the admin.pl. I created
> a
> > sql ledger user and I succeed with that. But I cannot run the login.pl,
> I
> > get the 500 error and I cannot carry on. What I can do to solve this
> > problem?
> >
> >
> >
> > Should I use ASCII or binary transfer type for the .htaccess file?
> >
> > Should I CHMOD some files or folder? And which files and/ or folder?
> >
> > Do I need to set up .htpasswd file for both users and templates
> directories?
> >
> >
> >
> > Thanks in advance and I really appreciate your help.
> >
> >
> >
> > Kind regards,
> >
> >
> >
> > Fabien
> >
> >
> > 2006/10/6, Dieter Simader <dsi...@sq...>:
> >> Installing via ftp is quite easy but your ISP must play along.
> >>
> >> a) you must be able to configure your virtual server to run perl
> scripts
> >> from the directory where you set up SQL-Ledger
> >> b) plpgsql must be installed in template1 or at least your ISP must
> >> cooperate and install the language handler for your database
> >>
> >> Once you've got all this in place upload the compressed file an ungzip.
> If
> >> you cannot do that ungzip locally and upload the sql-ledger folder.
> >>
> >> Then create a .htaccess file in the sql-ledger folder and put this in
> >> the file
> >>
> >> DirectoryIndex login.pl
> >> Options +ExecCGI
> >>
> >> Use the program as you would on a private server. admin.pl works just
> the
> >> same. The only difference is that you supply the name of the database
> >> instead of letting the program create one for you. You are most likely
> not
> >> allowed to create new databases outside of pgadmin or whatever your ISP
> >> uses so you create a new database with pgadmin and enter the name of
> the
> >> database in the admin screen when you create a new dataset.
> >>
> >> --
> >> Dieter Simader       http://www.sql-ledger.com   Tel: (408) 898-4421
> >> DWS Systems Inc.        Accounting Software      Fax: (780) 478-5281
> >> ============== On a clear disk you can seek forever ================
> >>
> >> On Fri, 6 Oct 2006, Fabien Adouani wrote:
> >>
> >>> Hi,
> >>>
> >>> I'm trying for more than 2 weeks to install Sql-ledger on my shared
> >>> web server (www.surftown.com). As I don't have the access to the
> >>> server's configuration files,
> >>>
> >>> I'm trying with the FTP installation but without success.
> >>>
> >>>
> >>>
> >>> I'm getting this with admin.pl:
> >>>
> >>>
> >>>
> >>> 500 Internal Server Error
> >>>
> >>> The server encountered an internal error or misconfiguration and was
> >>> unable to complete your request.
> >>>
> >>> Please contact the server administrator, xx...@xx... 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/1.3.37 Server at xxx.com Port 80
> >>>
> >>>
> >>>
> >>> My questions are:
> >>>
> >>>
> >>>
> >>> If it's possible for me to run SQL-ledger on surftown Linux advance
> >> package?
> >>> What should I do more to be able to run a smooth installation?
> >>>
> >>>
> >>>
> >>> Linux Advance package:
> >>>
> >>> PHP4
> >>>
> >>> Sun ASP
> >>>
> >>> MySQL 4 Databases
> >>>
> >>> phpMyAdmin
> >>>
> >>> PostgrSQL 7.3 Databases
> >>>
> >>> phpPgAdmin
> >>>
> >>> Egne CGI-scripts
> >>>
> >>>
> >>>
> >>> Thank you for your help
> >>>
> >>>
> >>>
> >>>
> >>
> >>
> -------------------------------------------------------------------------
> >> 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
> >>
> >
> >
> >
>
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.4.2 (GNU/Linux)
> Comment: Using GnuPG with SUSE - http://enigmail.mozdev.org
>
> iD8DBQFFKUky4ruw/FH66T8RAhEjAJ0X51dt0bWv8/LkMCkUOyGKzabWCACgjzhT
> q4a5c9xDeuI5o5r2to+p23Q=
> =n3Qn
> -----END PGP SIGNATURE-----
>
> -------------------------------------------------------------------------
> 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
>



-- 
Fabien Adouani
Sweden

Re: [SL] FTP installation

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

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

Fabien Adouani wrote:


Fabien,

you created a user for PostgreSQL database (sql-ledger I suppose, that
is the default in howto and faq iirc) and so you can login to the admin.pl.

Did you also create a database, either via admin.pl or via PgAdmin, and
add a user for that database via admin.pl? Before you did that, a login
will be as futile as resistance to the Borg...
> Thank you for your previous answer, I appreciated.
> 
> I'm trying to install SQL leger via FTP.
> 
> 
> 
> I'm using FileZilla, Zipgenius, webshell4 and my ISPphpPgAdmin. I have a
> cgi-bin folder and the CGI dir function.
> 
> 
> 
> I uploaded sql ledger files to my cgi-bin, I created an .htaccess file. I
> was able to set up a PostgreSQL database and run the admin.pl. I created a
> sql ledger user and I succeed with that. But I cannot run the login.pl, I
> get the 500 error and I cannot carry on. What I can do to solve this
> problem?
> 
> 
> 
> Should I use ASCII or binary transfer type for the .htaccess file?
> 
> Should I CHMOD some files or folder? And which files and/ or folder?
> 
> Do I need to set up .htpasswd file for both users and templates directories?
> 
> 
> 
> Thanks in advance and I really appreciate your help.
> 
> 
> 
> Kind regards,
> 
> 
> 
> Fabien
> 
> 
> 2006/10/6, Dieter Simader <dsi...@sq...>:
>> Installing via ftp is quite easy but your ISP must play along.
>>
>> a) you must be able to configure your virtual server to run perl scripts
>> from the directory where you set up SQL-Ledger
>> b) plpgsql must be installed in template1 or at least your ISP must
>> cooperate and install the language handler for your database
>>
>> Once you've got all this in place upload the compressed file an ungzip. If
>> you cannot do that ungzip locally and upload the sql-ledger folder.
>>
>> Then create a .htaccess file in the sql-ledger folder and put this in
>> the file
>>
>> DirectoryIndex login.pl
>> Options +ExecCGI
>>
>> Use the program as you would on a private server. admin.pl works just the
>> same. The only difference is that you supply the name of the database
>> instead of letting the program create one for you. You are most likely not
>> allowed to create new databases outside of pgadmin or whatever your ISP
>> uses so you create a new database with pgadmin and enter the name of the
>> database in the admin screen when you create a new dataset.
>>
>> --
>> Dieter Simader       http://www.sql-ledger.com   Tel: (408) 898-4421
>> DWS Systems Inc.        Accounting Software      Fax: (780) 478-5281
>> ============== On a clear disk you can seek forever ================
>>
>> On Fri, 6 Oct 2006, Fabien Adouani wrote:
>>
>>> Hi,
>>>
>>> I'm trying for more than 2 weeks to install Sql-ledger on my shared
>>> web server (www.surftown.com). As I don't have the access to the
>>> server's configuration files,
>>>
>>> I'm trying with the FTP installation but without success.
>>>
>>>
>>>
>>> I'm getting this with admin.pl:
>>>
>>>
>>>
>>> 500 Internal Server Error
>>>
>>> The server encountered an internal error or misconfiguration and was
>>> unable to complete your request.
>>>
>>> Please contact the server administrator, xx...@xx... 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/1.3.37 Server at xxx.com Port 80
>>>
>>>
>>>
>>> My questions are:
>>>
>>>
>>>
>>> If it's possible for me to run SQL-ledger on surftown Linux advance
>> package?
>>> What should I do more to be able to run a smooth installation?
>>>
>>>
>>>
>>> Linux Advance package:
>>>
>>> PHP4
>>>
>>> Sun ASP
>>>
>>> MySQL 4 Databases
>>>
>>> phpMyAdmin
>>>
>>> PostgrSQL 7.3 Databases
>>>
>>> phpPgAdmin
>>>
>>> Egne CGI-scripts
>>>
>>>
>>>
>>> Thank you for your help
>>>
>>>
>>>
>>>
>>
>> -------------------------------------------------------------------------
>> 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
>>
> 
> 
> 

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.2 (GNU/Linux)
Comment: Using GnuPG with SUSE - http://enigmail.mozdev.org

iD8DBQFFKUky4ruw/FH66T8RAhEjAJ0X51dt0bWv8/LkMCkUOyGKzabWCACgjzhT
q4a5c9xDeuI5o5r2to+p23Q=
=n3Qn
-----END PGP SIGNATURE-----

Re: [SL] FTP installation

[Fabien A. <fab...@gm...>]

Thank you for your previous answer, I appreciated.

I'm trying to install SQL leger via FTP.



I'm using FileZilla, Zipgenius, webshell4 and my ISPphpPgAdmin. I have a
cgi-bin folder and the CGI dir function.



I uploaded sql ledger files to my cgi-bin, I created an .htaccess file. I
was able to set up a PostgreSQL database and run the admin.pl. I created a
sql ledger user and I succeed with that. But I cannot run the login.pl, I
get the 500 error and I cannot carry on. What I can do to solve this
problem?



Should I use ASCII or binary transfer type for the .htaccess file?

Should I CHMOD some files or folder? And which files and/ or folder?

Do I need to set up .htpasswd file for both users and templates directories?



Thanks in advance and I really appreciate your help.



Kind regards,



Fabien


2006/10/6, Dieter Simader <dsi...@sq...>:
>
> Installing via ftp is quite easy but your ISP must play along.
>
> a) you must be able to configure your virtual server to run perl scripts
> from the directory where you set up SQL-Ledger
> b) plpgsql must be installed in template1 or at least your ISP must
> cooperate and install the language handler for your database
>
> Once you've got all this in place upload the compressed file an ungzip. If
> you cannot do that ungzip locally and upload the sql-ledger folder.
>
> Then create a .htaccess file in the sql-ledger folder and put this in
> the file
>
> DirectoryIndex login.pl
> Options +ExecCGI
>
> Use the program as you would on a private server. admin.pl works just the
> same. The only difference is that you supply the name of the database
> instead of letting the program create one for you. You are most likely not
> allowed to create new databases outside of pgadmin or whatever your ISP
> uses so you create a new database with pgadmin and enter the name of the
> database in the admin screen when you create a new dataset.
>
> --
> Dieter Simader       http://www.sql-ledger.com   Tel: (408) 898-4421
> DWS Systems Inc.        Accounting Software      Fax: (780) 478-5281
> ============== On a clear disk you can seek forever ================
>
> On Fri, 6 Oct 2006, Fabien Adouani wrote:
>
> > Hi,
> >
> > I'm trying for more than 2 weeks to install Sql-ledger on my shared
> > web server (www.surftown.com). As I don't have the access to the
> > server's configuration files,
> >
> > I'm trying with the FTP installation but without success.
> >
> >
> >
> > I'm getting this with admin.pl:
> >
> >
> >
> > 500 Internal Server Error
> >
> > The server encountered an internal error or misconfiguration and was
> > unable to complete your request.
> >
> > Please contact the server administrator, xx...@xx... 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/1.3.37 Server at xxx.com Port 80
> >
> >
> >
> > My questions are:
> >
> >
> >
> > If it's possible for me to run SQL-ledger on surftown Linux advance
> package?
> >
> > What should I do more to be able to run a smooth installation?
> >
> >
> >
> > Linux Advance package:
> >
> > PHP4
> >
> > Sun ASP
> >
> > MySQL 4 Databases
> >
> > phpMyAdmin
> >
> > PostgrSQL 7.3 Databases
> >
> > phpPgAdmin
> >
> > Egne CGI-scripts
> >
> >
> >
> > Thank you for your help
> >
> >
> >
> >
>
>
> -------------------------------------------------------------------------
> 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
>



-- 
Fabien Adouani
Sweden

[SL] Importing some AP transactions from CSV file.

[Stroller <lin...@my...>]

Hi there,

I have about 100 transactions in a spreadsheet. I can export these to =20=

CSV file with the fields in any order and the date in any format.

EG:
   26/10/05,=A320.90,Joe Smith
or
   32.06,2005-10,26,Willy Gates
   (where the amount of the transaction is =A332.06)

These are costs of shipping of various items to customers - they =20
constitute only postage paid to the local logistics company. =20
Therefore I want to enter them into SL as AP transactions, all =20
against the same vendor number (54) and account (7500), all invoice =20
number "-".

Is it possible easily to import these all into SL, please?

In each case the amount & date of the transaction should be read from =20=

the CSV file and the full amount marked as paid on the same day. =20
There should be only one item in each transaction, with a description =20=

either of "Post & packing" or "Post & packing, $CUSTOMER" (where =20
$CUSTOMER is read from the CSV file).

I don't think the Generic import script at [1] will do the job. I =20
have no doubt that I could learn enough Perl to perform the import, =20
but since I've never used perl before it'd surely take me more than =20
the two hours or so required for me to type these entries in =20
manually. I'm ok in Bash so could probably write a shell script if =20
someone could suggest a format for dumping in via `psql`.

As this is a one-off and only 100 or so transactions this isn't =20
terribly important, but if someone has an import script laying around =20=

which I could use to add transactions then you'd save me some time =20
wasted typing & I'd be grateful.

Stroller.



[1] http://www.sql-ledger.org/cgi-bin/nav.pl?page=3Dmisc/=20
conversions.html&title=3DConversions=

Re: [SL] Non-Profit

[Andi S. <as...@ac...>]

hi,

we do ...
just create an own language and replace customers with donors ....

regards

A.
On Tue, 3 Oct 2006, Tim Maycroft wrote:

> Is anyone using SQL-ledger for a non-profit? I am looking for a Linux
> alternative to my Windowz accounting package. I also need to track donors.
> Can SQL-Ledger help.
>
> Thanks
>
> Tim
> -------------------------------------------------------------------------
> 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] FTP installation

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

Installing via ftp is quite easy but your ISP must play along.

a) you must be able to configure your virtual server to run perl scripts
from the directory where you set up SQL-Ledger
b) plpgsql must be installed in template1 or at least your ISP must
cooperate and install the language handler for your database

Once you've got all this in place upload the compressed file an ungzip. If
you cannot do that ungzip locally and upload the sql-ledger folder.

Then create a .htaccess file in the sql-ledger folder and put this in
the file

DirectoryIndex login.pl
Options +ExecCGI

Use the program as you would on a private server. admin.pl works just the
same. The only difference is that you supply the name of the database
instead of letting the program create one for you. You are most likely not
allowed to create new databases outside of pgadmin or whatever your ISP
uses so you create a new database with pgadmin and enter the name of the
database in the admin screen when you create a new dataset.

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

On Fri, 6 Oct 2006, Fabien Adouani wrote:

> Hi,
>
> I'm trying for more than 2 weeks to install Sql-ledger on my shared
> web server (www.surftown.com). As I don't have the access to the
> server's configuration files,
>
> I'm trying with the FTP installation but without success.
>
>
>
> I'm getting this with admin.pl:
>
>
>
> 500 Internal Server Error
>
> The server encountered an internal error or misconfiguration and was
> unable to complete your request.
>
> Please contact the server administrator, xx...@xx... 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/1.3.37 Server at xxx.com Port 80
>
>
>
> My questions are:
>
>
>
> If it's possible for me to run SQL-ledger on surftown Linux advance package?
>
> What should I do more to be able to run a smooth installation?
>
>
>
> Linux Advance package:
>
> PHP4
>
> Sun ASP
>
> MySQL 4 Databases
>
> phpMyAdmin
>
> PostgrSQL 7.3 Databases
>
> phpPgAdmin
>
> Egne CGI-scripts
>
>
>
> Thank you for your help
>
>
>
>

Re: [SL] FTP installation

[James P. K. I. <jk...@lo...>]

On Fri, 2006-10-06 at 18:27 +0200, Fabien Adouani wrote:
> Hi,
> 
> I'm trying for more than 2 weeks to install Sql-ledger on my shared
> web server (www.surftown.com). As I don't have the access to the
> server's configuration files,

Not having access to the httpd.conf file makes things difficult if not
impossible.

Most hosted accounts have a directory where you can place scripts so
they are automatically treated as executable cgi binaries. This is often
called cgi-bin. 

You may be able to place all of the sql-ledger files in there, set up
the database (only works with Postgresql). You may need to change all of
the files to not point to http://website/sql-ledger but to
http://website/cgi-bin  . 
> 
> I'm trying with the FTP installation but without success.
> 
> 
> 
> I'm getting this with admin.pl:
> 
> 
> 
> 500 Internal Server Error
> 
> The server encountered an internal error or misconfiguration and was
> unable to complete your request.
> 
> Please contact the server administrator, xx...@xx... 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/1.3.37 Server at xxx.com Port 80
> 
> 
> 
> My questions are:
> 
> 
> 
> If it's possible for me to run SQL-ledger on surftown Linux advance package?
> 
> What should I do more to be able to run a smooth installation?
> 
> 
> 
> Linux Advance package:
> 
> PHP4
> 
> Sun ASP
> 
> MySQL 4 Databases
> 
> phpMyAdmin
> 
> PostgrSQL 7.3 Databases
> 
> phpPgAdmin
> 
> Egne CGI-scripts
> 
> 
> 
> Thank you for your help
> 
> 
> 
-- 
James P. Kinney III          
CEO & Director of Engineering 
Local Net Solutions,LLC        
770-493-8244                    
http://www.localnetsolutions.com

GPG ID: 829C6CA7 James P. Kinney III (M.S. Physics)
<jk...@lo...>
Fingerprint = 3C9E 6366 54FC A3FE BA4D 0659 6190 ADC3 829C 6CA7

[SL] FTP installation

[Fabien A. <fab...@gm...>]

Hi,

I'm trying for more than 2 weeks to install Sql-ledger on my shared
web server (www.surftown.com). As I don't have the access to the
server's configuration files,

I'm trying with the FTP installation but without success.



I'm getting this with admin.pl:



500 Internal Server Error

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

Please contact the server administrator, xx...@xx... 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/1.3.37 Server at xxx.com Port 80



My questions are:



If it's possible for me to run SQL-ledger on surftown Linux advance package?

What should I do more to be able to run a smooth installation?



Linux Advance package:

PHP4

Sun ASP

MySQL 4 Databases

phpMyAdmin

PostgrSQL 7.3 Databases

phpPgAdmin

Egne CGI-scripts



Thank you for your help



-- 
Fabien Adouani
Sweden

Re: [SL] Non-Profit

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

Tim
Out of the box, SQL-L is designed for a "company" structure.
You can get it to work perfectly well for other business
types including partnerships, trusts, and solo proprietors. 
But you do need to carefully plan your chart of accounts. 
Same applies to an unincorporated association, which are
commonly used by Not-For-Profit organisations.
For some organisation types (especially partnerships and
some trusts) you must enter you own end-of-year journal to
allocate the retained earnings (or losses) manually. 
The usual SQL-L end of year routine can only accumulate
profits/losses to a single account in the equity section of
your Balance Sheet.
As for your donors, you could easily track them as
customers.  Alternatively, you could track the donors as
separate accounts within your chart of accounts.
Depends upon your needs.
In summary, Yes, SQL-L can be used very successfully with
NFP's.
Hope this helps.
- David J 

> Is anyone using SQL-ledger for a non-profit? I am looking
> for a Linux alternative to my Windowz accounting package.
> I also need to track donors. Can SQL-Ledger help.
> 
> Thanks
> 
> Tim
> ----------------------------------------------------------