How to update decimal point in the SCA core tool

AI generated answer (using internal Slack threads):

****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ****** To update the decimal point in the SCA core tool, it's important to note that NetSuite typically allows only 0 or 2 decimal places. This is a system-wide setting and can be found where you configure company information. However, changing this setting can have significant impacts on your system and is generally not recommended. If you need to work with more decimal places, you might need to use a workaround. For example, you could create a custom field (e.g.,

custcol_expense

) and use this to store the additional decimal places. You could then use this field in your calculations. Here's a potential approach: 1. Create a custom field (e.g.,

custcol_expense

) to store the additional decimal places. 2. Set the rate field equal to

custcol_expense

+ the value passed in from your vendor's order acknowledgement. 3. If you trust your vendor's math, set the rate equal to the list price multiplied by the discount factor. 4. If not, set the amount to match. 5. Keep in mind that weird things can happen when the amount does not equal quantity times rate, so it's safest to do both. Remember, this is a workaround and may not be suitable for all situations. Always test thoroughly before implementing changes in your live environment.