Account_oportunities entries without relationship in Oportunities

đź’¬ General Discussion
1

Hi,

I’m building a report to show all opportunities for one Account. In one test i see that i have 3 rows in report and just 1 opportunity for that Account.

So i check in database and i have 3 rows in Account_Opportunities and just 1 in Opportunities… What happened? How i can repair this without manual work (delete manually by sql records).

Thanks.

2

I’m not sure I understand exactly what you mean, but you could try doing a rebuild relationships from the admin panel.

3

I want to know if are any way through CRM to clean this errors (delete entries from account_opportunities). I’m already done a rebuild relationships.

4

No it should happen automatically when you remove a relationship or delete an entry. I would just manually remove the records from the database just now and if it keeps on happening then there is an issue with your Suitecrm instance.

5

Thanks. I will do a sql query to check what records are with this problem and delete them.