Thursday, October 14, 2004

Totally - Accounting #2 (and a change of style)

More on Totally. Its coming along in leaps and bounds. I decided to write my own accounting module. My Mum and I (she's a bookkeeper) sat down one day and spent six solid hours examining exactly what is an accounting system. Once you get a handle on it, its really quite simple, even double entry accounting.

So now, with the help of the design of Totally's database, I've now created a stored procedure that builds a relationship tree for every "thing" in there. For accounting, that's great, because the stored procedure can generate something like this:

[Chart of Accounts]
-----> Assets
     -----> Current Assets
          -----> General Cheque Account
          -----> Petty Cash
          -----> Trade Debtors

etc - all without creating a specific procedure just to build this tree - the generic stored procedure builds it all for me. FIGJAM.

Totally is so close to release, and there's been a lot of interest in it so far by current customers and others.

I think its going to do quite well. ;-)


You may have also noticed that I changed the style of my blog. This one looks great.