| Webtraffic Exchange | Salesforce
Salesforce is capable of storing currency to more than 2 decimal places at the database or API level. We use Financial Force as our accounting package and use Purchase Orders, Sales Orders, and Sales Invoice for fulfillment and billing purposes. Several of our suppliers use 3rd or 4th decimal points in the item pricing, and this causes our PO and supplier's Sales Invoice not to match final dollar amounts. Is it possible to use additional decimal points in product pricing?
The good news is that Salesforce does allow more than 2 decimal points on Unit Amount Fields. To achieve this, you'll have to change Organizational Custom Settings.- Click Setup > Develop > Custom Settings
- Click Manage by Organization Settings
- Click Edit
- Change the Number of Decimal Digits
- Click Save
The Number of Decimal Digits must be the same number of decimals that are set in Salesforce (THIS OPTION NO LONGER EXISTS IN SPRING 18 SALESFORCE EDITION)
- Click Setup > click Company Profile > click Manage Currencies > click Manage Currencies (again)
- Change the desired number of Decimal Places for each currency.
- Note that this is a global change so it will affect all currency fields in the system.
See the following Online Help links that refer to Decimal Places Extended Decimal Places and Create and Edit Purchase Orders.
0 Comments
Comments are moderated to keep the discussion useful and respectful. Spam, automated submissions, and low-value promotional comments are removed.
Leave a Comment