Designing a ledger system
-
hi everyone, I'm making an accounting software for an organization for the first time and I've designed a ledger table as Ledger(ID, TDate, Debit, Credit, Balance) The balance field is a calculated field. And I was wondering how should I program its update and delete triggers. Can u plz give me a few useful tips on this. thanks Rocky
-
hi everyone, I'm making an accounting software for an organization for the first time and I've designed a ledger table as Ledger(ID, TDate, Debit, Credit, Balance) The balance field is a calculated field. And I was wondering how should I program its update and delete triggers. Can u plz give me a few useful tips on this. thanks Rocky
-
thank u so much for ur reply, I really appreciate this, I c that u have designed many accounting systems successfully with this design. well I have already done a lot of work on the design and I thought I should tell u abt my design as well. I have designed the a journal table so that the daily transactions should be recorded in that and these transactions are posted automatically to the ledger table where the balance is calculated automaticaly even in teh case of an insert, Delete or update opration. There was another requirement that automatic posting should be made to the journal while making a new bill, which offcourse will go to the ledgers as well. So far I havent seen any sub categories of accounts in my organizations case. when the balance field shows a positive amount, it means that its a credit balance and otherwise its a debit balance. So how does it look :) hope to hear ur comments on that, thank u for ur time. Rocky