If you’re looking to combine your love for gaming with a knack for tinkering, you’ve landed in the right place. Today, we’re pairing a game controller with an ESP32 using Bluetooth. That way, you can control all kinds of projects like robots, robot vehicles, animatronics, motorized props, or even cooler, a battle bot! In order… Continue reading Connecting controller to ESP32
Category:
Financial Report Totals Do Not Match Saved Search Results
Issue/Problem Statement: Users noticed that the totals in the Income Statement report do not match the results generated from a Transaction Saved Search built on the same criteria. This discrepancy is creating confusion during financial reconciliation and month-end closing. Symptoms: Report shows higher or lower revenue totals compared to a saved search. Transactions visible in… Continue reading Financial Report Totals Do Not Match Saved Search Results
Inbound Shipment in netsuite
Inbound shipments provide visibility of in-transit inventory and the status of a shipment. Items from multiple purchase orders can be assigned to an incoming shipment and bulk received and billed from within the record. The internal ID for this record is “inboundshipment”. An order is identified as an inbound shipment when a vendor packs the… Continue reading Inbound Shipment in netsuite
Mandatory Ship Date Selection During Checkout
During checkout we need for the user to create/select a future “SHIP DATE” with some sort of calendar style selection? This selection needs to be mapped to the field id on the SO called {shipdate}. We need the first available ship date that displays to be “4 business days from today” which could also be… Continue reading Mandatory Ship Date Selection During Checkout
To trigger the script on clicking “Mark Shipped” on Item Fulfilment record
context.UserEventType APPROVE CANCEL CHANGEPASSWORD COPY CREATE DELETE DROPSHIP EDIT EDITFORECAST EMAIL MARKCOMPLETE ORDERITEMS PACK PAYBILLS PRINT QUICKVIEW REASSIGN REJECT SHIP SPECIALORDER TRANSFORM VIEW XEDIT const afterSubmit = (scriptContext) => { try { let fulfillment = scriptContext.newRecord; … Continue reading To trigger the script on clicking “Mark Shipped” on Item Fulfilment record
Creating Valid Certificates for NetSuite OAuth 2.0 M2M Integrations
To create a valid certificate for OAuth 2.0 M2M (Machine-to-Machine) authentication in NetSuite, you need to generate a public/private key pair (certificate), upload the public key to NetSuite, and use the private key securely in your application or integration setup. Step-by-Step Certificate Creation Generate Key Pair Use OpenSSL to generate the keys by running: openssl… Continue reading Creating Valid Certificates for NetSuite OAuth 2.0 M2M Integrations
Create a Saved Search to Show Changes Made to a Role
Scenario A user wants to create a Saved Search to show the all the changes made to a role. Solution Navigate to Lists > Search > Saved Searches > New Search Type: Click Role Click Criteria Click Standard Filter: Select Custom Custom: Select Yes Click Set 5. Click Results 6.Click Columns Field: Select Name Select Permission Change Select Permission Change Level Select Permission Change Date 7.Click Available Filters Filter: Select Permission Change Date Show in Filter… Continue reading Create a Saved Search to Show Changes Made to a Role
Set preferences for Gift certificate authentication code
Go to Setup > Accounting > Preferences > Accounting Preferences. 2.Click the Items/Transactions subtab. 3.In the Other Item Preferences section, in the Gift Certificate Auth Code Generation field, select one of the following: System Generated – NetSuite generates an authentication code when a gift certificate is sold, requiring no manual tracking of codes. These codes can be long, but this is… Continue reading Set preferences for Gift certificate authentication code
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
Troubleshooting Gulp command failures in an SCA project
While working on a SuiteCommerce Advanced (SCA) project, we often use gulp commands such as gulp extension:fetch or gulp extension:deploy to manage and deploy extensions. However, a common issue that can arise is Gulp appearing to be installed, yet failing to execute properly—throwing errors like “Local gulp version unknown”. Uninstall the current Node.js version Remove… Continue reading Troubleshooting Gulp command failures in an SCA project