Author: Sruthi Surendran

The workflow action script not triggered from Workflow when the trigger is on after record submit or before record submit.

There is workflow used to perform a 3-way match by comparing the details of the Purchase Order, Item Receipt, and Vendor Bill records in NetSuite. Also ensure that the quantities, prices, and other details match across all three records. To check these conditions a workflow action script is used. The “trigger on” condition was given… Continue reading The workflow action script not triggered from Workflow when the trigger is on after record submit or before record submit.

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

Create saved search for Multi-Subsidiary Vendors

When we create vendor searches and vendor saved searches, we can obtain results for all of the secondary subsidiaries assigned to the multi-subsidiary vendor. On the Available Filters subtab, select Subsidiary Fields, and then choose the fields to include as filters. On the Results > Columns subtab, select Subsidiary Fields, and then choose the fields… Continue reading Create saved search for Multi-Subsidiary Vendors

Item search to show the preferred vendor and it’s purchase price

There will be multiple line associated with item saved search when the feature Multiple Vendors = T. To limit the Search results only to the Preferred Vendor’s Purchase Price, please follow the steps below: Create a saved search for item on the criteria tab select the type of item Formula (Numeric) > Formula: case when {‌vendor}… Continue reading Item search to show the preferred vendor and it’s purchase price

Add a text inside a table content in XML

Requirement is to add a text “Ondergenoemde besparing is afhankelijk van meerdere factoren derhalve kunnen er geen rechten aan ontleend worden. ” below some contents inside a table as shown in the image below: The existing code content was like this: Added a new code part as a new table content inside the existing one. The… Continue reading Add a text inside a table content in XML

Get an attribute value from object using javascript and jQuery

The attr() is a function of jQuery It’s not a native function of Javascript. Below shows how to get the same information using both jQuery and Javascript: Javascript: The getAttribute() method of the element interface returns the value of a specified attribute on the element. If the given attribute does not exist, the value returned will either be null or “” (the empty… Continue reading Get an attribute value from object using javascript and jQuery