To schedule a report in NetSuite, follow these steps: 1. Navigate to the Report: Go to Reports > Saved Reports. Select the report you want to schedule. 2. Customize the Report (Optional): If you need to customize the report before scheduling, click Customize. Make the necessary adjustments to filters, columns, and other report settings. Save… Continue reading Automate report sending by Scheduling the Report
Month: August 2024
Custom Role with Full Import CSV File Permission Unable to Select Custom Record as Import Type
Scenario User is unable to select Custom Record as Import Type with Full Permission on CSV and Custom Record. Solution Login as the Administrator Go to Setup > Users/Roles > Manage Roles Custom Role: Click Edit Click Permissions tab Click Lists subtab Permission: Select Custom Record Entries Level: Select Full Click Save Note: Do not forget to logout and then log back in using the custom role in order… Continue reading Custom Role with Full Import CSV File Permission Unable to Select Custom Record as Import Type
Understanding SQL Joins
When working with relational databases, joining tables is a fundamental operation that allows you to combine data from different sources based on related columns. Each type of join serves a different purpose and understanding them is crucial for effective data retrieval and analysis. Here’s a detailed look at the different types of SQL joins: INNER… Continue reading Understanding SQL Joins
Pass variables with search column
“billLines” is an array of objects. function searchSupplierBooking(billLines) { try { let searchResult; let searchResultSum = 0; let billLinesArray = []; … Continue reading Pass variables with search column
Use the Subsidiary Navigator to Restrict Subsidiary Access
You can restrict your view to a particular subsidiary or group of subsidiaries. You can do this in one of two ways: Click a subsidiary from the portlet. Click the Change Subsidiary link below the centers tabs. By default, the system highlights the selected subsidiary and all of the sub-subsidiaries. To restrict or select all the subsidiaries… Continue reading Use the Subsidiary Navigator to Restrict Subsidiary Access
Key Differences between Saved Search and Query
Purpose: Saved Search: Used for repeatedly accessing the same type of information without re-entering search criteria. Query: Used to retrieve information based on dynamically defined conditions, either for a one-time search or for creating complex results. Flexibility: Saved Search: Fixed set of criteria that doesn’t change unless manually updated. Query: Criteria can be adjusted and… Continue reading Key Differences between Saved Search and Query
How to enable the NetSuite Support Login – Case Level Preference
To allow NetSuite authorized staff to access our account for case investigation, ensure both the company level NetSuite Support Login preference and the case level Allow NetSuite Login for this Case field are enabled. Company Level Preference: The NetSuite Support Login preference applies to all cases and takes precedence over the case level preference. Case… Continue reading How to enable the NetSuite Support Login – Case Level Preference
Container Queries in CSS
Container Queries in CSS are a powerful feature that allows styles to be applied based on the size of a parent container rather than the viewport. This makes it possible to create responsive components that adapt to their immediate environment, enhancing modular design and making layouts more flexible and maintainable. Key Concepts of Container Queries… Continue reading Container Queries in CSS
User Event Script to Detect Record Changes Using System Notes in NetSuite
/** * @NApiVersion 2.x * @NScriptType UserEventScript */ define([‘N/search’, ‘N/record’], function(search, record) { function beforeSubmit(context) { var newRecord = context.newRecord; // Ensure this script only runs on edit if (context.type !== context.UserEventType.EDIT) { return; … Continue reading User Event Script to Detect Record Changes Using System Notes in NetSuite
Optimizing Performance in Three.js with Instanced Meshes
Overview Instanced meshes in Three.js allow you to render multiple copies of the same geometry with different transformations (position, rotation, scale) in a highly efficient manner. This technique significantly reduces the number of draw calls, improving the performance of your 3D applications, especially when dealing with large numbers of identical objects. Key Features: Reduced Draw… Continue reading Optimizing Performance in Three.js with Instanced Meshes