Overview: This article explains the logic and automation implemented to create Item Receipts from Purchase Orders (POs) in NetSuite only when items are marked as Fulfilled/Received. This ensures that receipts are not created for items that are not physically received or flagged for receipt. Business Requirement: When a new Purchase Order is created, the system… Continue reading Automating Item Receipt Creation Based on ‘Fulfilled/Received’ Preference in NetSuite
Category: NetSuite ERP
NetSuite ERP
FIND NUMBER OF DAYS TILL DATE FROM A GIVEN DATE IN ANALYTICS
Suppose you have a field in a record which displays date for a perticular event/process. You are required to prepare a report using workbook in which one of the fields is days since the date given in the corresponding record. Say for example) In the sales order record, Order Date = 23-May-2025. I have to… Continue reading FIND NUMBER OF DAYS TILL DATE FROM A GIVEN DATE IN ANALYTICS
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
Boomi for Integration and EDI SuiteApp
Boomi’s integration platform as a service (iPaaS) seamlessly extends the NetSuite platform by connecting any combination of cloud and on-premises applications to automate business processes – without software, appliances or coding. Integration, Master Data Management, API Management, ETL and EDI are all available from Boomi’s 100% cloud-based, scalable and easy to use platform. Find out… Continue reading Boomi for Integration and EDI SuiteApp
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
Display Workflow Details in Saved Search Results
Scenario When a workflow is used on a record, various details, such as Workflow Name, Current State, Date Entered Workflow, Date Entered State etc., can be found under the Active Workflows subtab of the record. It is also possible to display these details in a Saved Search results using the Workflow fields… (e.g. Workflow :… Continue reading Display Workflow Details in Saved Search Results
COA File Analysis in NetSuite (with Intercompany Transaction Considerations)
In a NetSuite OneWorld environment, the design and configuration of the Chart of Accounts (COA) directly impacts how transactions—including intercompany transactions (ICTs)—are processed and reported. A properly structured COA is essential to ensure that all subsidiaries can operate independently while still allowing for unified, consolidated financial reporting. 🔹 1. Understanding the Role of a Common… Continue reading COA File Analysis in NetSuite (with Intercompany Transaction Considerations)
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
Transaction Line Distribution SuiteApp: Identifying and Resolving Cause of Erro
After installing the Transaction Line Distribution SuiteApp, A/P clerks experienced script error preventing access to Vendor Bills and working with Purchase Order. It keeps displaying error: “SSS_SEARCH_ERROR_OCCURRED Search error occurred: Record ‘customrecord_vid_template’ was not found”. However, once SuiteApp was uninstalled, both A/P and PO functionalities returned to normal. The Administrator ensured that all prerequisites and installation instructions were… Continue reading Transaction Line Distribution SuiteApp: Identifying and Resolving Cause of Erro
Types of Workflow Release Statuses and Their Functional Significance
In the workflow, there are four different release statuses. Suspended In suspended status, no new instances of the workflow are created, and no existing instances of the workflow are executed. If the workflow includes scheduled workflows, transitions, or actions, none of them will be executed. When an active released workflow is suspended, all the active… Continue reading Types of Workflow Release Statuses and Their Functional Significance