Modifying Decimal Places for Sales Price and Total Price in the Product Manager
Available In Core Suite 1.39+
By default, the GSP Product Manager displays the Sales Price and Total Price field to 2 decimal places. However, some organisation will require the ability to set prices to greater precision. Particularly where they work with high-volume quantities or require greater pricing precision for accurate calculations and quoting. The Product Manager can be customized to display the Sales Price and Total Price fields to up to 8 decimal places.
Steps to Complete
- Access Setup Area
- Navigate to the Setup area in Salesforce by selecting the cog icon in the top menu, then click “Setup”.
- Select Custom Metadata Types.
- From the left-hand menu, select “Custom Metadata Types”.
- Click the “Manage Records” link on the “Subscription Settings” option.
- Locate the “Default” record and click “Edit”.
- Modify the “Product Manager Sales Price Decimals” field.
- In the “Product Manager Settings” section, set the “Product Manager Sales Price Decimals” field to the required number of decimal places.
- By default, this field is set to 2 and can be configured to any value between 0 and 8.
- Click “Save” to apply the change.
Outcomes
Once the “Product Manager Sales Price Decimals” field has been updated in the default Custom Metadata Type record, the change will apply to the Product Manager on both Opportunities and Quotes. When a product is selected in the Product Manager, the Sales Price and Total Price fields will display using the configured number of decimal places.
Troubleshooting
Recommendation:
If more than 8 decimal places are required for pricing fields, you should create custom currency fields to store this additional precision.
These fields can then be added to the Product Manager by including them in the “Product Manager – Additional Columns” field set on the Opportunity Product object.
Updating the Custom Metadata Type only affects how values are displayed within the Product Manager interface.
Recommendation:
If you need to display the standard currency fields with higher precision, you can create custom formula fields that reference the standard Sales Price and Total Price fields. These formula fields allow you to control the number of decimal places shown, providing greater flexibility in how values are displayed.
However, the Package Builder currently only supports Sales Price values with a maximum of 2 decimal places for currency fields.
Request Further Support
If you’re still having some trouble, we’re more than happy to help. Let us know what you’re struggling with using the form below, and we’ll be in touch as soon as possible.