Developing Accounting softwares

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

raghav03

Thread Starter
Joined
Dec 23, 2010
Messages
1
I am a CA having basic knowledge of computing, i want to develop accounting softwares please let me know which programming langauges and other things i need to learn in oorder to develop accounting softwares of my own.
 
Joined
Oct 30, 2008
Messages
276
Welcome to the forums,

This is a neat project. While I understand your enthusiasm, your question is rather difficult and there are many things to consider. Some languages and technologies are better at some things than others are. They can be, and often are, combined for the best results.

Let me give you an anecdote. I wrote a little program to manage our private bank accounts. Since these are cash accounts, I didn't have to play with debits and credits much. In a database, I simply set a Boolean with the transaction to show if it was a deposit or withdraw, along with a unique ID, the date, and the amount. I can then sum the debits, and subtract the credits to get the balance on any account, and it works just fine. However, as the number of transactions grows, this process will begin to take a terribly long time as it must hit every record to perform the calculations.(This could be fixed with a periodic reconciliation.)

This process might work if I had an AS/400(very fast when reading large numbers of records) for the database, queried with SQL (because I hate RPG, the AS/400 language), and used, perhaps Java (to make it light-weight and multi-platform) for the interface, but I used VB and Access. This is a failure, despite it working now.

What I would do is think hard about how it will be used, then try to break it down into its major functions (database manipulation, form application abilities, rapid application development, web functionality, etc.), and the technical requirements of those functions. Once you can isolate the major functions, you can then look for the best way to achieve them. (There are other approaches.)

If it's just a small program to test your knowledge, VB (C# is on the rise a favorite for this in .Net) and Access will get it done, but to address a commercial application, a book on business systems development (i.e. Shelly-Cashmen: System Analysis and Design) might be just as useful as a book on a programming language. However, Shelly-Cashmen also writes programming language specific books that are fairly easy to self-teach from, although not always great at explaining deeper concepts.

I hope that helps set you on your way,

GL,
 

karlhaywood

Account Closed
Joined
Jan 17, 2010
Messages
680
DaBeers Sorry to but in but, why was it a failure in VB and Access? I use .Net with MySQL Quite alot but i also love playing with Access!
 
Joined
Jun 10, 2010
Messages
277
DaBeers Sorry to but in but, why was it a failure in VB and Access? I use .Net with MySQL Quite alot but i also love playing with Access!
I'm interested to know as well, I've used VB alongside databases for the past 3 years and have found it to be the most effective way of handling databases due to its simplicity as a language and effectiveness handling object oriented programming..

Doctorzeus
 
Joined
Oct 30, 2008
Messages
276
Sorry my first post came off as vague. It was not my intention.
The truth is; I also use VB and Access to a large degree of success. It's just that it's not always the best option.
In my example, the time required to read every record in the database in order to generate a calculated field would increase until the program became unusable. However, the same process would perform longer, better, on an AS/400. This is anecdotal and he may never run into 'that' problem if he can block the data well.
However, there are still issues with Access, like the lack of permission handling and the fact it is not case sensitive, that are not so easy to work around. My point was that he should try to sort these facts out before he begins such a potentially large project.

Hope this helps clarify.
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 807,865 other people just like you!

Latest posts

Members online

Top