In case you missed our NetSuite + Power BI webinar - here is a link... https://netsuite.satorireporting.com/satori-july-23-webinar/

Is there any way to look at an existing report and see what criteria was used to initially create it? (components, fields, etc)

Is there an NS_CONCAT equivalent for workbooks? I need to summarize amounts but need a list of all internalids for transactions as well. IN a saved search I'd try the NS_CONCAT approach

Join us tomorrow at 1pm for the first ever broadcast of our BUSINESS INTELLIGENCE WEB SERIES!!!! Can you tell I am pumped???? We will be walking us through how to address important data challenges with the GURUS Business Intelligence (BI) tool. https://gurussolutions.com/netsuite-business-intelligence-web-series

Would anyone recommend a good resource for learning NetSuite formulas? I'm a bit past the beginner stage but not by much. Would like to be as proficient as possible.

Best resource I use is the oracle help docs

It's important to know that you aren't doing a full query, and instead just a specific row

Hello, I'm trying to find where reports are stored in the database, is this the correct channel for that kind of question?

Well, the question is inherently flawed, but it is the right place to ask it

There is a page too view scheduled report results, which you can download it, but if you were trying to use the odbc connector there's no equivalent

Okay, so maybe a better way to ask is can I query the stored report parameters through ODBC? I don't need the report itself, I just need to know the all the parameters used to create a report.

is there a way to connect Criteria and Filter? i.e. on the Criteria I say I want to see items from Subsidiary X but when I add Item Filter in available filters, I can still see items from "All Subsidiaries", the result only shows me items based on Criteria but Filter shows me all Subsidiary items

I've found an excel formula that can accomplish what I need, but I'm curious if it can be done via saved search. I want to rearrange all characters in a field value so that they are in alphabetical order. For example: 'flashlight' and 'lightflash' would both end up being 'afghhillst'. With that result, I could then find "duplicates" that aren't necessarily something that can just be grouped and counted on in a saved search. Any ideas?

Any SuiteQL wizards know what would cause an error such as this? Essentially I'm trying to pull results for both a Sales Order and a custom record that have fields that share a Project number

SELECT transaction.entityid, transaction.tranid, transaction.job, customrecord_recordtype.custrecord_customfield FROM transaction LEFT JOIN transaction ON ( transaction.job = customrecord_recordtype.custrecord_customfield) WHERE transaction.id = '12345'

"custrecord_customfield" are technically 2 different fields, but just looking for anonymity. The error it gives me is "Duplicate data source reference: "TRANSACTION"

I've been told to add an 'Item Comparison is Match' to my Analytics workbook but I'm having a hard time locating it, can anybody point me in the right direction?

Does anyone have a search/report that shows inventory received not billled? I tried few SAs and all of them shows me incorrect values, it shows me pos that are billed and unbilled

#generalHas anyone been able to generate a saved search showing period/date mismatches. Can’t understand why I’m having such a hard time with this Any help would be appreciated

I have 8 custom fields on an item record. How can I get the values of these fields to be in one column in a saved search? And not like, concatenated. I'd want a separate row for each populated field on a record.

I have a saved search with the following criteria:

Type is Credit Memo
Main Line is True
Applied To Transaction is Invoice #XXXXXXX

And the following result columns:

Amount (Foreign Currency)

This search returns only one row and the value in that row is 2833.31. When I add a summary type of SUM to that column on the Results tab and run the search, the value is 5666.62. Anyone know why the value is being doubled when SUMming a single result?

anyone know how I can combine multiple datasets in one tab. Want to combine data from sales(invoiced) sales(ordered) and budget into 1 pivot table

On the open sales order report if the item is an assembly and the work order is open it shows all of the components, is this an expected behavior?

in Saved search, I want to take a field that is a number and convert to string, I've tried TO_CHAR(${field})

Anyone got 'NetSuite Analytics Warehouse' on 2021.2 Release Preview? It is in the Release notes and Help, but not on our account.

Using a scheduled script can I leverage the lastquantityavailablechange, a date range, and combine that with inventorylocation for a count of stock where the stock level has changed for a specific location? That is to say "Tell me the stock for item X at location Y if it's changed since I checked yesterday."

In my case saved search and I am getting data on related records. If the search returns 5 records, is it possible to restrict this to the last one created? I have a custom data completed field, which I can use, but not sure how to show the search return just one record.

I wanted to use the search in a script so just need to be sure i only ever get one record to work off - but not sure what formula might work!

I don't think I'm awake yet. Is there a way of getting the transaction total on an item saved search line when you're filtering out main lines (and also filtering out some of the transaction lines, so can't sum them)?