Go Back   TechArena Community > Software > Software Development
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



Model db for easy accounting database

Software Development


Reply
 
Thread Tools Search this Thread
  #1  
Old 26-07-2011
Member
 
Join Date: May 2011
Posts: 80
Model db for easy accounting database
  

I have a question that rather no one has asked till now , well here goes my question In the simplest I use that word very insecurely of cases, how would you guys form a database in which refunds and overpayments be permitted at the same time as keeping the original charge ,payment transactions just as there are , in view of the fact that most of these entities or transactions have a many-to-many connection, things are seeming a bit more complicated than I previously thought so please help me according .

Reply With Quote
  #2  
Old 26-07-2011
Member
 
Join Date: May 2009
Posts: 533
Re: Model db for easy accounting database

Well, I need to say that this thread made me seriously think for an 1 hour before I reply you but , as far as I have understood the question I have been able make out an solution for it , so how about adding a new table/row to it as that might help you to gain a better control over it , as that extra row/column would be named as credit = payment done by member and the charges that are paid by them ., so that would just auto ?calculate the things .
Reply With Quote
  #3  
Old 26-07-2011
Member
 
Join Date: May 2009
Posts: 523
Re: Model db for easy accounting database

In my opinion I don ? think storing that high values would be an better option for you as that might just miss all the normalization which need to be done when you are on it ,as the I have a analogous application in progress and I recalculate it every time when I input an value in it . The concern with storing the rate is that it constantly desires to be accurate. If you at one spot you overlook to modify the value, you'll have a massive mess and it will be tough to fix the wrong numbers.
Reply With Quote
  #4  
Old 26-07-2011
Member
 
Join Date: May 2009
Posts: 503
Re: Model db for easy accounting database

This is what I can recall from the last accountant software that I made for an shopkeeper to keep an detailed trap on it , I made a new table called table 1 and they had all the necessary filed in to that table ( mind you I am using SQL ) here and then give each table an unique id to it and then I used an sql command to
Code:
Select Sum (Credit)-Sum (Debit) from table1 Where Account Number ='134323' And Type='labor?
While the other fields may vary according to your requirements .
Reply With Quote
  #5  
Old 27-07-2011
Member
 
Join Date: May 2011
Posts: 80
Re: Model db for easy accounting database

Thanks for the replies all. Because a bit of an update, we're officially having a "back to the drawing board" gathering late this week (or early next). After the preceding tries and it has been unwavering that this purpose is much more multifaceted than the characteristic creep made obvious. That supposed, the whole thing is back on the table, together with growth framework, etc.
Reply With Quote
Reply

  TechArena Community > Software > Software Development
Tags: , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "Model db for easy accounting database"
Thread Thread Starter Forum Replies Last Post
Differences in AT&T phone model and unlocked/unbranded model of HTC titan Pratyus Portable Devices 8 05-12-2011 09:20 PM
CAR MAKE & MODEL database karv Software Development 2 07-10-2011 02:19 PM
Export Database Model to SQL Nakul2 Software Development 5 01-12-2010 07:42 AM
How to fix the Network Critical database consistency problem in easy steps Centaurs Networking & Security 6 31-08-2010 05:50 AM


All times are GMT +5.5. The time now is 03:40 AM.