| Author |
Topic |
|
Da_Retina
Posting Yak Master
109 Posts |
 Posted - 2001-12-11 : 01:58:25
|
| Hi to all..Does anyone know about some useful resources of programming Accounting and General Ledger applications..SQL scripts,books..etc.Thanks to all.. |
|
|
byrmol
Shed Building SQL Farmer
1591 Posts |
Posted - 2001-12-11 : 02:19:57
|
| Da_Retina,You don't know how sorry I feel for you...I recently spent 4 hours with a client telling him not to re-invent the wheel. Basically it went something like this.Client: We need full accounting in our DBDBA: Could you please define "full"Client: You know, an accounting app with invoices, taxes, depreciation, ledger etc...DBA: So you want us to write <Insert accounting package>. That will take 10 to the power of Pi hours to implement.Client: Really?DBA: Really!In the end they decided just to keep basic sales data and export to (get ready for this) their existing accounting package! Project delivered on time and budget and the client was so glad that we went that way.Accounting apps have been done to death by the major players. It is far easier to suck a minimum data set out of SQL and let the "proper" accounting apps deal with it.I know this doesn't help you but I can see a very grey haired DBA coming on.. Scope creep in an accounting app will absolutely butcher your project.DavidMA database is a set of axioms, the response to a query is a theorem, the process of deriving the theorem from the axioms is a proof, a proof is made by manipulating symbols according to agreed mathematical rules. |
 |
|
|
Nazim
A custom title
1408 Posts |
Posted - 2001-12-11 : 02:25:53
|
| i personally have been involved in developing a full fledge Accounting system, what kinda information or help do u need. if u can clearly state it , might b help can pour in .yeah as David says it takes a lot of time, for the project i was involved it took over 1 year.Best of Luck-------------------------"Success is when Preparedness meets Opportunity"Edited by - Nazim on 12/11/2001 02:27:13 |
|
|
|
byrmol
Shed Building SQL Farmer
1591 Posts |
Posted - 2001-12-11 : 02:30:21
|
| My deepest sympathies Nazim!DavidMA database is a set of axioms, the response to a query is a theorem, the process of deriving the theorem from the axioms is a proof, a proof is made by manipulating symbols according to agreed mathematical rules. |
|
|
|
Nazim
A custom title
1408 Posts |
Posted - 2001-12-11 : 05:28:56
|
| i bet , its one of those things which keeps on getting complex and complex as u try solving it. once i had complete something ,another comes up. to tell u something , now also the client keeps on calling and bugging me. but i have learnt a lot from it. my advice to any1 who r making accounting software . 1) Have ur specifications well defined and documented , Never start with ill defined specs.2) Design ur Database with a lot of care , think about the most weird reports the management can ask(and i bet they will definetly ask )3) Diving the System into N/L,Accounts Payable, Recievable, Inventory 4) Make them very cohesive( therez something called cohesion and coupling try following it)5) Make Good Provisions for Ageing And Audit Reports. ( they always asks for this, follow standart software engineering techinques it will help a lot)6) Document every aspect of ur Application development7) For Reports have a 2 Seperate table like( rpt_header and rpt_Details) and have user defined reports that will reduce a lot of your headache(once the project is thru....ofcourse if it is:))8) DONT Give an early delivery date to the Client.(he will kill u for the delay it will cause)9) ALWAYS BE READY FOR CHANGE OF SPECS10) Have a Very good DBA and Development team .oops! i can go on and on.i think all the xperts will add more on it:).but Da_Retina its worth a short , u will learn a lot from it. we are always there to help u. Long Live SqlTeamif u dont get it from here then follow this "IF you Dont get help from outside ,Get it from within"hey! David what was ur most horrofying experience in developmentBest of Luck Retina!!!.-------------------------"Success is when Preparedness meets Opportunity"Edited by - Nazim on 12/11/2001 05:31:00 |
|
|
|
Da_Retina
Posting Yak Master
109 Posts |
Posted - 2001-12-11 : 07:21:11
|
| wellllllll...wow!!!!byrmol..wish I could offer U a cup of coffee!..lolThanks to U all..I really know what U mean!..We are developing a FULL G/L and Accounting package for a company.We are in the final stages. Basic reports are done but I need to look at some ideas in scripts implementing aging,trail balances..etc.. reports!THANKS TO U NAZIM i really appreciate the words and help!..I might be needing them very soon! |
|
|
|
byrmol
Shed Building SQL Farmer
1591 Posts |
Posted - 2001-12-11 : 16:53:15
|
Nazim, are you sure we didn't work on that project together? :)quote:
David what was ur most horrofying experience in development
I don't think I am allowed to swear that much! To put it in a nut shell... Specs for a 2 story buildingSlab built to specification..Specs changed to 30 story highriseSlab destroyed and rebuilt..Specs changed to 100 storey highriseetc.....DavidMA database is a set of axioms, the response to a query is a theorem, the process of deriving the theorem from the axioms is a proof, a proof is made by manipulating symbols according to agreed mathematical rules. |
|
|
|
Nazim
A custom title
1408 Posts |
Posted - 2001-12-12 : 02:19:10
|
quote:
To put it in a nut shell... Specs for a 2 story buildingSlab built to specification..Specs changed to 30 story highriseSlab destroyed and rebuilt..Specs changed to 100 storey highriseetc.....
My ! Gosh i could hardly imagine ur state . I guess now u can stand up any kinda weird specs.The Worst problem with development i feel is, the users dont have a clear cut idea what they want and when they have it , they are not sure , and when they are sure they cant communicate and when they can communicate then it they communicate too(( and if they communicate well "The heart of a fool is in his mouth, the mouth of a wise man is in his heart" :) so v never know the xact specs, u drill drill drill , err improve , err improve err improve....and then they say its ok....) doesnt take much time to change it(i omit those 1's changes that are good). Da_Retina u r always welcome. About some scripts for Trial Balance . tell me how do u get ur statement of account . that can give me a good insight on ur system and i can suggest something.hey! does all this make Sense....-------------------------"Success is when Preparedness meets Opportunity" |
|
|
|
|
Accounting Applications