How do I implement Accounts across various modules.

[Bhoomikakaiya]

Hi,

I am designing the Accounting portion in our ERP System using Microsoft Platform.

There are lots of challenges ahead of me.
Scenario is :
1. Create an Account for any new Customer. Be it for Customer Or Supplier or Bank.

2. Now when i add a sales entry in Sales Module the amount gets reflected for that particular customer in Sales Tables. Similarly for purchase etc.

3. For knowing the outstanding of the Customer in the Report there are two ways
a. Either i maintain a single table wherein all the data regarding the Credit or Debit of account will be dumped or
b. I use all the tables used in Sales and Purchase Modules to calculate the Amount.

Latter is very difficult to maintain. As over a course of time there will be multiple modules for doing the entries related to credit or Debit of any Account.

If i am selecting the 1st way to save data in another table also along with Normal Sales or Purchase tables then there will a single table involved with all the Inserts, Updates and deletes of any module.

With 500 Users then a single table will become a bottleneck in performance.

Any suggestions for implenting the Accounting System in ERP.

Any help would be highly appreciated.

Regards,
Bhoomi.