Hey, does anyone have an idea to convert any currency amount to INR currency using the saved search? for example, USD currency amount to INR currency amount AUD currency amount to INR currency amount.

Add a Transaction Body field called "Exchange rate in INR" and set the current exchange rate as on the transaction date using script. Use this "Exchange rate in INR" in saved search

is there way standard functionality without customization? how can we do for previous transaction records using custom field? its very difficult to add INR currency for previous records

@jayaram if the base currency of the subsidiary the transactions are in is INR, then it’s as easy as setting your consolidation option to ‘None’ in the saved search’s results setup page. If the base subsidiary is something else, then what @Yogesh Tahiliani suggested. NetSuite only captures the amount in the base currency (and arguably in ‘foreign currency’ if selected on the transaction).