Need Help To Maintain Tables

[mkkashif]

Hello All Dears .
And Request From The Experts.
i want Help to Maintain the Tables.
Please if you Can Give Me the Example what i want i will be greatly Thankful.
i want to maintain
1.Sale
2.Purchase
3.Journal Ledger
4.Trial Balance
5.Balance Sheet.
6.Stock Report
For this Puropose i am at the time using following Tables
1.Customers
Including Debtors and Creditors And Also in that Table i have a Cash In Hand Accounts Bank Accounts,Assesst Account
Mean Head Account.
2.Products Names Including all Products With Description and Rates
3.Orders similar like northwind.I Maintain Sale and Purchase Tran in 3,4 Tables.
4.OrdersDetails Similar Like Northwind.
5.Trans in this table i maintain all Transiction.For All Accounts
6.Nar For Text Purpose include all Description which can use in Transiction
i want to know i am going in right Direction.
Any Suggestion will be very Helpfull For Me.
Waiting Somone Help

 

[Rich]

We've already had a discussion on your structure elsewhere, it's seriously flawed, unless you understand the complexities of accounting your going to get in to deep water.
This thread might be of some help, other than that you need to do a great deal more research on the subject, try a search on Google