Month: February 2023

Tax change on saleswebapp

Proposal summary  The proposal covers tax changes in the sales webapp and NetSuite based on whether the customer type is residential or commercial.  Requirement  Our government has made a tax change concerning solarpanels. For residentieel projects the tax has been reduced to 0% but for commercial projects it stays at 21%.   So depending on the… Continue reading Tax change on saleswebapp

Marketing apps/extensions for SCA websites

Requirement  Is there a marketing app that syncs with NetSuite that we can use that for example uses the products from our website with direct links etc. etc. for buys to be able to click on an email?  We’re looking for something that is integrated saves time and is efficient.  Maybe there’s a program that… Continue reading Marketing apps/extensions for SCA websites

Email Template – Set Dynamic Value via script

Scenario: Use dynamic value in Email Template while sending email using SuiteScript 2.0 Firstly Create an email template: Here you can see, some variables prefixed with “NL”. You can give any name to your variable. Now in SuiteScript 2.0 code, use below code to replace variables of email template before sending email. //Get Transaction IDvar… Continue reading Email Template – Set Dynamic Value via script

Components Association with Operations

Manufacturing Work In Process (WIP) feature helps to assign and issue components at the operation level for items you assemble. Associating components with specific operations can benefit operations that take a long time to complete. Some components may not be required when the work order starts. Therefore, it is not ideal to issue all assembly… Continue reading Components Association with Operations

Excel Tips

Shift Between Different Excel FilesWhen you have different spreadsheets open, it’s really annoying shifting between different files because sometimes working on the wrong sheet can ruin the whole project. Using Ctrl + Tab you can shift between different files freely. 2. Create a New Shortcut MenuGenerally there are three shortcuts in the top menu, which… Continue reading Excel Tips

Display applying transaction as hyperlink in saved search

Create a transaction search Provide the required criteria On the results tab, along with other columns ad the following formula to display the hyperlink Formula (Text) |‘<a href=http://system.netsuite.com/app/accounting/transactions/purchord.nl?id=’||{applyingtransaction.internalid}||’>’||{applyingtransaction.number}||'</a>’ Make sure to copy the url from the netsuite itself and in the place of internal ID, you can enter it with the {applyingtransaction.internalid} between the pipeline… Continue reading Display applying transaction as hyperlink in saved search

Finding Records in Netsuite

The NetSuite interface includes search tools where we can enter keywords and retrieve matching records. The following quick retrieval tools are available: Global Search Quick Find Quick Search Portlet Global Search Global search allows us to search any page, record, or field anywhere in the account data by entering keywords into a search field. Search… Continue reading Finding Records in Netsuite

Saved Search to Show Who Created and Approved a Journal Entry

Navigate to Lists > Search > Saved Searches > New Click Transaction Search Title: Name it as desired Click Criteria subtab Click Standard Filter: Select Type Click Add Type: Select any of Type: Select Journal Click Set Select Posting Click Add Posting: Select Yes Click Set Click Results subtab Click Remove all Field: Select Date Summary Type: Select Group Click Add Select Period Summary Type: Select Group Click Add Select Type Summary Type: Select Group Click Add Select Document Number Summary Type: Select Group Click Add Select Created By Summary Type: Select Group Click Add Select Formula (Text) Summary Type: Select Maximum Formula: case when… Continue reading Saved Search to Show Who Created and Approved a Journal Entry