Author: Geordy Cleetus

Differentiate OneWorld and Mid-market accounts for Scripts

While creating scripts for NetSuite OneWorld and Mid-market accounts, we can make use of the feature runtime.isFeatureInEffect(‘SUBSIDIARIES’)) returns true if Subsidiary is present and thereby denoting One World account. returns false if Subsidiary is absent and thereby denoting Mid-market account. runtime.isFeatureInEffect(‘MULTISUBSIDIARYCUSTOMER’)) returns true if Subsidiary is present and thereby denoting One World account. returns false… Continue reading Differentiate OneWorld and Mid-market accounts for Scripts

Asset Share Price Integration (Market stack)

Requirement  Need to integrate Asset Number (custom record) with the Stock market prices of the Asset numbers with the respective World Market and Ticker symbol.Fetch the data for each day. Overview The marketstack API was built to offer a stock market data solution and make it accessible to both developers and companies around the world.… Continue reading Asset Share Price Integration (Market stack)

Grouping Saved Search Result of each line

While creating a saved search, if the join fields (text fields) are present in each line, we could group them using formula(text) and then obtain the result in a single line. The formula used is NS_CONCAT. name: “formulatext”,summary: “MAX”,formula: “NS_CONCAT({<joinfields.fieldname>})”,label: “<label>” If more results are to be added to the search, use appropriate summary for those.