Hey all, does anyone know of a way to get around the 1000 character limit on saved search results? I'm trying to find any item records where a certain field's value is > 2000 characters long, but I get no results because Netsuite truncates the field to 1000 characters. I have tried getting around this by adding in a formula field and getting the substring of the field from character 2000 onwards, but that doesn't work either.

Hi all! Hope you're having a wonderful day. I have an issue when creating an Item saved search. When attempting to list all components within an item group, it seems as though all the components do not list down. This happens only when the component is the same ID as the one shown. Please find below a screenshot of an example of my saved search criteria. Is there anyone out there to guide me through this one? #help #suiteanalytics #question #plzzzzz

Any good ideas for emulating/doing select distinct({lineuniquekey}) in a saved search without using summary?

Does anyone know how to do this in a Formula Currency Column on saved search?

CASE WHEN {percentfield} IN 11.0% THEN {amount} ELSE 0 END'

I have tried converting using

TO_CHAR TO_NUMBER

but i cannot get it show the amount. it's always 0

I am assuming it is due to the percent field and netsuites funky way of dealing with that field.

Ignore me! TO_NUMBER converts it to 0.11 haha

Hi Guys, I’m trying to convert a value which is -ve in the line level but showing +ve in the search! So I’m trying to show that as negative using below! but still it is showing me +ve value! please advise! CASE WHEN {custcol_tdsapply} = ‘Yes’ THEN -1*{amount} ELSE {amount} END

Has anyone ever created a analytics dataset that includes a sales orders billing schedule? Trying to creat a workbook that can show sales order billing per month and amount. The info I need is in the billing schedule but I can’t seem to find how to access it in the dataset

Has anyone seen a tool that connects SuiteAnalytics Workbook to Excel?

Hello all, I am looking to create a saved search Inventory items sold count for 30 days, 60 days ,90 days, 120 days +. Is there any formula that can help to get the count for the required days only. I tried one formula for 30 days 'case when {trandate} >= ({today}-30) then {quantity} else 0 end' and it seems to work well. But did not found how it will work for 120+ days . Any help will be appreciated. Thanks!

Anyone able to help me with CASE WHEN logic. I get an error but cant see why...

CASE WHEN {totalprice}/({price}*{quantity}) THEN      '<div style="color:black;background-color:#CCB114;padding:5px;text-align:center;">' || 'ERROR' ELSE   '<div ></div>'     END

ODBC question: There is an Invoice transaction_lines row for an item, and another one just below it in the UI for a "Promotional Discount" with 7% in the item_unit_price. How do I link a discount to which item it goes to in transaction_lines?

Hi folks, I'm trying to create a saved search to show if there are sales orders with duplicated items, I added the following columns: My idea is that the search shows how many items there are of each part number, but I only see results like this: Does anyone have an idea if I can create a saved search to show how many items there are of each part number?

Does anyone know how to gracefully print out a pivot table from an Analytics workbook? Browser Ctrl-P isn't good enough.

I don't think you can do anything outside of NS gracefully with pivot tables. I know that exporting them is one of the top requests, but I've found them to be great in theory, but lacking in execution. "Soon" has been the response for quite a while.

@Mark C Thanks. Thats what I've been experiencing as well. They get you 80% of what is needed...

I think you're being generous with 80%

I'd like to be able to do math on pivoted data too.

Hello guys, ODBC question: Does NetSuite have Entity relationship diagram for custom fields?

i want to report on sales for the last 13 whole months. ie, if today's date is 2021-06-25, i want all sales from 2020-05-01, up to and including today. any tips on achieving this?

but those dates should be dynamic. as in recalculate based on the date you run the report

is there any way in analytics to show the month name when columns are grouped by month? https://imgur.com/a/jOe4H3o

I solved it by making a calculated to_char field, format YYYY-MM

If field on a custom record is sourced from another record, such as employee, can I see the employee name in a suiteanalytics dataset without doing a join? Meaning, is there an equivalent of BUILTIN.DF directly in the datasets and/or workbooks, or do I have to manually join?

Anyone got a tip for getting an Item's COGS Account to appear in a saved search? COGS Account is not available on the drop down not does {cogsaccount} return through a formula.

!

Hey everyone, We are working on building a connector to retrieve NetSuite data for reporting and analytics purpose.  As SuiteQL works with the analytics data source and the data source can be accessed by both REST web services and SuiteAnalytics Connect, we are evaluating choice of integration channel for the connector. Based on the various discussions we have seen, SuiteAnalytics Connect service beats mediums in terms of performance and throughput, but has anyone evaluated it against REST web service. REST web service will have better availability and reach as the feature available free and apart from query support if offers record CRUD feature as well. TIA

For those interested... Webinar: NetSuite + Power BI = Actionable Reporting to Improve Profitability Stop Leaving Margin on the Table by Not Knowing Your Detailed Profitability In this webinar you will learn: -Driving actionable customer and item profitability through analytics -Accelerate decision-making through pre-built, automated, and intelligent reporting -Gaining transparency with drill-back to source system details Register Here: https://lnkd.in/ghSdbsc

Hi all, is it possible to filter a custom saved search on the Project Dashboard to show only data related to the chosen Project on the Dashboard?