Can you all help me to conceptualize and eventually create a system within CRM that assigns individual securities (stocks, bonds) to individual Accounts that are linked to specific Contacts or Clients?
Right now I have a custom module set up for Accounts, which contains type of account (Individual, Joint, IRA, Roth IRA, etc....) but only have the overall account value as a field. For instance, Joe's IRA = $45,789.
What I'd like to create is a list of securities owned that add up to the $45,789. Such as 10 shares XYZ Co., 15 shares ABC Co., etc...
Further, I'd like to note that XYZ Co. is a US Stock (Asset Category) and Large Cap (Asset Class)
I'm trying to figure out how to set this up?
Right now I have set up a custom module "Securities" set up (screen shot attached) that lists the securiy info with a Subform where I can chose which Asset Category and Class it belongs to..
Next, I need to figure out how to create a "table" or "form" that captures or lists all the securities a respective account might own? Such as, they own 50 shares SPY, 25 share ABC etc. and have that feed back to their respective Account.
Then this information could be further broken down to show what % US Stocks they own, % US Bonds, etc...
Should I modify Price Book module? Or another module? I'm looking for more big picture to start with than actual coding, etc.
Thanks!!