Opportunity Probability Not Updating

💬 General Discussion
1

I have modified sales_probability_dom and sales_stage_dom drop downs with matching keys. But, changes to Sales Stage do not properly update probability and when selecting a probability manually, the values are not recorded to the opportunities table. I am new to Sugar/Suite, so I am not sure if the values ought be recorded to the probability column in the table, but suspect that they should to support direct queries. I would appreciate any assistance on clarifying whether there is actually a bug here on the data side. There is definitely an issue on the link between the drop downs.

Happy to provide a user account with access to our install to validate the configuration of the drop down menus and to see the behavior in person.

2

Hi andrewl,

Please send a screenshot of your Sales Stage dropdown configuration, for both dropdowns in the Dropdown Editor.

Thanks,

Will.

3


Attached screenshots.

4

For good measure - the probability field definition for opportunities.

5

Hi Andrew,

Thanks for attaching the screen shots. Your drop downs look correct and I have tested deleting/editing/adding drop downs on a local instance of SuiteCRM and this seems to be working as required. Are you stating that the values are not being recorded at all within the probability column of the database? Your probability and sales stages should be recorded for each opportunity.

Thanks,

Will.

6

That is correct Will. On load of the Opportunity, no value is displayed for the Probabilty (a hidden field is present with the proper value). When editing, the menus do not link properly so updating Sales Stage does not change the probability. And then, when saving, the probability value is not recorded to the db. I have created an admin account for you on our system so you can take a look if you have a moment. Where can I send the credentials?

And Thank You for the assist!

7

Hi Andrew,

This may be related to permissions. Please set the following recommended permissions on your SuiteCRM instance:

sudo chmod -R 755 .

sudo chmod -R 775 cache custom modules themes data upload config_override.php

If this doesn’t resolve the issue, please get in touch.

Thanks,

Will.

8

Will, This was not a permissions issue. I’m not sure how things got borked. But, I’ve done a complete reinstall as a test case, updated the probability/sales dom drop down menus and everything works. Now, to try and restore all the data.

Consider this issue closed, please.