SuiteQL Query Tool

/** * @NApiVersion 2.1 * @NScriptType Suitelet * @NModuleScope Public */ /*  —————————————————————————————— Script Information —————————————————————————————— Name: SuiteQL Query Tool ID: _suiteql_query_tool Description A utility for running SuiteQL queries in a NetSuite instance. Tim Dietrich * timdietrich@me.com * https://timdietrich.me —————————————————————————————— History —————————————————————————————— 20210714 – Tim Dietrich * First public beta of v2021.2. 20210725 – Tim… Continue reading SuiteQL Query Tool

SuiteQL is the Future

Demo: Running SuiteQL Query Tool for Getting Unit of Measure Check out Tim Dietrich’s SuiteQL Query Tool (free). Download the zip file and extract it. Create a suitelet record in the NetSuite account and run it. Run the Query “SELECT uom.unitname, uom.conversionrate FROM unitsType INNER JOIN unitsTypeUom as uom ON (unitsType.id = uom.unitstype)”