Strange behavior on RollupConditinalSum function on Opportunities

Hello Enes Saridogan, 

I was testing your scenario locally and seems to be working for me when adding the RLI's via Subpanel in the Opportunity record view

Can you clarify the Sugar version and specify how are you creating the RLI's ? 

Hi Andre,

We're running on Sugar 12.0.0 ENT.

The fact is that when I create a second RLI, the amount is updated with the firstly created RLI, the third calculates the amount with the two first, etc .... 

The config value disable_related_calc_fields is set to false.

'disable_related_calc_fields' => false,

Is there anyhting else I can do? 

The RLI creation is mandatory when creating an opportunity.

When updating the opp or the RLI afterwards, the amount is calculated ...

Hi Enes, 

I am testing in the same version and when creating the new Opp it calculates value after saving the Opportunity with the RLI. I am wondering if this is related to the  'won_in_forefast_c' flag.

How are you setting the won_in_forefast_c to true or false? 

Well, sorry I paste the wrong formula, but it is not working anymore : 

rollupConditionalSum($revenuelineitems, "likely_case", "sales_stage", forecastSalesStages(true, false))

The result is the same, only fired on update, not creation ... 

With this formula also works fine on my stock 12.00 installation on Opportunity creation. 

I am wondering if this is being caused by some config setting or any custom code. 

Are you triggering any logic on the Opportunity creation? 

Do you have the sales_stage_dom dropdown as default or was something changed on your instance? 

Do you have any errors logged on Opportunity creation? 

Hi Enes,

I also attempted use to formulas and seems working fine for me as well.

At this point, If the customisations on a sandbox or production I think you should create a case for our Support Agents to investigate on a clone of the instance. This way we would have a better visibility and understanding of your customisations. 

Best Regards

Tevfik Tümer
Sr. Developer Support Engineer

Hello everybody,

After deep investigation, I noticed that an after_relationship_add logichook "anihilate" the calculation of the sugarlogic ... after removing it (because duplicate usage with after_save) everything is in order now :-)

Thanks for your answer and your time.

Best regards,

Enes