Anyone know the URL parameter name for "Item On Any Line", or how to get it to show as a filter on a transaction search?

For NetSuite reports, are we not able to use "and/or" conditions in the Filters section? I'm looking to add (entity is not empty OR entity (line) is not empty) to a report. Is this possible?

Is there a setting or permission to have a custom record available in datasets? Quite a few of my custom records aren't shown in Analytics

Hello! I am Petr, Product Manager from NetSuite SuiteAnalytics team. I am trying to find out what is the experience with Dataset cache feature in NetSuite we introduced to address long execution time of datasets and workbooks. I would love to hear if you find it useful or if you are even aware of this feature or how could we make it better so it better fits your needs.

👍 Useful

ablobnogood Not happy with it

ablobthinking Not aware

Don't hesitate to leave a comment with details or reach out to me directly and we can discuss, thank you! 🙂

Would anyone happen to know how to get the Income, Asset or Expense/COGS account in a Saved Search except with the parent hierarchy? Such as “Cost of Goods Sold : Product Cost” instead of “Product Cost”? There is this information: http://www.netsuiterp.com/2019/06/csv-import-to-update-cogs-account-on.html Perhaps there is a setting I can toggle temporarily to have the searches return differently?

Better yet if I can return the Internal ID of the accounts?

I figured it out, Formula (numeric) with for example {incomeaccount.id}

One of my clients is trying to run a balance sheet with consolidated entities. They want to show only certain consolidated entities, each in its own column, with none of the actual underlying entities. Has anyone does this before?

Is there a way to get the available quantity of a kit in suite analytics? I can't even figure out how to get inventory location data.

Does anyone know why some employee list custom fields don't allow filtering on the full list? I've got a custom dropdown field that is the employee list, but when I try to add the custom field to my saved search as an available filter, the only options in the dropdown are All, Unassigned, Mine. I want to be able to select an individual name.

I am trying to pull in the specific Installment Amounts and Due Dates from an Invoice in a Transaction Detail Data Set and Im unable to locate these fields. Any one have any recommendations?

I've got a free-text field imported as Jan 04, 2022. In a saved search the formula(date) = TO_DATE('Jan 04, 2022','Mon dd, yyyy') returns 04/01/2022 as expected. If I change to the source field name formula(date) = TO_DATE({custrecord_date},'Mon dd, yyyy') returns ERROR: Invalid Expression any insights?

Any trailing spaces?

You might also consider using trim or something to that effect on it

Trying to show sales by customers using dates. But the report doesn't run, throws Report Execution Error. Two key dates, customer account created 'after' date and those sales 'after' then on. What might be the issue?

What's the trick for clearing up negative results on line level transfer order searches? COGS line, Tax Line, and Shipping Line don't appear to work in this case.

Has anyone been able to add a running total column into a SuiteAnalytics workbook? I've added one to Saved Searches before, but the same syntax is not working in a SQ dataset. Anyone have any tips on getting this to work? #general

Is there a way to create a pie chart in NS?

howdy - anybody know off hand if it’s possible to get a search that you’re using for a trend graph to show future-dated transactions? Apparently they just run up to ‘today’ then stop but client is enters future-dated orders and wants them included. ideas welcome

Is it possible to add an internal ID to the formula fields created in a workbook? Besides a name. It seems NS defaults them to null, and that causes issue with another integration.

Yup you can do this with an analytics dataset

@here I am looking for a solution probably wherein I can add the total of all the vendor bills in a month. What formula can I add since sum doesn't work. Any help will be great ful

Anyone know how to get currency symbols to appear next to dollar amounts on an aging report? In our sandbox, the currency symbols are showing but the same report in production does not show the currency symbols anymore. SuiteAnswers says there should be a "Show Currency Symbol" checkbox on the "More Options" page, but I don't see it.

How can I sort by Period Name in a workbook but it be done by date and not alpha?

Is it possible to join two Datasets, in the similar vein of Excel vlookup?

i m still not sure how to join the transaction line for the bill on the PO this is what I have so far

SELECT
transaction.ID as transaction_id,  
transactionLine.ID as transactionLine_id, 
transactionLine.item as item_id,
transactionLine.custcol6 as po_number,
FROM transaction
JOIN  transactionLine ON transaction.ID = transactionLine.transaction
 WHERE transaction.ID = 13636399 AND transactionLine.item  IS NOT NULL

I have a dataset for transactions that includes criteria and columns for the transaction line. That means multiple rows returned for a single transaction. In the workbook I'd like to display the transaction and a count of lines. A pivot chart seems like the way to do that. Unfortunately the pivot chart takes about 10 minutes to run for the dataset of about 140 lines. That type of performance makes pivots unusable. Any other options or ideas?

Hi all. Is it possible to get the values of the Pemission sublist in the Custom Record Types using SuiteAnalytics? I'm not seeing any sublists in the Custom Record Types data set.

Am I crazy? Is there really no way to search for customers with the ‘Print on Check As’ field set? You can do it for vendors using formula (text) = {printoncheckas} but if I do the same thing on a customer search I get Error : field not found….Hoping I’m just missing something obvious….

I am having problems trying to come up with a logic to create a search to display Items waiting to be putaway. Any suggestions?