When managing vendor pricing in NetSuite, users often encounter two different fields: Purchase Price from the Item Record (Vendor Sublist) Vendor Price from the Vendor Record (Item Sublist) This article explains the differences between these fields and how they impact purchasing transactions. Key Differences Feature Purchase Price from Item Record Vendor Price from Vendor Record… Continue reading Purchase Price (from Item Page on Vendor Line) vs Vendor Price (from Vendor Page on Item Line)
Author: Aleen John
Drag-and-Drop Field Missing in Account After NetSuite Upgrade 2025
File drag and drop has stopped working, I know that this is because of the obsolete javascript library. The latest version 2.12.0 of the File Drag and Drop bundle 41309 is currently being deployed to all accounts.
Customer statement email Proposal
Requirement Client has requested an automated email process for sending account statements to customers with specific requirements. They need the system to send statements only to customers with outstanding balances and automatically include open invoices in the statement. Additionally, they require the ability to pause the email automation, similar to the existing overdue invoice… Continue reading Customer statement email Proposal
Created Date of corresponding sales order
Here’s how you can use search.lookupFields in SuiteScript 2.0 to retrieve the created date of a Sales Order associated with a given Invoice. define([‘N/search’], function(search) { function getSalesOrderCreatedDate(invoiceId) { try { // Lookup the ‘createdfrom’ field of the Invoice var invoiceData = search.lookupFields({ type: search.Type.INVOICE, id: invoiceId, columns: [‘createdfrom’] }); var salesOrderId = invoiceData.createdfrom[0] ?… Continue reading Created Date of corresponding sales order
SuiteQL: Retrieve Top-Selling Items
SELECT item.itemid, SUM(transactionlines.quantity) AS total_sold FROM transaction INNER JOIN transactionlines ON transaction.id = transactionlines.transaction INNER JOIN item ON transactionlines.item = item.id WHERE transaction.type = ‘SalesOrd’ AND transaction.status = ‘SalesOrd:B’ GROUP BY item.itemid ORDER BY total_sold DESC LIMIT 10; Identifies the top 10 best-selling items based on quantities sold (SUM(transactionlines.quantity)). Filters billed sales… Continue reading SuiteQL: Retrieve Top-Selling Items
SuiteQL: Join Tables-Transactions and Items
SELECT transaction.tranid AS sales_order, item.itemid AS item_name, transactionlines.quantity AS quantity_sold FROM transaction INNER JOIN transactionlines ON transaction.id = transactionlines.transaction INNER JOIN item ON transactionlines.item = item.id WHERE transaction.type = ‘SalesOrd’ AND transaction.trandate BETWEEN {today}-90 AND {today}; Combines data from transaction, transactionlines, and item tables using INNER JOIN. Fetches sales… Continue reading SuiteQL: Join Tables-Transactions and Items
SuiteQL: Parameterized Query Example
SELECT entityid, email, phone FROM customer WHERE id = {customer_id}; A parameterized query that dynamically fetches data for a specific customer using customer_id. Retrieves entityid (customer name), email, and phone.
SuiteQL: Filter Transactions by Date Range
SELECT tranid, entity, trandate, total FROM transaction WHERE type = ‘SalesOrd’ AND trandate BETWEEN {today}-30 AND {today} ORDER BY trandate DESC; Retrieves all Sales Orders (type = ‘SalesOrd’) created in the last 30 days. The trandate filter ensures only transactions within the specified date range are included. Results are sorted in descending order of trandate,… Continue reading SuiteQL: Filter Transactions by Date Range
SuiteQL: Retrieve all customers’ names and email addresses.
SELECT entityid, email FROM customer WHERE isinactive = ‘F’ ORDER BY entityid ASC; This query retrieves all active customers (isinactive = ‘F’). It selects the entityid (customer name) and their email. The results are sorted alphabetically by entityid using ORDER BY ASC.
File Types Recognized in the File Cabinet
You can upload any type of file to the File Cabinet. The Documents pane shows the file extension and lists the file type. The following file types are recognized in the NetSuite File Cabinet: Unrecognized File Types Although NetSuite accepts all file formats in the File Cabinet, if a file format is not recognized, the… Continue reading File Types Recognized in the File Cabinet