|
|
Subscribe / Log in / New account

Trying Tryton

Ready to give LWN a try?

With a subscription to LWN, you can stay current with what is happening in the Linux and free-software community and take advantage of subscriber-only site features. We are pleased to offer you a free trial subscription, no credit card required, so that you can see for yourself. Please, join us!

By Jonathan Corbet
December 5, 2017
Free accounting systems
The quest to find a free-software replacement for the QuickBooks accounting tool continues. In this episode, your editor does his best to put Tryton through its paces. Running Tryton proved to be a trying experience, though; this would not appear to be the accounting tool we are searching for.

Tryton is a Python 3 application distributed under the GPLv3 license. Its home page mentions that it is based on PostgreSQL, but there is support for MySQL and SQLite as well. Tryton, it is said, is "a three-tier high-level general purpose application platform" that is "the core base of a complete business solution providing modularity, scalability and security". The "core base" part of that claim is relevant: Tryton may well be a solid base for the creation of a small-business accounting system, but it is not, out of the box, such a system itself.

Running Tryton

The Tryton documentation is not especially friendly to the first-time user. The installation instructions suggest going with what one's distribution provides. One can see why; following the links for a source installation leads to a lengthy directory listing with dozens of independent tarballs. There is a Mercurial repository out there, but one has to search for it and there is no documentation on how to build or install from a copy of the repository.

Your editor opted for the Fedora Tryton packages — of which there are 54 to choose from. Tryton is broken up into a lot of modules, so there is naturally a package for each. Nobody has documented this, but getting the Fedora packages running requires creating a PostgreSQL database and user, editing the trytond.conf configuration file to point there, adding the tryton group to ones account, and running the trytond-admin application to initialize the database. Once that is done, the tryton application will consent to run and put up a simple window.

In the process of figuring this out, it became clear that the Tryton developers have not put a huge amount of effort into error handling. The usual response when something goes wrong is a Python traceback, which tends to not be particularly helpful.

Getting the tryton application to use one's local database requires messing around with "profiles", even though the configuration file specifying the database setup was passed on the application's command line. Things have to be just right or access simply fails to work. Once that obstacle was passed, the result was a general interface describing "records" of various types. The accounting module was installed and provided its own record types. A basic chart of accounts was set up. But [Tryton] there was nothing resembling an interface to do even basic things like creating a bank account or entering a transaction. Your editor tried installing more modules (all of them, actually) to get more functionality, but the result was an application that wouldn't run at all — it died with a traceback due to apparently missing Tryton module dependencies. Some of the Fedora module packages simply don't work, in other words.

As it happens, the version of Tryton packaged with Fedora 27 is 4.0, which is somewhat behind the current release (4.6). It seems reasonable to believe that a more recent release might yield better results. The openSUSE Tumbleweed distribution packages 4.2 instead, but it never proved possible to get past the profile screen with those packages installed. One might plausibly claim that support for Tryton is not the highest-priority objective for some distributors, at least.

It is also alleged to be possible to install Tryton directly from the Python Package Index using pip. Your newly hopeful editor duly created a virtualenv and populated it with a set of packages, but the 4.6 tryton application would not even start. It is, it would seem, still tied to the GTK+ 2 toolkit, which is not all that well supported on current distributions, especially for a Python 3 application.

Moving on

There is little doubt that somebody with greater skills and patience could find a way to make a current Tryton release work on a current Linux distribution. The result would likely be gratifying in a number of ways; Tryton appears to have a well-designed and well-documented base that one could build a good accounting application on top of. Integration with a business's other processes (one of the key criteria in this search) would seem to be relatively straightforward. But even an easily installed, perfectly working Tryton would fall far short of what is needed here.

The point is this: it's a rare small-business owner who feels the urge to build an accounting system on top of anything. Accounting is a task that needs to be done, not an objective in its own right. Any accounting system that arrives as a box of small parts with "some assembly required" written on the outside does not meet the needs of this kind of user. For all its faults, Intuit understood that when it created QuickBooks. The developers behind the other systems reviewed so far (GnuCash and Odoo) also understand that.

Chances are, the Tryton developers understand that too, but creating an easily usable small-business accounting system would appear not to be at the top of their to-do list. There are a number of free-software business-management systems available. Many of these, your editor has long believed, are developed primarily as platforms for consultants. A system that is highly capable, but which is complex, minimally documented, and in need of a lot of setup work suits that business model well.

Such a system is also, of course, simply easier to implement and maintain. Creating an interactive accounting system that is usable by people with no inherent interest in accounting systems is a difficult task. It is, seemingly, not an itch that many developers feel the need to scratch without some sort of additional incentive. Nobody has the right to criticize developers for this, but the result is predictable: like many types of free software, free accounting systems tend to lack the user-level work needed to make them truly competitive with proprietary alternatives.

Still, it is not yet time to give up on this search; the list of candidate systems is not yet empty. Stay tuned as the quest to find a free accounting system that can displace the proprietary alternatives continues.


to post comments

Trying Tryton

Posted Dec 6, 2017 9:26 UTC (Wed) by shiftee (subscriber, #110711) [Link] (6 responses)

I came across Tryton when reading about GNU Health (http://health.gnu.org).
I installed the Ubuntu packages and accessed the GNU Health demo database.
If I remember correctly the Ubuntu 16.04 version was too old to access the database but the version in 17.04 worked nicely

Trying Tryton

Posted Dec 7, 2017 4:09 UTC (Thu) by jbicha (subscriber, #75043) [Link] (5 responses)

I imagine Tryton would work better in Debian or Ubuntu. Too bad the author ran out of time or interest to try it there.

Trying Tryton

Posted Dec 7, 2017 15:32 UTC (Thu) by corbet (editor, #1) [Link] (2 responses)

I can fully believe it might work better on a different platform. I didn't have a Debian box handy to try it on, but it doesn't matter: I'd seen enough to understand that Tryton, for all its virtues, was not intended for the use case at hand.

Trying Tryton

Posted Dec 7, 2017 21:45 UTC (Thu) by debacle (subscriber, #7114) [Link] (1 responses)

Thanks for continuing your series about free software business accounting!

Without knowing much about Tryton, I have the feeling, that the review does it a little bit of injustice. There is a use case, i.e. "SMB accounting", but it is clear from the beginning, that both Tryton and Odoo are business application platforms, not applications. If I understand correctly, such systems are always a kind of workbench. That is the whole business case for thousands SAP and Oracle consulting companies. I'm clearly not an expert on those things, but I would try GnuCash (what you did), LedgerSMB, and PostBooks. At least from their short description they look more like applications, not platforms, to me.

Anyway, an interesting read!

PS: It seems, that Debian unstable has relatively recent version of all mentioned programs, but Odoo.

Trying Tryton

Posted Dec 7, 2017 21:48 UTC (Thu) by corbet (editor, #1) [Link]

Indeed, I tried to carefully express that Tryton isn't "bad", it's just not aimed at this use case.

Odoo, FWIW, is more oriented toward the small-business accounting use case. It has a lot of features missing for commercial reasons, but a real effort has been made to have it work out of the box and be reasonably easy to work with.

Trying Tryton

Posted Dec 14, 2017 16:10 UTC (Thu) by saxa (guest, #30413) [Link] (1 responses)

>> I imagine Tryton would work better in Debian or Ubuntu. Too bad the author ran out of time or interest to try it there.

I think that LWN is looking for something working right out of the box, at least minimally. Now I would assume as they wrote that no user would try to install another distro just to have a software working better. It is not very well thought if you think it that way.

Trying Tryton

Posted Dec 14, 2017 16:13 UTC (Thu) by corbet (editor, #1) [Link]

Installation isn't an issue; I don't think that software should be judged based on whether there's a convenient package available for a specific distribution. The real problem is that, even working perfectly out of the box, Tryton isn't aimed at the use case in question.

old version in Fedora

Posted Dec 8, 2017 9:54 UTC (Fri) by rathann (subscriber, #50815) [Link] (1 responses)

Thanks for the article and sorry you had bad experience with the Fedora package. Would you mind filing a bug at https://bugzilla.redhat.com/enter_bug.cgi?product=Fedora&... describing your issues and requesting an update?

old version in Fedora

Posted Dec 13, 2017 21:37 UTC (Wed) by sharkcz (guest, #52232) [Link]

I would more than welcome a helping hand in maintaining the Tryton packages in Fedora, but none has appeared yet ...

Trying Tryton

Posted Dec 8, 2017 12:13 UTC (Fri) by pilou (subscriber, #120137) [Link]

About Python 3 compatibility: Note there is a Web interface available since Tryton 3.8.

Tryton is primarily a framework. For example, an insurance ERP is based on Tryton. GNU Health, a free Health and Hospital Information System, is based on Tryton too. If there is an accounting module for your country, it can be used as an accounting software. There are (upstream) accounting available modules for Belgium, French, German and Spanish.

The following modules are sufficient for a french IT freelance: account, account_fr, account_invoice, account_statement, company, country, currency, party, party_siret, product.

Annual community event is taking place now.

Trying Tryton

Posted Dec 14, 2017 10:08 UTC (Thu) by SISalp (guest, #120222) [Link]

Thank you for this review of Tryton.

In Tryton community, we are aware of the difficulty to start with Tryton.

The first attempt to make it easy was a single-user application (client+server+sqlite) embedded as an office software called NESO. NESO support was dropped because of lack of interest and difficulty to maintain up-to-date packages. I think it would have fit well for your test.

An alternative solution has been to provide free hosting, so no installation is required at all (http://sisalp.com, I'm the operator of this site). It comes with an installation and management web page. Advantage is that hosting provides also basic security and backup. It allows you to test Tryton and use it for some time (not limited), enough to decide if it is worth installing it on your own server and bring back your data.

Recently a docker image has been made available at the central repository. Nevertheless, it requires also server admin skills for first installation and minimal maintenance.

Some contributors proposed tutorials about basic installation but for specific kinds of installation (usually not production) and we still consider this as an on-going task among other topics to improve the user documentation and translate in different languages. All contributors are welcome.

Thank you again for this review of Tryton which lacks the notoriety it deserves.

Trying Tryton

Posted Dec 14, 2017 21:30 UTC (Thu) by cedric.krier (guest, #120255) [Link]

Thanks for reviewing Tryton. I'm one of the main developers of Tryton.
We are sorry to hear that Tryton is not a solution that suits your needs. We are well aware that Tryton is not yet a turn-key solution but more a platform to build business application for now. But we would like to improve it to be more ready to use. For this purpose, we would be happy to get more review on the missing features and/or misbehavior in this context. Our forum is open to anyone who want to discuss about them: https://discuss.tryton.org/


Copyright © 2017, Eklektix, Inc.
This article may be redistributed under the terms of the Creative Commons CC BY-SA 4.0 license
Comments and public postings are copyrighted by their creators.
Linux is a registered trademark of Linus Torvalds