Understanding the Issue: When creating NetSuite PDFs, you may encounter a common problem where the text within table cells becomes stretched or uneven. This occurs due to the default justification behavior of NetSuite’s BFO (BFO Framework) rendering engine. The Solution: Overriding Default Justification To prevent text stretching and ensure a clean, consistent appearance, we need… Continue reading Fixing Stretched Letters in Tables
Month: September 2024
Impact of Core Web Vitals on SEO Performance
What are Core Web Vitals? Core Web Vitals are a set of specific factors that Google considers important in a webpage’s overall user experience. They are a subset of Web Vitals, which are quality signals that are essential to delivering a great user experience on the web. The three Core Web Vitals are: 1. Largest… Continue reading Impact of Core Web Vitals on SEO Performance
Exclude Assembly Components from the Open Sales Order Report
Scenario Exclude Assembly Components from the Open Sales Order Report Solution To create the report: 1. Navigate to Reports > Order Management > Open Sales Orders > Customize. 2. Provide a Name for the report. 3. Click on Edit Columns link. 4. Expand the Open Sales Order folder, then the Item folder. 5. Insert the… Continue reading Exclude Assembly Components from the Open Sales Order Report
Create a Sales Order Report Showing Combined Data Found in Open Sales Order Report and Sales Back Order Report
Scenario It is possible to customize the Open Sales Order Report to show the details of the Back Order Report. Below are the steps to create the report: Solution 1. Navigate to Reports > Order Management > Open Sales Orders Report > Customize 2. Under Edit Columns add the following fields: a. Expand Open… Continue reading Create a Sales Order Report Showing Combined Data Found in Open Sales Order Report and Sales Back Order Report
Saved Search to show Quantity Sold for an Item, whether it was sold individually or as a Member of an Assembly or Kit Item
Scenario Create a report that will display the total number of items sold whether or not they were sold individually or part of a kit or assembly with additional columns that shows item sold per month. Solution 1. Navigate to Reports > Saved Searches > All Saved Searches > New 2. Click Transaction 3. Search Title : Enter Title 4. Click Criteria tab 5. Click Standard subtab 6. Filter: Select Type 1. Type :… Continue reading Saved Search to show Quantity Sold for an Item, whether it was sold individually or as a Member of an Assembly or Kit Item
ETL Tools for NetSuite
When working with NetSuite, several ETL (Extract, Transform, Load) tools can help facilitate data integration and migration processes. Here are some popular ETL tools compatible with NetSuite: 1. Dell Boomi A cloud-based integration platform that allows for easy data integration between NetSuite and other applications. Offers pre-built connectors for NetSuite, making it easier to automate… Continue reading ETL Tools for NetSuite
Javascript function to flatten nested arrays into a single array
Use Array.prototype.flat() to flatten nested arrays into a single array JavaScript sample const nestedArray = [1, [2, [3, 4]]]; const flatArray = nestedArray.flat(2); console.log(flatArray); // Output: [1, 2, 3, 4]
Parsing and Formatting Dates in NetSuite Using the N/format Module
NetSuite’s N/format module provides useful functions for handling dates, making it easy to convert between string and date formats. The format.parseDate() function converts a date string into a JavaScript Date object based on the user’s date format preference. Conversely, format.formatDate() takes a Date object and converts it into a formatted string. Example: define([‘N/format’], function(format) {… Continue reading Parsing and Formatting Dates in NetSuite Using the N/format Module
Prioritize Web Orders Over Sales Orders Entered via UI When Doing Bulk Fulfillment
Scenario User would like to prioritize Web Orders over Sales Orders created via user interface (UI) when doing bulk fulfillment. The Source Field is not available as an Additional Filter when customizing Fulfill Orders page. Since Web Orders automatically generate a Confirmation Number and there is no preference set to disable this. By default, the Confirmation Number of the Web Order is displayed under the Memo column of… Continue reading Prioritize Web Orders Over Sales Orders Entered via UI When Doing Bulk Fulfillment
Verification of Data migration
Verifying data migration in NetSuite involves several steps to ensure that data is accurately and completely transferred from the source system to NetSuite. Here’s a comprehensive approach: 1. Define Migration Scope Identify which data entities (e.g., customers, vendors, items, transactions) will be migrated. Document the source data structure and the mapping to NetSuite fields. 2.… Continue reading Verification of Data migration