-
NetSuite Admin Tip | SuiteAnalytics Workbook to Identify Active Employees with Inactive Supervisor
In many organizations, the Supervisor field on the Employee record represents the reporting structure used for approvals, escalations, notifications, task ownership, and operational reporting. Over time, these reporting relationships can become outdated due to promotions, reorganizations, or employee terminations. One…
-
SuiteAnalytics Workbook error when adding formula referencing statistical accounts and consolidated
I’m building a Workbook to combine amounts from journal entries with quantities from statistical journals. Statistical accounts are aligned with corresponding GL accounts. The goal is an income statement by department that shows both expense amounts and related statistical quantities. Issue: When adding a formula to the…
-
Cannot load a dataset in script
Hello NetSuite Gurus, I tried to debug this script to load a dataset in Analytics: require(['N/query'], function (query) { try { var datasetId = '72'; // Load the dataset var dataset = query.load({ id: datasetId }); // Run the dataset var resultSet = dataset.run(); var results = []; var iterator = resultSet.iterator();…
-
SuiteAnalytics - Vendor rercord - field is1099eligible
Hi, I would like to know if the field is1099eligible (internal id is also is1099eligible) available in SuiteAnalytics/SuiteQL. This field is available in saved searches, but I cannot find it in SuiteAnalytics. The field is present in Vendor record. Thanks
-
Stop Rounding Qty in Workbook
We have a workbook which we use to find the available qty of various items and then use as an import for Inventory Adjustments. However, the values are rounding to two decimal places and we need the full number. For example 24.598 becomes 24.6 when we really need the 24.598. Is there a setting or something I can adjust to…
-
NSAW Joining Datasets
Hi, I am working in NSAW. I am struggling to join a NetSuite Purchase Order dataset with an Item Receipt dataset. I haven't been able to find any NetSuite UI related records fields, applying transaction fields like in a saved search, or related transaction previous/next like in a workbook. What is it called in NSAW? I need…
-
Hidden table in database
I notice some tables/data are not visible from Saved Search but it is shown in Analytics, such as "Budget Import" and "Inventory Assignment". May I know what is the reason they are hidden from Saved Search? How to enable to show it? I need to construct the Saved Search, pulling data out from these tables, use the web query…
-
MAX and SUM in Dataset for workbook.
Customer needs help with the below. Need to MAX the yellow highlighted items and SUM the green. This is a formula in the dataset.
-
NSAW - SuiteBilling
Customer is looking for suite billing data to be visible in NSAW, I couldn't able to get the details in documentation. Whether the standard setup of NSAW contains SuiteBilling data/dataset or whether customisation supported for this in case not loaded as standard.
-
Duplicate rows in workbook
Hello My target is to merge 2 datasets in one workbook, those 2 datasets are simple and contain: Item Name/Number: is the same for both data sets Location: is same for both data sets (and it is used as a filter) Total Quantity On Hand: is the same for both data sets Unit Price (a different level of prices) filtered by USD…