Customer experience | Sales, Customer Insights,...

Data Export Service - Rounding Currency when Exported to Azure SQL DB

(0) Share

Report

Posted on by Community Member Microsoft Employee

We recently started using the Data Export Service in our D365 CRM. It works great but I noticed that currency fields are being rounded when exported to Azure SQL db. For instance, we have a fee that is .50 in the CRM but it's rounded to 1.00 in the db. I can see the datatype for the field in the db is set to decimal(38,0) which explains why it's being rounded but I am not sure how that type was set. Any ideas how to adjust it to show as .50 in the db? Thanks!

All responses (2)

Answers (0)

Community Member Microsoft Employee on at

Like (0)

Report

RE: Data Export Service - Rounding Currency when Exported to Azure SQL DB

I only noticed it on this specific currency field. I was able to confirm that decimal type fields exported from D365 to SQL Server are not rounding up so it appears to be related to currency type fields. I appreciate the feedback and will consider deleting and rebuilding the profile but my concern is how it will affect any stored procedure or views that have been created with those tables. I have submitted a support ticket with Microsoft.
Suggested answer

Bipin D365 28,961 Moderator on at

Like (0)

Report

RE: Data Export Service - Rounding Currency when Exported to Azure SQL DB

Hi,

Is this happening for all currenncy field or only specific fields?

Please delete your profile and recreate to check if issue fixed.

You can also log support ticket with microsoft.

admin.powerplatform.microsoft.com/support

Please mark my answer verified if i were helpful