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)”
Tag: suiteQL
Suite talk Rest API setup
Importing the Postman Collection To import the Postman collection: Download the REST web services Postman collection of sample requests from the SuiteTalk tools download page at https://<accountID>.app.netsuite.com/app/external/integration/integrationDownloadPage.nl. To access this page, you must substitute your account ID, and the REST web services permission must be assigned to your role. Unzip the archive. Click Import in… Continue reading Suite talk Rest API setup
Record catalog for suiteQL reference. Act like NetSuite Database record browser.
The Records Catalog in NetSuite is a valuable reference tool that provides comprehensive information about the NetSuite model structure and behavior. This tool serves as a guide for developers, administrators, and system users to better understand the available record types and fields within the NetSuite platform. The main functionalities and features of the Records Catalog… Continue reading Record catalog for suiteQL reference. Act like NetSuite Database record browser.
N/query module overview.
Understanding N/query module NetSuite, a leading cloud-based ERP platform, offers a robust set of tools and modules to help businesses streamline their operations. The N/query module is especially important for querying and manipulating data within NetSuite. In this article, we will look at the N/query module, and its key features, and provide a live example… Continue reading N/query module overview.
SQL and SuiteQL of Income Statement Workbook
Dataset: Workbook: SQL: SuiteQL:
How to extract Installments using SuiteQL?
How to extract Installments using SuiteQL?
SuiteQL to generate a Customer saved search in Power BI via ODBC connector
The requirement was to connect NetSuite searches with Power BI in order to create the reports. We can load tables from NetSuite to Power BI based on the permissions given in the custom role. The searches cannot be load this way. As solution to this we can use SQL queries to recreate the same search… Continue reading SuiteQL to generate a Customer saved search in Power BI via ODBC connector
SuiteQL to generate a saved search in Power BI via ODBC connector
The requirement was to connect NetSuite searches with Power BI in order to create the reports. We can load tables from NetSuite to Power BI based on the permissions given in the custom role. The searches cannot be load this way. As solution to this we can use SQL queries to recreate the same search… Continue reading SuiteQL to generate a saved search in Power BI via ODBC connector
Accessing Assembly Items via SuiteQL
Description We can fetch some of the beta record fields using SuiteQL in postman. Here Assembly Item is an example for beta record. Solution We can only fetch the following fields of Assembly item record using SuiteQL Assembly Bills of materials Can be master Master default To use SuiteQL, we need to be careful of… Continue reading Accessing Assembly Items via SuiteQL
Sync Between CAAPS And NetSuite
Proposal Summary This proposal summarizes the requirements and solutions for integrating real-time business data with Netsuite and CAAPS. Requirement Integration between the Netsuite & the CAAPS system should be implemented to send the vendor details, GL code/Chart of Account, Purchase order, Item receipts. The client would like to have a bulk extraction of the following… Continue reading Sync Between CAAPS And NetSuite