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: [email protected] 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
