Author: Vachas Varghese

SuiteQL Query to Identify Items Frequently Sold Together

To identify items frequently sold together within a single sales order, the query performs two joins between the Transaction and TransactionLine tables. The first join (aliased as SalesOrderLine1) isolates orders containing a specified item, as defined in the WHERE clause. The second join (aliased as SalesOrderLine2) retrieves additional items included in those same orders. To… Continue reading SuiteQL Query to Identify Items Frequently Sold Together

SuiteQL for Retrieving Notes Attached to a Transaction

When working with transactions in NetSuite, it’s often important to access the notes associated with them—especially for audit trails, collaboration, or historical context. These notes are stored in the TransactionNote table and can be retrieved using a simple SQL query. ✅ Sample Query to Retrieve Transaction Notes SELECT TO_CHAR(TransactionNote.NoteDate, ‘YYYY-MM-DD @ HH12:MI PM’) AS NoteDate,… Continue reading SuiteQL for Retrieving Notes Attached to a Transaction

suiteQL query to get invoices by a date range

The SuiteQL query below returns all customer invoices issued in the past 30 days. SELECT Transaction.ID AS Invoice, Transaction.TranID AS InvoiceNumber, Transaction.TranDate AS InvoiceDate, Transaction.Entity AS Customer, BUILTIN.DF( Transaction.Entity ) AS CustomerName, Transaction.OtherRefNum AS CustomerPONumber, TransactionLine.CreatedFrom AS SalesOrder, BUILTIN.DF( TransactionLine.CreatedFrom ) AS SONumber, Transaction.Employee AS SalesRep, BUILTIN.DF( Transaction.Employee ) AS SalesRepName, Transaction.ForeignTotal AS TotalAmount, REPLACE(… Continue reading suiteQL query to get invoices by a date range

Resolve “This form is not available online” Error during Employee Creation

The issue may be related to the unavailability of additional user licenses for assignment to new employee records. You can verify the current license utilization by navigating to Setup > Company > View Billing Information and checking the count of Full Licensed Users. If the license capacity has been reached, consider revoking the ‘Give Access’… Continue reading Resolve “This form is not available online” Error during Employee Creation

Delete Inbound Shipment Records

Scenario: When attempting to delete an inbound shipment, a prompt message appears stating, “This record cannot be deleted because it has dependent records.” However, no dependent records are displayed, preventing their deletion. Solution: Possible dependent records linked to the inbound shipment may include WMS Open Tasks if the Warehouse Management System (WMS) is in use.… Continue reading Delete Inbound Shipment Records

suiteQL query to get the customer payment application details

This SuiteQL query returns the invoices to which a customer payment was applied. SELECT Invoice.TranID AS InvoiceID, REPLACE( BUILTIN.DF( InvoiceMainLine.CreatedFrom ), ‘Sales Order #’, ” ) AS SONumber, Invoice.OtherRefNum AS CustomerPO, PTLL.ForeignAmount AS AmountPaid FROM Transaction AS Payment INNER JOIN TransactionLine AS PaymentLine ON ( PaymentLine.Transaction = Payment.ID ) AND ( PaymentLine.MainLine = ‘F’ )… Continue reading suiteQL query to get the customer payment application details

SuiteQL query to get company contacts

The SuiteQL query below returns all of the contacts associated with a specified company. SELECT Company.ID AS Company, Company.EntityTitle AS CompanyName, CompanyContactRelationship.Contact, BUILTIN.DF( CompanyContactRelationship.Contact ) AS ContactName, CompanyContactRelationship.Role, BUILTIN.DF( CompanyContactRelationship.Role ) AS RoleName FROM Entity AS Company INNER JOIN CompanyContactRelationship ON ( CompanyContactRelationship.Company = Company.ID ) WHERE ( Company.ID = 2707 )

SuiteQL query to get the Customer Deposits

This SuiteQL query below returns all deposits received for a specific customer. SELECT Transaction.ID AS Transaction, Transaction.TranID, Transaction.TranDate, BUILTIN.DF( Transaction.Entity ) AS Customer, BUILTIN.DF( TransactionMainLine.CreatedFrom ) AS SalesOrder, Transaction.ForeignTotal, BUILTIN.DF( Transaction.PaymentMethod ) AS PaymentMethod, Transaction.OtherRefNum, BUILTIN.DF( Transaction.Status ) AS Status FROM Transaction INNER JOIN TransactionLine AS TransactionMainLine ON ( TransactionMainLine.Transaction = Transaction.ID ) AND (… Continue reading SuiteQL query to get the Customer Deposits