-
Two Datasets in Suite Analytics - BvA report
Hi, I have created 2 Datasets , the one is actual transactions and the second one is the budget transactions that was uploaded into NetSuite, I'm trying to connect them together in order to have BvA report with a drill down for Department, Account and Class, but it's not working , when creating a pivot - I'm getting an…
-
Expose Applying Transactions of WO's in Suite Analytics
Hi, I am trying to make a Suite Analytics dataset from the transaction Type = Work order, where i can see the Applying Transactions (being Work order completions and Work Order close). When I do this in a Saved Search, I get two lines: In teh saved search definition, I just requested the Applying Transaction and then i get…
-
Analytics Workbook - How to add payment amount?
Hi, I try to create full AR dataset that include sales order, invoices and payments. Could you please advise how to add that payment amount that related to the invoice? In the example bellow the report include 2 invoices, the fist order is open and the second order include one invoice with four payments. The expected…
-
SuiteBilling: Monthly Recurring Revenue Analytics Workbook empty
Dear Gurus, A few releases back NetSuite has added a SuiteAnalytics Workbook Template for SuiteBilling enabled accounts to report on MRR. The template contains a lot of very useful visualizations. However the dataset from the template seems to not return any results. I have digged deeper and noticed that it is based on a…