function countrySearch(internalId, type) { try { let countryValueSearch = search.create({ type: type, filters: [ [“internalid”, “anyof”, internalId] ], columns: [ search.createColumn({ name: “country”, label: “Country” }) ] }); let searchResult = countryValueSearch.run().getRange({ start: 0, end: 1 }); if (searchResult.length > 0) { return searchResult[0].getValue({ name: “country” }); } return null; } catch (e) { log.error(“error@countrySearch”,… Continue reading Auto-check “Calculate Tax” based on Subsidiary and Vendor country (US)
Category: NetSuite ERP
NetSuite ERP
Handling Missing “Approval” Field in NetSuite CSV Import
Issue: The “Approval” field is not available by default in NetSuite’s CSV import templates, which can hinder the approval process for imported records. Solutions: Manual Approval: After importing data, manually update the approval status by editing each record in NetSuite’s UI. Automate with SuiteScript: Use SuiteScript to automatically trigger the approval process based on predefined… Continue reading Handling Missing “Approval” Field in NetSuite CSV Import
Post approval edits on Journal workflow
Scenario: The client wants the journal to go through approval routine, if the admin edits the journal after approval. i.e. Administrator edits trigger re-approval and JE is unposted until re-approved. The journal contains a review state. Reviewed journals will be submitted for approval by admin. If they are approved by admin it should go to… Continue reading Post approval edits on Journal workflow
Tax calculation via script
require([‘N/currentRecord’],function(currentRecord){ currentRecord.executeMacro({id:’calculateTax’}); }); To calculate the tax inside Netsuite via scripts // get macros available on the record let macros = invoiceRecord.getMacros(); // execute the macro if (‘calculateTax’ in macros) { macros.calculateTax(); // For promise version use: macros.calculateTax.promise() }
TO DISPLAY THE ASSEMBLY ITEM WITHOUT ITS COMPONENTS IN A TRANSACTION DATASET
REQUIREMENT When creating a dataset for sales orders, you may want to include line items. If a line item contains an assembly item, NetSuite automatically adds both the assembly item and its component items to the dataset. This may give discrepancies as you find totals for certain fields. SOLUTION In order to handle the requirement… Continue reading TO DISPLAY THE ASSEMBLY ITEM WITHOUT ITS COMPONENTS IN A TRANSACTION DATASET
Renaming “Copy Previous” Button on Purchase Request
Scenario Users wants to rename the Copy Previous button on Purchase Request using the Administrator role. The new label will be seen when creating Purchase Request using the Employee Center Role. Solution Navigate to Customization > Forms > Transaction Forms Preferred Purchase Order Form: Click Customize/Edit Click Action Click Standard Actions Auto Fill: Label: Enter Label Example: Copy Previous Record Note: The Copy Previous button is also called Auto Fill. This button… Continue reading Renaming “Copy Previous” Button on Purchase Request
Make Fields Mandatory on Transaction and Entry forms.
By default, some of the standard fields in NetSuite are already set as Mandatory depending on the importance or impact of that field/s into the Transaction or Entity records. But if there are some other fields that user wants to set as Mandatory, here are the steps on how to do so. NOTE: These steps apply on both Transaction forms and Entry forms. 1. Navigate to Customization… Continue reading Make Fields Mandatory on Transaction and Entry forms.
VoiceBot API Integration
The purpose of this task is to enhance operational efficiency and improve customer engagement by enabling automated voice communication directly from the Lead record in NetSuite. By adding a custom button that triggers a SuiteScript REST API call to the Voicebot Auto Call Bridging API, users can instantly initiate automated calls without leaving the CRM… Continue reading VoiceBot API Integration
Subscription Metrics SuiteApp
The Subscription Metrics SuiteApp is designed to help NetSuite users track and analyze key subscription business metrics. It’s particularly valuable for SaaS companies and other subscription-based businesses that need to monitor recurring revenue performance. It allows businesses to easily track key metrics like MRR, ARR, churn, and bookings with live dashboards, filters, and detailed reports.… Continue reading Subscription Metrics SuiteApp
Tax Calculation Plugin Error
When adding items to a transaction via a User Event Script or using Add Multiple in the UI, the HSN Code is not automatically sourced. This is a known limitation and considered an enhancement request. Attempting to manually set the HSN Code within a User Event Script and then saving the record will result in… Continue reading Tax Calculation Plugin Error