Details about this thread
  • State Not Answered
  • Replies 11 replies
  • Subscribers 87 subscribers
  • Views 4753 views
  • Users 0 members are here
Related content from around SugarClub

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

    Summations look quite Okay on the regular demo instance - below is the screenshot of the report built for the RLI module - looks like the sum of addendums matches with the value provided in the row header, right?


    Having that all the reports are actually based on regular SQL queries, the question is what is the criterion used specifically in your report and what is the module the report is built for. Also in rare cases, the customizations made to the modules may lead to the reports unexpected behavior

    In regards to the currencies- if user switches the Preferred Currency from the base currency (e.g. from $ to EUR  in this example) and set a checkbox in the profile to show values in the preferred currency , then all the values will go displayed in EUR and the same report will look like this:



    IMHO, despite some visual discrepancies, that visualization makes sense, so perhaps, that should be considered "as designed"

    I hope this helps

    Best Regards,
    Dmytro Chupylka

    integroscrm.com
    We make work in Sugar CRM system faster, more convenient and efficient

Reply
  • 0

    Summations look quite Okay on the regular demo instance - below is the screenshot of the report built for the RLI module - looks like the sum of addendums matches with the value provided in the row header, right?


    Having that all the reports are actually based on regular SQL queries, the question is what is the criterion used specifically in your report and what is the module the report is built for. Also in rare cases, the customizations made to the modules may lead to the reports unexpected behavior

    In regards to the currencies- if user switches the Preferred Currency from the base currency (e.g. from $ to EUR  in this example) and set a checkbox in the profile to show values in the preferred currency , then all the values will go displayed in EUR and the same report will look like this:



    IMHO, despite some visual discrepancies, that visualization makes sense, so perhaps, that should be considered "as designed"

    I hope this helps

    Best Regards,
    Dmytro Chupylka

    integroscrm.com
    We make work in Sugar CRM system faster, more convenient and efficient

Children