Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
adhbrown
Starting Member
1 Post |
 Posted - 2010-10-14 : 12:53:46
|
| Hello,I am very new to the world of programming and sql. I'm working on a project in which I need to develop a set of financial databases in which a company could keep track of customer orders, accounts payable, receivables, cash management, invoices and so on. I know oracle has oracle financials/e-business suite but I don't have $50,000 nor do I need it in such depth. Is there any open source software I could use instead or something cheaper?Thanks, |
|
|
Sachin.Nand
2937 Posts |
Posted - 2010-10-14 : 12:58:28
|
Maybe I can help you design it if you are ready to pay me... Mods please dont delete the post.Its not a Spam....PBUH |
 |
|
|
fdtoo
Starting Member
28 Posts |
Posted - 2010-12-29 : 21:25:23
|
Hi adhbrown, Are you doing this for your company or your college assignment? Ifyou are heading this for your company, i suggest you stick to sql server or oracle as your DBMS, as their are well established industry players in this area.If i'm in charge of this project, i would adopt vb.net (front-end) with sql server (back-end) as both are supported by the same proprietor (Microsoft). And yes, you need some basic accounting knowledge to drive your database design.As a start, try out sql express, since you preferred free of charge DBMS, and start building up your database (you need to employ normalization, entity-relationship, data diagram concept here) and gradually remodel and redefine your database model as you move into production. Once you have created a well structured database, you will then move into developing your GUI (front-end). I leave this up to your choice of preference (e.g. java,vb.net). At this stage, you will begin to embedd control and constraint for your business logic on your form.If you are serious in taking this project successfully, you would really need to master your sql scripting skill and grasp some understanding on GAAP ruling. Robert Vieira has written quite a number of good books on sql programming and he is proficient in financial accounting. To give you a clear path as to how and where you should carry this project in the right direction, try downloading this book from accountingdes, as it touches on accounting database designing which i think will give you a clearer understanding on this particular subject.Best of Luck |
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2010-12-30 : 01:51:09
|
i just google and found this http://www.gnucash.org/
KH[spoiler]Time is always against us[/spoiler] |
|
|
|
|
|
|
|
|
Accounting Solutions/Databases for SQL