Click here to Skip to main content
15,914,452 members
Home / Discussions / Design and Architecture
   

Design and Architecture

 
GeneralRe: Plugin inheritance architecture Pin
Moak25-May-07 2:36
Moak25-May-07 2:36 
QuestionDistributed SingleTon Instance class and Deriving from SingleTon Instance class. Pin
Chetan Kudalkar14-May-07 22:19
Chetan Kudalkar14-May-07 22:19 
QuestionDesigning a ledger system Pin
Rocky#13-May-07 22:47
Rocky#13-May-07 22:47 
Answer[Message Deleted] Pin
#12314-May-07 13:02
#12314-May-07 13:02 
GeneralRe: Designing a ledger system Pin
led mike14-May-07 18:22
led mike14-May-07 18:22 
GeneralRe: Designing a ledger system Pin
led mike14-May-07 20:05
led mike14-May-07 20:05 
GeneralRe: Designing a ledger system Pin
Rocky#15-May-07 21:03
Rocky#15-May-07 21:03 
GeneralRe: Designing a ledger system Pin
Rocky#15-May-07 22:14
Rocky#15-May-07 22:14 
Well since yesterday I've been wondering about the second issue ur talking abt i.e
The Grand Negus wrote:
(2) keeping a record of what actually happened when updates and deletes are made.



I was wondering what I should do in that case. Should I completely disallow updates and deletes and let the user modify the previous entry with another transaction in the journal. My desgin is like this

Generaljournal(journalID, Debit, Credit, Particulars, TDate, AccountID, billID)
Accounts(AccountID, Title, StartDate, CustID, PartyID, IsActive)
PartyID(ID, Name, Address) -- the parties from which we purchase
LedgersDetails(ID, TDate, Debit, Credit, Balance, journalID, EmpID)
Bill(BillID, CustID, TotalWeight, EmpID, Rate, TotalAmount, Discount, Coneweight, NetWeight, BillDate )
Sale(SaleID, BillID, prodID, PackageWeight, PackageCount, Rate )
Product(ProdID, Name, TypeID, Size, IsObsolete, Pic, IntroDate)
Cust(CustID, Name, Address)
Emp(ID, Name, FathersName, NIC, pic, levelID)
Type(ID, Name)
ProdSize(ProdID, SizeID)
Size(ID, title)
Users(UserName, Password, EmpId, LoggedIn, Last_LoggedIn)

UserLevel(ID, Name)

---------------
phew!! so thats just abt it for the design and as I was saying, well the problem i was wondering abt is the updates and deletes in generalJournal, So Now What do u say... Is that a good idea that I should just let the user update or delete a record in journal? well if u ask me its pretty dangerous coz there would be no clue who did all that.
on the other hand,

how should the user edit/ Cancel a previous transaction by makinga new entry in the database? probably the reason y I'm asking thsi is the lack of my indepth knowlege of accounting. Smile | :)

Please give me a few guideline on this issue.

Rocky
GeneralRe: Designing a ledger system Pin
Rocky#15-May-07 22:43
Rocky#15-May-07 22:43 
General[Message Deleted] Pin
#12315-May-07 23:02
#12315-May-07 23:02 
GeneralRe: Designing a ledger system Pin
Rocky#15-May-07 23:22
Rocky#15-May-07 23:22 
GeneralRe: Designing a ledger system Pin
Rocky#18-May-07 1:24
Rocky#18-May-07 1:24 
GeneralRe: Designing a ledger system Pin
Rocky#22-May-07 2:13
Rocky#22-May-07 2:13 
Questiondatabase dependencies Pin
kindd8-May-07 19:36
kindd8-May-07 19:36 
GeneralRe: database dependencies Pin
kindd11-May-07 19:09
kindd11-May-07 19:09 
General[Message Deleted] Pin
#12311-May-07 19:53
#12311-May-07 19:53 
GeneralRe: database dependencies Pin
kindd11-May-07 22:31
kindd11-May-07 22:31 
GeneralRe: database dependencies Pin
kindd13-May-07 21:30
kindd13-May-07 21:30 
GeneralRe: database dependencies Pin
kindd14-May-07 20:12
kindd14-May-07 20:12 
QuestionWindows App and Web App. Where can the two meet. Pin
BigPMcCoy8-May-07 12:02
BigPMcCoy8-May-07 12:02 
AnswerRe: Windows App and Web App. Where can the two meet. Pin
Ed.Poore8-May-07 12:05
Ed.Poore8-May-07 12:05 
AnswerRe: Windows App and Web App. Where can the two meet. Pin
led mike9-May-07 5:04
led mike9-May-07 5:04 
QuestionAsp.Net Database Usage vs Windows Application Database Usage [modified] Pin
Tristan Rhodes8-May-07 5:13
Tristan Rhodes8-May-07 5:13 
AnswerRe: Asp.Net Database Usage vs Windows Application Database Usage Pin
led mike9-May-07 4:44
led mike9-May-07 4:44 
GeneralRe: Asp.Net Database Usage vs Windows Application Database Usage Pin
Tristan Rhodes9-May-07 6:24
Tristan Rhodes9-May-07 6:24 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.