Contact Us Today!

Microsoft Dynamics CRM Pricing Fields Revert to Nearest Whole Number

Microsoft Dynamics CRM Pricing Fields Revert to Nearest Whole Number

Our team recently encountered an issue with pricing fields on one of our forms in Microsoft Dynamics CRM 2016. Two of the fields for invoice items would round to the nearest whole number when any field was updated and saved. The fields were “Amount” and “Extended Amount.”

Both fields have no calculations, plug ins or workflows associated with them. The data for the fields is brought over from another ERP system through Scribe integration. We tested this in our sandbox instance and our production environment with the same results. In addition, we created new items and changed the Precision on the fields to every option available and tested. We also input a test price list to try to fix it, but the problem persisted.

The form was completely recreated and all of the scripts associated with the form were removed, but the issue still occurred. I went into other organizations to see if this behavior was unique and found I could not recreate the issue in any other CRM instance. I compared the forms and could not find any differences.

I opened a case with Microsoft support. After testing and more research, he pinpointed the issue to a global setting. In system settings, there is a place that sets the currency precision that is used for pricing throughout the entire system. For this organization, it was set to “0” which caused our fields to round. I set it to 4 and the problem was resolved.

Hopefully this will assist anyone who runs into the same issue.

Beringer Associates, a Microsoft Gold Certified Partner, is always here to provide expert knowledge in topics like these. Please contact us with any questions you may have.


theProfessor

theProfessor

Rob is the CTO of Beringer Technology Group, and focuses his efforts on software development, cloud engineering, team mentoring and strategic technical direction. Rob has worked with Beringer since 2005, and has influenced every department from Development, Security, Implementation, Support and Sales. Rob graduated with his MBA from Rowan University in 2012, earned his Bachelors of Computer Science in 1997, and is current with several Microsoft technical certifications. Rob is very active, and loves to mountain bike, weight train, cook and hike with his dog pack.