469,276 Members | 2,057 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,276 developers. It's quick & easy.

How do I implement Accounts across various modules.


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.

Mar 20 '08 #1
0 1090

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

9 posts views Thread by Martin Drautzburg | last post: by
13 posts views Thread by SpaceCowboy | last post: by
reply views Thread by suresh191 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.