-
Landed Cost per Item - Saved search/Analytics/ Report
Hi, my customer needs something to view the item cost, spliting the landed costs per item. Here is an example: Item 1: 26.75 - 17.00 PO cost + 7.65 duties+ 2.1 freight Item 2 : 26.78 - 18.25 PO cost + 7.65 duties+ 0.88 freight The items do not have serie/lot number so I dont know if it is possible to breakdown the landed…
-
Suite Analytics JDBC timestamp NullPointerException or Failed to retrieve data
I've connected to Netsuite via Suite Analytics JDBC connection in a Databricks cluster. I'm seeing a NullPointerException because of the lastmodifieddate column in my netsuite classification table (ie. if I do Select * from classification I see the NullPointerException and I've narrowed it down to seeing this issue because…
-
Monthly Closing Date Field in DOMO Writeback Connector
We have recently integrated our DOMO instance with our Netsuite Instance. In using the Domo Writeback Connector we have run into a seemingly mandatory customer field called “Monthly Closing Date” that we are not familiar with. Do you know what this field would be/what value we could use to write new customer data into…
-
Customer needs help with a formula in transaction dataset.
Need helping with MOD function where N1 and N2 are CASE WHEN ({transactionlines.transactionlinetype#display} = "Inventory Count : Count Quantity" THEN {quantity} ELSE END, {transactionlines.transactionlinetype#display} = "Inventory Count : Adjusted Quantity" THEN {quantity} ELSE END) Dataset is Transaction. Associated…
-
Applying Filters to Linked Datasets? (NetSuite Analytics)
Do filters not work with linked datasets in NetSuite Analytics? We are trying to compare Estimate $$ vs Sales Order $$ to get a better idea of how well our estimates are translating into sales, but whenever we apply a filter to the pivot table those filters never take effect. For example: Even though we have only two…
-
Suite Analytics Workbook: Inbound Shipments
Hi, I am starting with a purchase order. I am trying to get the related record of the inbound shipment so I can grab the expected ship date. I was verifying my results and I had noticed that there is an inbound shipment related to a purchase order in NetSuite but in the workbook there is no data showing that. Any idea why…
-
Analytics Workbook Send
Hi There I can see that Analytics workbooks are a scriptable record type (N/workbook module). However, I wanted to confirm if it is possible to script the workbook so that the data from this can be sent via email (as csvs)? I can only see the option to create or edit a workbook using suitescript. Is that correct? Thanks
-
Is there a way to copy or clone an existing Pivot Table in Suite Analytics?
I have built a pivot table in a workbook that has all the fields I like, and is laid out as I want with columns, rows and totals. Now I want to copy that pivit table as a new pivot in the workbook so I can change the filters on it for a different range of data . Is there a way to do that rather than re-create the pivit…
-
Recreating Trial Balance in Suite Analytics Workbook
Hello! I am essentially trying to recreate our Trial Balance in a Suite Analytics workbook. Mainly because we need to be able to group posting totals by every combination of column set in our export, which we can't do in native reporting. I'm using a Posting Account Activity dataset and I've been able to get the columns in…
-
How to take just the Country and State from the whole Address to add it for Chart in Workbook?
Suite Analytics - Data Set - How to take just the location from the whole address to add it for graph