top of page
Search

Pricing Precision

  • Jun 18, 2013
  • 2 min read

Fields of type currency have a precision which determines the number of decimal places used in calculations and display. The settings for precision are described in the following table.

Precision Setting

Number of Decimal Places

Currency Precision

Determined by the setting on the currency.

Because the precision may vary with currency, 4 decimal places are shown in the Minimum Value and Maximum Value fields.

When the field is added to a form, the number of decimals shown will be determined by the currency precision for the currency of the record.

Pricing Decimal Precision

Determined by the value for Pricing Decimal Precision in System Settings on the General tab. The value can be from 0 to 4

A number

A value between 0 and 4


The precision setting can be changed after a field has been created.


System Fields

Currency fields on Quotes, Orders, Invoices appear to default to Currency Precision.

Precision Type

Fields

Pricing Decimal Precision

Price List Item: Amount, Rounding Amount

Opportunity Product, Quote Product, Order Product and Invoice Product: Price Per Unit

Product: List Price, Current Cost, Standard Cost

Field Precision, 2 decimal places

Opportunity: Total Line Item Discount Amount

Currency Precision

All other system currency fields

Effect of Precision on Calculations

The number of decimal places used affects rounding in calculations. It seems that CRM uses number of places for both displaying values and storing values.


Exchange Rates

When a field of type currency is added to an entity, two fields are in fact created, the field (e.g. FieldA) and another field with _base added to the name (e.g. FieldA_base).


FieldA_base stores the value in the base currency calculated using the exchange rate for the record currency. Where the currency of the record is the same as the base currency the two fields will have the same value.

 
 
 

Recent Posts

See All
New AB Exams from Microsoft

Four new exams with related courses and the prefix AB were released by Microsoft during December 2025 and January 2026. These are summarized in the table below. Exam Study Guide Title Link to Course A

 
 
 

Comments


bottom of page