[libreoffice-users] Re: Creating a General Ledger in Base

Le 03/11/2016 à 19:53, John R. Sowden a écrit :


Hi John,

> I have looked all over the world, using google, but I have not found any
> sample general ledger examples using LO Base.  The funny part is the
> sample field structures are designed for this use, and others are
> closely related (depreciation, etc.).

YEs, these sample table definitions are completely underused - one would
have thought that at some stage over the years someone would have come
up with a sample ODB file that uses them to good effect.

Be that as it may, the current use of the embedded version of hsqldb
supplied with LibreOffice by default is probably not the best way to a
"secure general ledger future". Most people on this list that have ever
used Base would advise you (myself included) to look elsewhere. There
are, for example, many web-based ledger systems that one could install
locally on one's computer, and use quite happily, and possibly more
flexibly and safely, than relying on an embedded hsqldb database in an
ODB file. Some even integrate the production and workflow management of
ODF documents for reports, invoices, etc. This is not a holy grail
recommendation of course, but I personally would never choose embedded
hsqldb in ODB as my solution for that kind of task. There are definitely
other (better) options out there. GnuCash and KMyMoney or Skrooge go
some, if not most of the way there, depending on your requirements, but
if you want cross-platform, then it'll probably be web-based.



> Can anyone send me in the right direction, or must I enroll in the
> school of hard knocks?  :)


If you use the embedded hsqldb, you may find some of the "knocks" too
hard to stomach ;-)

Contrary to Paul's advice, I wouldn't go down the embedded Firebird
route just yet - it is still experimental, lacks correct cross-platform
support and is no way near fully functional.



Alex


-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted