Opportunity not tied to Accounts

SuiteCRM Forum - English Language SuiteCRM General Discussion
1

Hey everyone,

When I exported Opportunities from SalesForce, followed by importing it into SuiteCRM, I discovered that there were no columns in the db for Account ID.

How do I tie Opportunities to an Account?

I have suggested that the Opportunity is tied to the assigned user and you can see Accounts which are tied to the assigned user, but the manager of a department would like it to be as it as it is for her in SalesForce, when she would click on an opportunity, followed by viewing the Account

Thanks in advance

2

While digging around, I found that accounts_opportunities table is the table used to connect Accounts to Opportunities

update `accounts_opportunities` set account_id = "00132000019cNuOAAU"
where opportunity_id = "0066000001f0f8bAAA"