A search in a script is return fxamounts values from transactions. This search is part of a bundle installed in multiple environments. In a new client the search is return the values rounded. Only happens in this especific client. If you log the raw result in the search the values are ok with 2 decimal numbers. In the moment we do row.getValue, netsuite somehow round the values. The environment is multicurrency and multibook.

AI generated answer (using internal Slack threads):

Based on the conversations, it seems like the issue you're experiencing is related to the way NetSuite handles currency conversion and rounding in multicurrency and multibook environments. When you're using the

getValue

method on a search result, NetSuite might be applying some internal rounding or conversion logic, especially if the field you're trying to get is a currency field. This could explain why you're seeing rounded values in your script, even though the raw search result shows the correct decimal values. One possible solution could be to use the

fxamount

field instead of the

amount

field when dealing with multicurrency transactions. The

fxamount

field should give you the amount in the original transaction currency, without any conversion or rounding applied. If you're dealing with tax amounts, you might need to use a formula field to get the correct values in the foreign currency. For example, you could use a formula like

taxtotal / exchangerate

to get the tax amount in the original transaction currency. Remember to always test your changes thoroughly to ensure they're working as expected. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******