Hi,
We have a question on getting NetSuite data interfaced to Power BI using Suitetalk.
Our business is subscription driven and we want to create a dashboard on Monthly Recurring Revenue (MRR). Currently, we use the "Revenue by Item & Customer" report in NetSuite to calculate/report MRR. The default “Revenue by item & customer” NetSuite report is based on 2 tables: “Transaction Dimension” and “Account Balance”. Does anyone know how/where to get this data interfaced and with which key those table are linked?
While we've been able to retrieve some data using the SuiteTalk API, we are facing the following issues:
- RevenueArrangement endpoint is not available to us.
- We are using data from the JournalEntry endpoint, but it lacks item-level details, which are critical for our MRR calculations.
- We can retrieve item-level informationfrom Invoices endpoint, but we are struggling to figure out how to link invoices to the corresponding journal entries/revenue to create a complete dataset.
To conclude, we can interface quite some data with Suitetalk, however, the revenue arrangement number and Item information is lacking. Does anyone know what the best approach to this problem is. This might help to reproduce the report via a Power BI dashboard.
Thanks in advance.
Hans (FRISS)