After assigning a custom item field as either a Field Set or a Sort Field in Suite Commerce Advanced website we cannot edit particular custom field this is because to prevent the user from deleting a custom field which is already used in “Field Set or a Sort Field”. As a workaround, users will have to remove the custom field from being assigned as Field Set or Sort Field in Suite Commerce Advanced website follow below steps. 1. Navigate… Continue reading Know how to Edit Custom Fields assigned as “Field Sets or Sort Fields” in Suite Commerce Advanced.
Category: NS Implementation
All articles / code related to Netsuite implementation
DISPLAYING TIME ELAPSED IN DAYS AND HOURS
What to be done??? Normalize the values with TO_NUMBER and TO_NCHAR, then concatenate them using the following formula: CONCAT(CONCAT(‘Days: ‘,TO_NCHAR(FLOOR(TO_NUMBER(TO_NCHAR({timeelapsed}/24))))), CONCAT(‘ Hours: ‘,TO_NCHAR(MOD(TO_NUMBER(TO_NCHAR({timeelapsed})),24)))) What would be the output??? String
The Role of the Personalization Worksheet in NetSuite SuiteSuccess
Implementing an ERP system can feel overwhelming, especially when every business has its own way of working. NetSuite addresses this challenge through its Personalization Worksheet, a structured discovery tool used during the Engage phase of SuiteSuccess delivery. The worksheet is more than just an Excel file — it’s a guide for consultants and customers to… Continue reading The Role of the Personalization Worksheet in NetSuite SuiteSuccess
How to apply journal entry to bill
function transformBillToPayment(billId, journalId, incomeTaxAmount) { try { let payment = record.transform({ fromType: record.Type.VENDOR_BILL, fromId: billId, toType: record.Type.VENDOR_PAYMENT, isDynamic: true }); let applyLineCount = payment.getLineCount({ sublistId: ‘apply’ }); for (let i = 0; i < applyLineCount; i++) { payment.selectLine({ sublistId: ‘apply’, line: i }); payment.setCurrentSublistValue({ sublistId: ‘apply’, fieldId: ‘apply’, value: false }); payment.commitLine({ sublistId: ‘apply’ });… Continue reading How to apply journal entry to bill
How to Resolve Error “Your current role does not have permission to perform” in REST API
Issue We are getting below error in postman Get call with custom role for Sales Invoice https://xxxxxxxx.suitetalk.api.netsuite.com/services/rest/record/v1/invoice/ error :Your current role does not have permission to perform this action.”, There is no error with custom role if we give invoice number as below https://xxxxxxxx.suitetalk.api.netsuite.com/services/rest/record/v1/invoice/12632 No error if we run with Admin role I able to access invoice list using custom role in UI screen but… Continue reading How to Resolve Error “Your current role does not have permission to perform” in REST API
Challenges of Field Service Management
Customer Expectations Meeting or exceeding customer expectations is always a challenge. Adopting new software can lead to confusion and frustration and initially hinder customer service. However, with a well-planned deployment, an FSM solution can reduce the number of dissatisfied customers while maintaining service levels regardless of upgrades, updates and employee movement. Service Delivery Optimization Customers… Continue reading Challenges of Field Service Management
Correcting Website Name in Google Search Using JSON-LD in SuiteCommerce Microsites
The client operates multiple microsites under different domains. However, in Google Search results, the website name for some existing indexed microsites is incorrect, outdated, or inconsistent. This article outlines the issue, Google’s rendering behavior, and the implemented solution using JSON-LD structured data to ensure each microsite has accurate SEO metadata aligned with its domain and… Continue reading Correcting Website Name in Google Search Using JSON-LD in SuiteCommerce Microsites
Workflow Field Shows Continuous Loading Symbol When Setting Current Record Value
In a NetSuite workflow, when trying to set a Transaction List/Record field value using Current Record, the field shows a continuous loading spinner and does not populate as expected. Root Cause: This issue typically occurs when the workflow attempts to set the field value dynamically without properly resolving the internal ID of the current record.… Continue reading Workflow Field Shows Continuous Loading Symbol When Setting Current Record Value
Why Vendor Bills Sometimes Show Unexpected GL Accounts – Mixing PO-Based and Manual Entries in NetSuite
Background In NetSuite, vendor bills can be created in two ways: Linked to a Purchase Order standalone Each method drives the GL impact differently, based on how NetSuite determines the appropriate account for each item line. Understanding this difference is critical for finance teams to avoid confusion or unexpected entries in the general ledger. What’s… Continue reading Why Vendor Bills Sometimes Show Unexpected GL Accounts – Mixing PO-Based and Manual Entries in NetSuite
Automatically Email Customers Only When Sales Orders are Created and Fulfilled
For customers to automatically receive email of sales orders only when created and fulfilled, perform the following: Setup Navigate to Setup > Company > Email Preferences. On Transactions section, check CUSTOMER DEFAULT TO EMAIL TRANSACTIONS. Click Save. Navigate to Lists > Relationships > Customers. Click Edit next to the customer record Click Preferences tab, uncheck EMAIL in the SEND TRANSACTIONS VIA section. Click Save. 2. Customize Sales Order Form and Cash Sales Or Invoice form Cash Sales or… Continue reading Automatically Email Customers Only When Sales Orders are Created and Fulfilled