Pricing Fields Revert to the 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.”

rounded 1 252x300 Pricing Fields Revert to the Nearest Whole Number

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.

precision 300x80 Pricing Fields Revert to the Nearest Whole Number

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. Furthermore, 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.

system settings 300x131 Pricing Fields Revert to the Nearest Whole Number

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

Beringer Technology Group, a leading Microsoft Gold Certified Partner specializing in Microsoft Dynamics 365 and CRM for Distribution. We also provide expert Managed IT Services, Backup and Disaster Recovery, Cloud Based Computing and Unified Communication Systems.

Let’s block ads! (Why?)

CRM Software Blog | Dynamics 365