I have uploaded to GitHub EL CONTADOR which means accountant in English.
I has only 5 models with no realtions yet. During the rest of this week
I will be adding some functionality. Please feel free to suggest and
change the app. https://github.com/quiliro/el_contador
The idea is that it is supposed to be ideal for small and home based
bussinesses. It will have:
* Inventory
* Invoices
* Sales reports
* Most sold products
* Tax reports
* Contacts (where customers and suppliers are stored)
* Purchases
* Items (where the bought and sold products are stored)
* Combos (where combined products or products and services are stored)
* Sales and purchases can be made with credit
* Sales can be summed up to calculate future discounts
* MySQL database
* Certain reports can be printed on pre-printed forms
Right now I am deciding about making the list of accounts in one table
or making it on five tables each one containing the previous level of
accounts. This is the idea:
Zero_Account
name:string
has_many :one_accounts
One_Account
name:string
transactional:boolean
has_many :two_accounts
belongs_to :zero_account
Two_Account
name:string
transactional:boolean
has_many :three_accounts
belongs_to :one_account
Three_Account
name:string
transactional:boolean
has_many :four_accounts
belongs_to :two_account
Four_Account
name:string
transactional:boolean
belongs_to :three_account
This structure would allow to sum up all transactional accounts that
belong to an upper level account table and have a total available to
report on several different levels. For example, Financial Investments
(three_account) 1080101 is a record that belongs_to Other Long Term
Investments (two_account) 10801 which in turn belongs_to Long Term
Assets (one_accout) 108 which in turn belongs_to Assets (zero_account)
1. If I would like to know the balance to a certain date of two_account
10801, I would have to sum up all transactions of all transactional
sub-accounts (three_account or lower) from the start of the period
(year) to that certain date. That way I can have a balance of each
account on any date.
Your contributions in code or suggestions will be greatly apreciated.
--
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.
