Creating a General Ledger in Base

users
#1

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.).

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

John

#2

Hi John,

I have looked all over the world, using google, but I have not
found any sample general ledger examples using LO Base.

I have created many examples for Base - but I dont know much about a
general ledger. Could be you could use something of the described
databases from here:

http://robert.familiegrosskopf.de/lo_hb/BeispielDBs_mit_Beschreibung_V51.zip

But notice: All this descriptions and databases are in German. This
description isn't translated to English like the first German Base
Handbook.

You could find other examples directly here:
http://robert.familiegrosskopf.de
but there isn't any example that might have any content you are
looking for.

Regards

Robert

#3

While I do not have and example, I suggest that you look around on the internet for what is already Ledger designed against what LO Base can connect to.

For instance, you could download mysqlledger from https://github.com/johnathanmartin/mysqlledger

Connect it to LibreOffice Base http://www.techrepublic.com/blog/diy-it-guy/diy-connect-libreoffice-base-to-a-mysql-database/

And then start working on the front end the way you want it to look.

On the other hand, there are free open source accounting packages that almost always start with general ledger. Like multi-platform "GnuCash".

GnuCash by default stores data in an xml format. Starting with version 2.4, GnuCash financial data can be stored in a SQL database using SQLite3, MySQL or PostgreSQL.

Make the parts from the accounting package you think are missing in Base. Then back-in to the program to build entirely around a Base front-end.

Base and FireBird are coming along if your going to build from scratch. https://wiki.documentfoundation.org/Development/Base/FirebirdSQL

Hope this helps.

#4

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? :slight_smile:

If you use the embedded hsqldb, you may find some of the "knocks" too
hard to stomach :wink:

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