Has anyone ever created a analytics dataset that i...
# suiteanalyticse
Eric Schultz
06/14/2021, 8:58 PMHas anyone ever created a analytics dataset that includes a sales orders billing schedule?
Trying to creat a workbook that can show sales order billing per month and amount. The info I need is in the billing schedule but I can’t seem to find how to access it in the dataset
đź‘€ 1
Eric Schultz
06/15/2021, 7:00 PMFor anyone interested, I reached out to Netsuite Support about this and this is their answer:
Currently, the ability to show the Next Bill Dates and Amounts in transaction search and reports is under Enhancement # 156014. I will attach your case to the said enhancement so you can vote for it.
m
michoel
06/15/2021, 8:05 PMI believe there is a report that can expose billing schedules but not possible via saved searches or analytics.
e
Eric Schultz
06/16/2021, 4:22 PMyes you can do it through a forecasting report which is what i did in the mean time. What would be nice is to pull that into Analytics for Graphing purposes and dashboard views
j
Josh_SatoriReporting
06/16/2021, 8:12 PMWith Satori Reporting you have unlimited joins across the NetSuite data to solve problems like these.
m
michoel
06/16/2021, 8:59 PMCan it access billing schedules? It's no a joining issue AFAIK. They are not exposed to saved searches.
j
Josh_SatoriReporting
06/16/2021, 9:12 PMThere are multiple ways to tackle that, yes 🙂
b
battk
06/17/2021, 2:27 AMlook on the transaction line join for the billing schedule
battk
06/17/2021, 2:29 AMi do not envy trying to recreate the schedule's dates and amounts from that data
m
michoel
06/17/2021, 2:47 AMYeah the dates/amounts is what I needed