Editing Decimal Spaces

You can increase the number of digits after the decimal place in SME by going to Setup module > Company > Systems. Locate the '''Number of digits after the decimal for currency''' field and enter the number.

<br>[[File:DecimalPlaces.png]]

<br>If the currency decimals don't change in SME, you need to change your settings in Windows.
<br>1) In WIndows, open the Control Panel
<br>2) Double click on '''Regional and Language Options'''
<br>3) On the '''format''' tab, click '''Customize this format'''
<br>4) In the '''customize Regional Options''' window, click the '''Currency''' tab and set the number of decimal spaces in the '''No. of digits after decimal''' field.
<br>5) Click '''Apply''' and '''Ok'''
@@ Line 1: / Line 1: @@
-You can increase the number of digits after the decimal place in SME for '''Non-Currency''' fields up to 6 digits by going to Setup module > Company > Systems. Locate the '''Number of digits after the decimal for Non-Currency''' field and enter the number. Currency decimal places are handled by the Windows operating system and are set as outlined below. (Note: Decimals are rounded based on Banker/Math rules and will round up for fields requiring two decimal places and for QuickBooks).
+You can increase the number of digits after the decimal place in SME by going to Setup module > Company > Systems. Locate the '''Number of digits after the decimal for currency''' field and enter the number.
-SME is programed to use the SQL money datatype for all currency fields. This datatype is limited to four(4) places after the decimal. In calculations that exceed the 4th place, and use the 5th place, the 5th place value is not used.  E.G. .34175 – would be stored as .3417. (Note that the 5th place, is not rounded, it’s not used by SQL). This may result in a difference if your division of the cost exceeds 4 places.  The functionality behind this is due to syncing with QB as QB sums the total and then rounds, as does SME, and Excel, calculators, etc., round each value individually and then sum. The result is that there may be cases where the calculated cost will be a penny off. We’ve investigated modifying the data type however we have not due to the issues that raises with QB.
 <br>[[File:DecimalPlaces.png]]
 <br>If the currency decimals don't change in SME, you need to change your settings in Windows.
-<br>1) In Windows, open the Control Panel
+<br>1) In WIndows, open the Control Panel
 <br>2) Double click on '''Regional and Language Options'''
 <br>3) On the '''format''' tab, click '''Customize this format'''
 <br>4) In the '''customize Regional Options''' window, click the '''Currency''' tab and set the number of decimal spaces in the '''No. of digits after decimal''' field.
 <br>5) Click '''Apply''' and '''Ok'''
-The items are summed and then rounded. A calculator does rounding by first rounding the individual amounts and then totals the sum. Ex:
-Excel Rounding:
-At 2 places:
-<br>[[File:Decimal1.png]]
-Note that the total = 19.25
-Expanded to 3 places:
-<br>[[File:Decimal2.png]]
-SME/QB rounding:  6.416 + 6.416 + 6.416  = 19.25
-<br>[[File:Decimal3.png]]<br>
-Totaled price first: 6.146 * 3 = 19.248 – or 19.25
-<br>
-QuickBooks Total at 3 places: 6.416 = 19.25
-<br>[[File:Decimal4.png]]
-MS Calculator  rounding at 3 places:         6.416 (rounded = 6.42) * 3 = 19.26
-<br>[[File:Decimal5.png]]