LinuxQuestions.org
Review your favorite Linux distribution.
Home Forums Tutorials Articles Register
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.

Notices


Reply
  Search this Thread
Old 05-04-2009, 02:39 PM   #1
autophil
Member
 
Registered: Jun 2006
Location: Macclesfield Canal, East Cheshire
Distribution: Salix-14.1
Posts: 129
Blog Entries: 1

Rep: Reputation: 15
Invoicing without LAMP


Since I started using Linux I have looked for an invoicing program so that I can close down QuickBooks on my XP machine.
Im still looking.
I know this is a well worn subject. But ......

I cant see that Gnucash or Moneydance can be capable of business invoicing. At least not for me. Thats like trying to use Quicken.
I have come to terms with the fact that Web based invoicing may be the way to go.
But why do they have to be all PHP and SQL dependant? Isn't there some applications that do plain straight-forward stand-alone invoicing.
Especially if your business is quite small, a spreadsheet kind of data-base should be all that is needed to store your information.

Every time I have tried to install a LAMP system I get bogged down with trying to make them all talk to each other and end up with nothing working.

So I suppose my question is:
Are there Invoicing (creating and tracking) applications for Linux/Gnu systems that are simple to install and administer even if they are "web based"?
Have you found something like that? I would like to follow it up!
phil
 
Old 05-04-2009, 03:44 PM   #2
farslayer
LQ Guru
 
Registered: Oct 2005
Location: Northeast Ohio
Distribution: linuxdebian
Posts: 7,249
Blog Entries: 5

Rep: Reputation: 191Reputation: 191
Might want to Search the forums for some answers to this question. I did a search for ERP..
Most Financial systems are SQL based.. whether you are talking about Oracle financials, Peoplesoft, Microsoft Dynamics AX, SAP..
If you are not looking to track any history or do any actual accounting, and just want a fancy looking invoice then an Excel template is readily downloaded from the net that can be used in Open Office Calc.

http://www.linuxquestions.org/questi...?highlight=ERP

http://www.linuxquestions.org/questi...?highlight=ERP

http://www.linuxquestions.org/questi...?highlight=ERP

http://www.linuxquestions.org/questi...?highlight=ERP

http://www.linuxquestions.org/questi...?highlight=ERP

http://www.linuxquestions.org/questi...?highlight=ERP


Best of luck, please stop back and let us know what you used to solve your issue.
 
Old 05-04-2009, 06:15 PM   #3
mikepeters76
Member
 
Registered: Apr 2009
Location: Sydney, Australia
Distribution: Ubuntus, Fedora, openSUSE, and Vector Lite 6.0
Posts: 46

Rep: Reputation: 16
SQL ledger is surprisingly easy to install, I am in the process of finalising an install on a test box and will be using it for my business. I am migrating from OpenOffice spreadsheets to something more "professional".
My test box is an ancient RH9 box and production is Ubuntu, let me know if you are interested in giving SQL Ledger a try - happy to help out.
 
Old 05-05-2009, 12:34 AM   #4
autophil
Member
 
Registered: Jun 2006
Location: Macclesfield Canal, East Cheshire
Distribution: Salix-14.1
Posts: 129

Original Poster
Blog Entries: 1

Rep: Reputation: 15
Thanks for your replies.
I have searched hi and lo on forums software sites and search engines. Invoicing needs to be trackable unless you are lucky enough to only have to make out one or two a month. Then its trackable mentally.
Hey mikepeters76 I looked at your blog and I will try to follow it with another go at SQL-Ledger. I tried it once before and although the installation went fine it would not start. When I asked a question on the S-L forum the answer was "Read the documentation".
My apprehension has been that invoicing needs to be 100% accurate and reliable. so if something crashes nothing is lost and everything is recoverable. Fast! Customers dont like unreliable statements.
So, right, with SQL-Ledger we're talking LAMP thats 4 elements ok 3 if you consider Linux is already there.
I am using Slackware12.2. If you yourself are installing on RH from source you should think about giving Slackware a go. Its stable and basic without being rustic.
I'll give SQL-L another go!
phil

Last edited by autophil; 05-05-2009 at 12:35 AM. Reason: thoughts
 
Old 05-06-2009, 05:34 PM   #5
mikepeters76
Member
 
Registered: Apr 2009
Location: Sydney, Australia
Distribution: Ubuntus, Fedora, openSUSE, and Vector Lite 6.0
Posts: 46

Rep: Reputation: 16
Phil, let me know how you go, my ubuntu install is running perfectly, emailing out invoices (I am just tweaking the PDF at the moment). My first trial balance was excellent as was my income statement and balance sheet. The invoices are very trackable and as with most software will take care of the numbering for you, if you use postgre it is easy to administer via pgadmin3. I will post all the commands used for the install on my site today.
Mike
 
Old 05-24-2009, 06:18 AM   #6
autophil
Member
 
Registered: Jun 2006
Location: Macclesfield Canal, East Cheshire
Distribution: Salix-14.1
Posts: 129

Original Poster
Blog Entries: 1

Rep: Reputation: 15
Sql-ledger 'seems' to install ok, but I havnt managed to start it yet.
Postgresql also 'seems' to install ok, but I cannot create a new user.
$ su
password: ****
# su postgre
password: ****
$ createuser sql-ledger
unknown command
 
Old 05-27-2009, 11:55 PM   #7
mikepeters76
Member
 
Registered: Apr 2009
Location: Sydney, Australia
Distribution: Ubuntus, Fedora, openSUSE, and Vector Lite 6.0
Posts: 46

Rep: Reputation: 16
sorry for the long absence. You will need to follow the installation insturctions to the letter.

If postgres installed ok without any errors etc then the createuser command should be in
Quote:
michael@michael-laptop:~$ whereis createuser
createuser: /usr/bin/createuser /usr/share/man/man1/createuser.1.gz
Then I would probably check who has ownership of createuser etc and make sure that postgre can execute the file or for that matter whomever you are going to sudo.
Quote:
ls -la /usr/bin/createuser
lrwxrwxrwx 1 root root 37 2009-05-06 08:23 /usr/bin/createuser -> ../share/postgresql-common/pg_wrapper
As you can see on my system it is root, anyway you do "su postgre" rather than "su postgres"?? Is that correct. I would try the commands exactly as they are quoted in the installation document:
Quote:
# su postgres
$ createuser -d sql-ledger

Last edited by mikepeters76; 05-27-2009 at 11:58 PM.
 
Old 05-28-2009, 08:55 PM   #8
jlinkels
LQ Guru
 
Registered: Oct 2003
Location: Bonaire, Leeuwarden
Distribution: Debian /Jessie/Stretch/Sid, Linux Mint DE
Posts: 5,195

Rep: Reputation: 1043Reputation: 1043Reputation: 1043Reputation: 1043Reputation: 1043Reputation: 1043Reputation: 1043Reputation: 1043
http://en.wikipedia.org/wiki/Compari...nting_software

jlinkels
 
Old 05-29-2009, 02:09 AM   #9
autophil
Member
 
Registered: Jun 2006
Location: Macclesfield Canal, East Cheshire
Distribution: Salix-14.1
Posts: 129

Original Poster
Blog Entries: 1

Rep: Reputation: 15
The main difference is that my createuser is in
/usr/local/pgsql/bin/createuser

Quote:
# whereis createuser
createuser:
Quote:
#locate createuser
/usr/local/pgsql/doc/html/sql-createuser.html
/usr/local/pgsql/doc/html/app-createuser.html
/usr/local/pgsql/bin/createuser
/usr/local/pgsql/man/man1/createuser.1
/usr/local/postgresql-7.4.23/src/bin/scripts/createuser.c
/usr/local/postgresql-7.4.23/src/bin/scripts/createuser.o
/usr/local/postgresql-7.4.23/src/bin/scripts/createuser
/usr/local/postgresql-7.4.23/doc/src/sgml/ref/createuser.sgml
/usr/local/postgresql-7.4.23/doc/man1/createuser.1
Should I just leave it like that or move createuser to the correct place?

Last edited by autophil; 05-29-2009 at 02:11 AM.
 
Old 05-29-2009, 03:19 PM   #10
peonuser
Member
 
Registered: Mar 2008
Location: Where ever I am.
Distribution: Various
Posts: 177
Blog Entries: 172

Rep: Reputation: 21
I have been using smbledger. www.howtoforge.com has come excellant tutorials. I also used nola accounting, but it had a few issues including having horrible install notes. I have it working but it was not secure enough for what I wanted to do. the register globals thing. I did install sql-ledger several years back, but since wiped it.
 
  


Reply

Tags
erp



Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
LXer: Creating an invoicing system with OpenOffice.org LXer Syndicated Linux News 0 04-27-2009 08:10 PM
Need a basic accounting / invoicing software to replace Windows/Quicken/Quickbooks. brjoon1021 Linux - Software 8 10-15-2008 03:53 PM
LXer: LAMP vs. LAMP Rematch LXer Syndicated Linux News 0 11-08-2006 03:03 AM
LAMP distributed invoicing and inventory system. salee02 Programming 1 11-01-2006 01:03 PM
LXer: Web app takes the pain out of invoicing LXer Syndicated Linux News 0 10-02-2006 03:21 PM

LinuxQuestions.org > Forums > Linux Forums > Linux - Software

All times are GMT -5. The time now is 09:35 AM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Open Source Consulting | Domain Registration