------------------------------------------------------------------------
*From:* Quiliro Ordóñez <[email protected]>
*To:* [email protected]
*Sent:* Thursday, August 4, 2011 9:50 AM
*Subject:* [Hobo Users] accounting application
Hello people.
I feel great about Hobo and this group. I am very enthusiastic about
participating and using Hobo.
I have decided to make my first free (as in freedom) Hobo commercial
application or contribute to an existing one. I have looked at the
small business sector and found that in my country (Ecuador) many
companies will be mandated to change their accounting to IFRS
<https://secure.wikimedia.org/wikipedia/en/wiki/File:Gnucash_2_screenshot.png>
for year 2012. This could be a great opportunity to install this kind
of software and of making Hobo have a lot of advocacy.
I am looking for such kind of software developed in Hobo and with a
FSF approved free software license. Does anyone know of such a project?
If there is none, I will start the app beginning with the account
tree. How can I have an an account tree such as the one in this
screenshot of GNUCash
<https://secure.wikimedia.org/wikipedia/en/wiki/File:Gnucash_2_screenshot.png>?
It would be interesting to have such a structure in a web based app. I
would not like to use Flash because of several of its non free
implications and its low quality when reproduced with free software.
On 04/08/11 12:46, Arthur Baldwin wrote:
I would be interested in assisting you in that regard because I'm
currently trying to develop such a solution for the company where I
work as well as for my own company at home. I'm not sure how quickly
it can be accomplished, since I'm just a beginner at Hobo. But I do
have experience in developing many small business management apps in
MS Access. So I have an idea how the database structures should be
put together.
Would you please suggest the initial database structure? I was thinking
of having a table for the account tree with a database attribute for
each level. The structure would be as such:
class Account < ActiveRecord::Base
hobo_model # Don't put anything above this
fields do
name :string
level0 :integer
level1 :integer
level2 :integer
level3 :integer
level4 :integer
level5 :integer
timestamps
end
Such that an acount numbered 1 01 02 01 05 03 would have the following data:
name whatever
level0 1
level1 1
level2 2
level3 1
level4 5
level5 3
This account would register transactions and would be part of account 1
01 02 01 05 mhich would not register transactions and would have the
following data:
name another name
level0 1
level1 1
level2 2
level3 1
level4 5
level5 0
And for the actual actual residue of that account, we would add all of
the records that have the following data:
level0 1
level1 1
level2 2
level3 1
level4 5
level5 anything
It is necessary to have a structure where all records can be listed in a
tree structure. It is also necessary to be able to enter one othe record
and have a list of the records that are under that record several levels
below (likewise in a tree structure).
I am thinking of a structure that will need one field for the number of
the account. The examples above would be:
For 1 01 02 01 05 03
name whatever
id 10102010503
For 1 01 02 01 05
name another name
id 10102010500
The idea is to have the residue of each account for any date based on
the transactions (another table) made. And for the non transactional
accounts we would sum up the lower level accounts for that account for a
given date.
What are your opinions on these ideas?
--
You received this message because you are subscribed to the Google Groups "Hobo
Users" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/hobousers?hl=en.
