You should have a separate table for banking transaction, and a separate one for maintaining the bank name, address, contact that can link to the first one. Looking from your...

If you still searching high and low, try getting accounting database design book from accountingdes.com website

You might kickstart some database designing work with this book, 🙂

Improve inventory system? Are you looking at ways to optimise your server performance or finding ways to improve your design?

If you're looking for an inventory database sample, try browsing a...

To know more about accounting database design, try logging to:

http://www.accountingdatabasedesign.blogspot.com/

Hi AnzioBake,

Thanks for your kind reply, i've tested the script,

Below is the output:

Hi Marshall,

Thanks for your kind reply, i've tested the script, but it seems that no value are reflected under the Sales & Cost column except for the Profit

column that...