Hello! We are currently using fivetran to sync Netsuite Analytics data to our data warehouse using netsuite.com data source. In a current task I'm working on, I need to identify "Closed/Cancelled" transaction lines of a sales order. I can see the "Closed" flag field on NS, but I can't find it in the raw data extracted from NS. I can't find it amongst the Transaction Line fields setup on NS and not in the docs here . Any ideas how I can retrieve it? Thanks

Hi to all, I`m trying to create simple Transactions Report in Analytics module which will show for each transaction line (not only for Tax lines rows) 'Tax code', 'Tax Rate' and 'Tax Amount'. Any ideas?

Hi all, we have been working on an analytics/BI tool embedded in NetSuite to bridge the gap between NetSuite's reporting and moving to an external reporting environment like Tableau. Our tool is called NimbusDash and we are looking for ~10 beta testers that would be willing to test out the app in their NetSuite environment. We had great feedback from Slack testing out NimbusQL for us and were hoping the community here would help us out again. NimbusDash - https://nimbuslabs.com/nimbusdash/ If interested, please DM me. Thanks!

I have a saved search with a criteria set to 2 types - Invoice and Sales Order. I want a results column that gives me the count of only salesorder. I tried this formula with a Summary Type set to Sum but it is giving me 0 which I know is not correct:

CASE WHEN {type} = 'SalesOrd' THEN 1 ELSE 0 END

What is the correct formula to use?

Anyone used AnalyticsConnect JDBC to get a list of Contacts? There is this table netsuite.com/help/helpcenter/en_US/srbrowser/Browser2021_2/odbc/record/contact.html but that isn't peope, more like contain-points/interactions. The CUSTOMER table has TYPE= CONTACT which gives some data, but not all the native field ont he contact record are there, and there are no custom fields. I just cannot find the correct Table for Contacts!

Weird.. the

is1099eligible

checkbox is not exposed on the vendor table.. Has anyone else found a workaround? I can create a new custom field which sources from the 1099 checkbox, but I will need to load/save each vendor record to populate the field..

Does anyone know if you can connect to ODBC/JDBC without an active user license (only token based or other) @battk @Fred Pope

what is the equivalent of the gross_amount field from the transaction_lines table in the netsuite2.com connector?

Is there a way to audit workbooks and datasets? We need to know: who, when and what have been modified

Has anyone ever had luck using an analytic function like RANK or DENSE_RANK in a saved search criteria?

Hey all. If it's useful for anyone, a NS1>NS2 mapping file is here. Should be public, but let me know if you can't access. I realize this is somewhat duplicative of the sheet in SuiteAnswers, but I think there's some stuff here that's not in that spreadsheet, and last I checked that spreadsheet didn't have anything about the format changes in Transaction Type and Status fields. Note that this was just what I used for my own company, so I won't be able to help with anything that's not included here since I didn't have to find it. Disclaimer: this is not guaranteed to be correct, you should verify on your own, blah, blah, blah

I don't suppose anyone else has run into this? I'm trying to build a report out of our Data Warehouse based on the previousTransactionLink table, but they apparently sync it via data tools to a DW on Sunday mornings. Our weeks run Monday>Sunday, so ideally I'd like to shift it to be Monday morning if possible. Seems like probably not possible and if I want this, I'm going to have to manually sync it in our data transfer tool.

How to built pivot table for opening and closing balance against the customer? and what are the fields comes under the dataset?

Hi! I am facing an issue with PDFs downloaded from Reports in NetSuite using "Export - PDF" icon. In the downloaded PDF, the currency symbol is incorrect (Screenshot attached). The currency symbol should be "*ر.س*" but instead on downloaded PDF, it is ".." Any idea how we can resolve this issue and make the currency symbol "*ر.س*" appear on PDFs? Your help is greatly appreciated. Thank you.

Hello! I'm trying to remove the Parent Company of the financial reports PDFs and show only the subsidiary name, seems to be an enhancement. Is there any workaround?

Hi Everyone, I have a saved search on Sales Order transactions. In this search, I have a customer name like "123Test", but I want to remove the numeric part ("123") and display only "Test". Additionally, I want the name to remain clickable and link to the customer record. I am currently using the following formula: REGEXP_SUBSTR({entity}, '[A-Za-z].*')

Any points / experience you guys have on jdbc vs odbc for suiteAnalytics connect, what you prefer and why and any limitation to both?

I have given the following permissions in a role , assigned that rorle to an employee. And trying to query using jdbc/odbc connection. While doing the queries it says record not found error. If i add Custom Record Entries permission, I am able to fetch custom record data. But still unable to fetch data for tables like transaction, employee, customer, etc.

I've been trying to create a PO Report to show the related records in addition the amount paid and the amount remaining. The amount remaining & amount paid don't seem to work 😞

Hi all, I have an existing saved search for a custom record that is currently being summarized. I would like to know if there is a formula I can use to determine if any results share an arbitrary field text value. Essentially, I want a way to quickly find any duplicate hash values in this text field. Any thoughts on this?

Hey friends - I could have sworn I came across a SuiteAnswers article a long while ago that talked about how NetSuite generates the actual SQL query on the backend for saved searches. IIRC, it essentially said that the order of criteria shouldn't matter since it evaluates all your criteria and generates the most efficient version of that when doing the actual SQL query. I'm fighting with support about saved search performance and thus looking to reference this article. Can anyone point me in the right direction?

Has anyone successfully connected PowerBI to NetSuite using ODBC and been able to pull transaction data? Custom records seem to work fine, when when pulling in the transaction table, I am getting this error.

My mapreduce script code file starts (after the necessary NApiVersion and NScriptType tags) with:

define(["N/runtime", "N/search", "N/dataset", "N/record"], function(runtime, search, dataset, record){

When executing the line

const datasetObj = dataset.loadDataset({id: datasetId});

I get this error:

TypeError: dataset.loadDataset is not a function

But the NetSuite Help documentation shows this: dataset.loadDataset(options) Method Description Loads an existing dataset. Returns dataset.Dataset Supported Script Types Server scripts For more information, see SuiteScript 2.x Script Types. Governance 10 units Module N/dataset Module Sibling Module Members N/dataset Module Members Since 2020.2 Parameters Note The

options

parameter is a JavaScript object. Parameter Type Required / Optional Description

options.id

string required The ID of the dataset to load. So why is a function the docs say is there, not there? I'm going to use query.load() instead. That doesn't throw errors and seems to return all the dataset results into the map function

Hi, our accountant ask for adding column to existing Deferred / Capitalized Expense report. They need to see Amortization Schedule Name in report. I found start and end date, but where is the NAME?

Hello, does anyone know where I can start for reproducing the open a/r report in the suite analytics connector

Why do all invoice item quantities show as negative via the suiteanalytics datasource versus positive via saved searches?

I am very confused on Tax Codes. In the Records Browser and Connect Browser they seem to be a part of the Item record/table, but for saved searches they seem to be their own record type, and yet I can't find an internal ID for the Tax Code record type, because again, they seem like they're supposed to be a part of the item table. Is there no way to programmatically pull them via a pre-defined saved search because of this mismatch?

Hello, Are Events and Activity type of saved searches can be used for Key Performance Indicator? Checked SuiteAnswers, public Oracle-NetSuite documentation as well as Help topics and can't see a list of saved search types that is not supported. All my KPI and scorecards are fine except for Events and Activity type saved searches so was wondering if it's a limitation. Also couldn't find anything on SuiteIdeas.

I'm going to create a ticket for NetSuite, but has anyone that uses Suite Analytics Connect ODBC driver run across this oddity in the NS2.com data source? The SQL query results not making ANY logical sense?

Hi Guys! Do you know how to setup my ODBC Driver with OAuth2.0? Im wondering about the steps that I need to consider for in setting it up.