Details about this thread
  • State Not Answered
  • Replies 11 replies
  • Subscribers 86 subscribers
  • Views 5974 views
  • Users 0 members are here

Reports issue - incorrect summation & conversion?

Ada Napierala

Hello, 

I have created a few custom formula fields on Opportunity and Revenue Line Items that allows me to have a more granular view on the ARR. 

The fields on the Revenue Line Item work perfectly, also in respect to conversions. Fields on Opportunity are simply the summation of their respective fields from RLI.

The issue begins when I run reports, e.g. summation report that shows both revenue line item fields & sum for opportunity

1.  I created the Opp & RLI in GBP -  on the Opp & RLI I can see the conversion from GBP to USD (preferred currency) - why can't I see that on the report, and it is only showing me GBP? Do I need to create separate (hidden) USD only fields for reporting purposes?

2. Field summation is totally off - I chose to sum from opportunities fields (the reason for that is that in te future I want to also run reports only with Opportunity details and ARR sums, without each RLI listed) - they are represented in USD, which is correct, but the sums are wrong - e.g. the TCV for Test Opp for currencies is, $71,724.70, however the report is showing $143,449.41 (double the amount that is TCV on the opp) - how can I prevent it? 

The sum is correct only when I have 1 revenue line Item. 

Parents
  • 0

    Oh wow we are experiencing the same in Sugar Sell, our partner is investigating this at the moment.  However what we think might be happening in our case is the SUM;Revenue is using the current exchange rate and then displays the converted amount with the wrong currency indicator. (Known bug re:display - portal.sugarondemand.com/index.php)

    However my concern is if I'm a user based in US with my preferred currency as $ (default currency is Euros)  I don't want the SUM:Revenue to display as a conversion, I want to see the sum of the RLI in my preferred currency i.e. $ with no conversion.

    This only happens when I update the Currency rate.  I set the currency back to what it was and it reverts the SUM:Revenue back to the expected value.  Have you recently updated your currencies?

  • 0 in reply to Samantha Gowland

    Hey Samantha, 

    Thank you for your reply.

    Interesting - I tested my reports in Sandbox and the error still occurs - I did not recently update currencies there. 

    Do you also have an issue that if something is not in your preferred currency on the opp, it also won't show like that on the report?

    Samantha Gowland said:
    However my concern is if I'm a user based in US with my preferred currency as $ (default currency is Euros)  I don't want the SUM:Revenue to display as a conversion, I want to see the sum of the RLI in my preferred currency i.e. $ with no conversion.

    --> Every user can set up their preferred currency individually, but I am not sure how that affects reports.

  • 0 in reply to Ada Napierala

    Hi Ada

    Whatever the user has chosen as their preferred currency is the currency they will view reports and dashboards in.  Our partner has now raised this with Sugar as the core out of the box version seems to be displaying the SUM:Revenue in reports as a currency conversion?

    I'll keep you posted Slight smile

Reply
  • 0 in reply to Ada Napierala

    Hi Ada

    Whatever the user has chosen as their preferred currency is the currency they will view reports and dashboards in.  Our partner has now raised this with Sugar as the core out of the box version seems to be displaying the SUM:Revenue in reports as a currency conversion?

    I'll keep you posted Slight smile

Children
  • 0 in reply to Samantha Gowland

    Hi Samantha, 

    I am still experiencing the issue with currencies - both in sandbox and production. 

    Was you partner able to investigate this further?

    Thanks,

    Ada

  • 0 in reply to Ada Napierala

    Hi Ada

    They found that this is also in the Core System (OOTB) so they have raised a ticket to understand why this might be have been developed or if it is an expected behaviour?

    When we've heard back from Sugar I will add to here Slight smile

    Thanks

    Sam

  • 0 Sugar Employee Badge in reply to Ada Napierala

    Hi Ada, 

    I recommend reaching out to SugarCRM Support (https://support.sugarcrm.com/Resources/Working_With_Sugar_Support/)  and asking them to add you to Defect # 89055. This way, you can get real-time updates when this bug is fixed. This also helps us keep track of all the customers who have this issue and gauge its impact.

    Additionally, I can confirm that this defect has been escalated, so we are aware of its urgency. 

    And Samantha, thanks so much for sharing the defect. It makes my job a little easier :) 

    Take care!

    -Raye