Currently, there is no standard report that provides this information but the above data can be calculated by creating a custom Transaction Saved Search. Here are the steps: 1. Navigate to Reports>Saved Searches>All Saved Searches>New 2. Select Search Type: Transaction -Navigate to Criteria tab>Standard subtab>Filter column and add: Type = is Sales Order -Navigate to Criteria tab>Summary subtab and add the details below: Summary Type: Sum | Formula (Numeric) | Formula:… Continue reading Saved Search to Calculate for On Time Delivery Percentage on Orders Placed by Customers
Author: Karishma Krishnadas
Google Fonts API
How to use the Google Fonts API to add fonts to your web pages. You don’t need to do any programming; all you have to do is add a special stylesheet link to your HTML document, then refer to the font in a CSS style. A quick example Here’s an example. Copy and paste the… Continue reading Google Fonts API
Google Drive Integration Proposal
Proposal Summary Our proposal centres around seamlessly integrating NetSuite, a prominent cloud-based ERP system, with Google Drive, a leading cloud storage and collaboration platform. This integration aims to optimize document management processes, foster enhanced collaboration, and ultimately boost operational efficiency for businesses concurrently utilizing both platforms. Requirement The requirement is to establish a robust integration… Continue reading Google Drive Integration Proposal
Google Drive API Overview
The Google Drive API lets you create apps that leverage Google Drive cloud storage. You can develop applications that integrate with Drive, and create robust functionality in your application using the Drive API. You can use the Drive API to: Download files from Drive and upload files to Drive. Search for files and folders stored in Drive. Create… Continue reading Google Drive API Overview
Create and Save a File to the File Cabinet
The following sample shows how to create and save a file to the File Cabinet. In this sample, the folder ID value is hard-coded. /**@NApiVersion 2.1*/require([‘N/file’], file => { // Create a file containing text let fileObj = file.create({ name: ‘testHelloWorld.txt’, fileType: file.Type.PLAINTEXT, contents: ‘Hello World\nHello World’ }); // Set the folder for the file… Continue reading Create and Save a File to the File Cabinet
E-Document Standard Field is Missing in Customer Record in E-Document Tab
When Electronic Invoicing (Bundle ID: 116076) was installed, the user cannot see E-Document standard fields in Custom Forms even if it switched to Standard Form. Solution The installation of the bundle does not automatically expose the E-Document standard fields, but the following should be done. Navigate to Customization > Forms > Entry Forms Locate the Custom Customer Form being used > Click Edit Under Fields tab > E-Document subtab Mark Show for E-Document Standard Click Save
Formula to extract the domain from email:
Saved search formula to extract the domains from the emails. CASE WHEN INSTR({email}, ‘@’) > 0 THEN SUBSTR({email}, INSTR({email}, ‘@’) + 1) ELSE NULL END
E-Documents and E-Document Packages
The following topics describe e-documents and e-document packages according to how they are used by NetSuite and the Electronic Invoicing SuiteApp. E-Document An e-document is a NetSuite transaction represented as an XML or JSON document generated according to a specified standard. E-documents are transmitted to interested external parties, such as customers, vendors, or tax agencies.… Continue reading E-Documents and E-Document Packages
Purchase Order for Drop Ship/Special Order Unlinked from the Sales Order
The usual reason for the missing link is that the items either on Purchase Order or Sales Order have been changed. Compare the items of the Sales Order and Purchase Order. Look for the line item history if the item has been changed. To do this, click on the History link. The link can’t be retrieved anymore. However, user can perform the following alternate… Continue reading Purchase Order for Drop Ship/Special Order Unlinked from the Sales Order
QR code vs. barcode: what’s the difference?
Technically, a QR code is just a type of barcode There are two types of barcodes—one-dimensional and two-dimensional. And, two-dimensional barcodes are also divided into various types… with QR code being one of them. The one-dimensional barcode, or the Linear barcode, was first introduced to the manufacturing industry before the 2D versions. But because of its… Continue reading QR code vs. barcode: what’s the difference?