7

Title - Issue with reports where if the summary for a column of the data type Currency is set to Sum, the summary shows up the converted amount as per the base currency when a report is run on any record/s regardless of the currency that was selected for those records

Please find the repro steps as follows
1. I clicked “Sales” from the nav bar in my trial instance https://xolo.crm4.dynamics.com/ and selected the “Reports” tile
2. I the clicked “+New ” from the application ribbon and this brought up a window titled Report: New Report
3. Now, I clicked the button called “Report Wizard” and this brought up the report wizard
4. From the “Get Started” page, selected the starting point as “Start a new report”
5. This brought up the page “Report Properties” from where I named the report name and selected the primary record type as “Opportunities” and clicked “Next”
* Please note the issue is reproducible with any other record type as well
6. Now, I was asked to define a filter criteria and I left this blank and clicked “Next” as it was not required
7. I was now on the “Lay Out Fields” part of wizard from where I added the column named “Budget Amount” of the record type “Opportunities”
8. I selected “Sum” to be the summary type for the column and clicked Ok
9. The next page was meant to select the basic format of the report
10. I selected “Table only” as the basic format and clicked “Next”
11. The report summary that came up after that had the report name as “ABC” as that was the name that I had kept for the report
12. The primary record type showed up as “Opportunities”
13. I then clicked “Next” and I was notified in the next page that the report was successfully created
14. I then clicked “Finish” which closed the wizard
15. Now, I created an Opportunity record where I selected “Rupee” as the currency with the currency code “INR” and put a random amount of 14000 in the field labeled “Budget Amount”
16. I then saved the record and clicked the three dots meant for more options from the application ribbon
17. From the list that dropped down after I had clicked more options, I selected the option “Run Report”
18. This brought up a flyout menu from where I selected the report named “ABC” that I had just built
19. Finally, the report viewer came up with the budget amount that had two values under it
20. The value right below the column was the amount 14000 and it showed up as Rs. 14,000.00
21. However, the amount that appeared below this value was £135.82 which was basically the amount that was converted from Rupees to British Pounds

Category:
STATUS DETAILS
New