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.