Notifications
Announcements
No record found.
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!
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
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.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Tom_Gioielli 73 Super User 2025 Season 2
Gerardo RenterÃa Ga... 43 Most Valuable Professional
Daniyal Khaleel 32 Most Valuable Professional
