Here are a list of the questions sent out during the webinar and the answers that were provided.
You can also check out the replay by clicking on this link.
Are Custom fields available in Reports? If yes where do we find the custom fields?
Yes, These are available in the reports, normally it is in the subfolder of add fields under Edit Columns section of the report
Can you explain how to do report of cost of items in analitycs please
You can refer to SuiteAnswers ID 82339 - SuiteAnalytics Workbook Tutorial
Can Cash flow report be customized to show the weekly comparison?
Yes, this is possible, you can utilize the Alternate Date Range Type to Relative to Report Date and set Alternate Date Range to (Custom) and select the dates. Please take note that the Report by Period should be set to Never if you want it to become weekly
Can I embed queries in MS Excel and query my NetSuite instance via ODBC or other dynamic connection?
Yes, you can do so. Refer to SuiteAnswers Article 69815
Can I write custom reports and embed in Excel
You can export a saved report as an Excel Web Query. When the report is exported, data can be refreshed from within Microsoft® Excel with the latest information from your NetSuite account.After the report runs, select Export-Excel Web Query in the footer. The report is saved as an .iqy file. In the File Download window, you can click Open or Save if you are running on a PC.
Can reports be formatted with custom HTML/CSS formats like saved searches?
This is currently a limitation and being tracked in Enhancement 119295
Can we bring statistical accounts in formulas of a custom reports?
Upon further checking the ability to add custom formula in the Report Builder is still an Enhancement and is logged under Enhancement 76804 Formulas - Add search-like formula capabilities (SQL) to report builder (report customization) with no limit on elements or operators.
Can we combine two data bases e.g. customer master and Sales GL or item master and create a report?
Combining of data is not possible. You can do this however on SuiteAnalytics wherein you can combine 2 or more Datasets into one Workbook.
Can we combine two differents reports in order to get Invoice due and invoice paid?
You may create a Saved Search instead. You may follow SuiteAnswers 80915 as a guide.
Can you add sales order number to a commission report?
You can refer to SuiteAnswer Article 89181. Commission Overview Report with Sales Order Number for the detailed steps on how you can achieve this.
Can you customize a report to present down instead of across?
You can try moving the columns and using "Group with previous column", however this may not be always applicable for example on Aging Reports this is not possible.
Can you please demo a YTD monthly sales report per customer to see fluctuations in sales?
You may refer to SuiteAnswers ID 86612 Sales Report > Comparative Fiscal Date Ranges that you can use as a guide.
Can you reference a saved search in a report?
Unfortunately this is not possible. Possible alternate solution, is to rebuild the Saved Search using the SuiteAnalytics then you can create a Workbook so you'll have more options on building your report interface.
Can you remove the $ sign from all standard reports?
You can customize your report and uncheck the Show Currency under the More Options section of the report. Please check SuiteAnswers ID: 7626
Can you save reports that you use often on the dashboard?
Currently, only saved searches can be added on the Home dashboard using a Custom Search portlet. Adding reports to dashboard is currently a system limitation and is logged under Enhancement 93978: Key Performance Indicator > Use Custom Reports or Saved Reports.
Can you schedule reports to be run and send by email at specific date?
How are we able to create a more complicated report likr a rolling 12 report and/or Debt convenat report?
Creating Rolling 12 reports is currently a limitation of NetSuite, tracked under Enhancement 405157 while Debt Covenant Reports can be created via Financial Report Builder.
How can I sort the data in a report?
You may add fields on the Sorting tab of the Report Builder.
How can we group saved reports? Say we have multiple Income statements, can we group this into 1?
The ability to group saved reports is currently a system limitation logged under Enhancement #115393 : Saved Reports > Allow Users to Categorize Saved Reports; assign to Existing Categories/Folders and/or create new Categories/Folders.
How can we set the viewable Saved report so you only see reports relevant to you without impacting view of others?
A feature to address this is currently logged under Enhancement # 456527 Reports > Saved Reports > All Saved Reports > Have the ability to sort Saved Reports into different lists/folders. As an alternate solution, you may utilize naming conventions when customizing the titles of your Saved Reports so users can easily find reports relevant to them.
How can you create a more complex report with using more than one formual?
The use of formula within a formula is not yet possible in Reports. I suggest you explore Saved Searches or SuiteAnalytics.
how can you easily determine what field is the "right" field?
As one of the tips mentioned during the webinar, you have to familiarize yourself on where the data lives. Check the transaction record and fields that you need to show on the report.
How can you set up a report to automatically run daily or weekly?
When viewing a report, you can click Schedule (Calendar icon) in the footer of the report to create a schedule to automatically email the report. Schedules can be created for standard and saved reports and can be sent to other users. Check SuiteAnswers 8393 for more information.
How do I create a Balance sheet with current month and prior 3 months? the standard reports either shows all periods or just the current period.