troubleshooting Question

CRM 2011 - Designing entity

Avatar of tommym121
tommym121Flag for Canada asked on
Microsoft ApplicationsMicrosoft Dynamics
2 Comments1 Solution649 ViewsLast Modified:
I am trying to modelling a Real Estate Organization.  The company have branches, each branch has a manager and a number of real estate agent.  I am looking at the best way to incorporate the commission and accounting structure into the CRM.  Commission from a real estate deal will split between by agent, immediate manager and the company.  An accounting code is use for each of the two business of the company: Residential and Industrial real estates.  The Branch Manager also has accounting code for each business. Real Estate agent under the branch have multiple accounting codes for each deal. A combination of company code, manager code and agent real estate code are used to account for the commission structure for the agent.

Currently I used the user entity to create the hierarchy of the organization structure: Company, Manager(s) and Agent(s).  I am wondering how to capture the information.  The code is only a number.  Should I create an accounting code entity of different types: CompanyAccountingCode, ManagerAccountingCode, AgentDealAccountingCode:?  This will be the only way to capture a collection of codes for user entity even the entity has only one field called accounting code?

Can someone share their experience how to proper design a entity based system?
Chinmay Patel
Chief Technology Ninja
Join our community to see this answer!
Unlock 1 Answer and 2 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 2 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros