mandar.dasgupta (8/3/2013)
Thanks PaulB.I have worked a little more and i showed it to our Accounts Head and he was reasonbly satisfied with it. However i ran into a little bit of trouble regarding vouchers with multiple debits and multiple credits.
My design takes care of Single Debit and multiple credits and single Credit and multiple debits.But i cant be sure in case of multiple debits and multiple credits.
eg.
VoucherMain
VoucherNoVoucherDateDrCrVTypeAccCode
2 2013-07-23 Credit 1 000002
VoucherDetails
VoucherNoSlNoAccCodeAmountNarration
2 10000056000.00Purchase of table.
2 2 000012 5000.00 Purchase of drinks
In the above example the account/Ledger with code 000002 is credited with
Rs.11000 and the account/Ledger with code 000005 is debited with 6000
and the account/Ledger with code 000012 is debited with 5000.
The DrCr column specifies wether to credit or debit the account in VoucherMain table and the opposite happens to the accounts in the VoucherDetails Table.
The tables are linked with the voucherNo column.
So the above design is capable of handling single debit multiple credits
or single credit multiple debits.
I cant be sure about the multiple debits and multiple credit situation please suggest.
I see no reason why table VoucherDetails couldn't describe multiple debits and credits.
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.