Here is the list of the questions sent out during the webinar and the answers that were provided.
Is there a way to get rid of currency sign on the complete report? Previosuly I had to go down the the line items level and modify from Currency to Number. . . format
You may unmark the Show Currency checkbox in the Financial Report Builder under Edit Layout for each of the Financial Rows.
You may also visit SuiteAnswers 8344 || Currency Symbols on Reports
How do I get the order of the Balance Sheet and Income Statement print in the order of accounts the way I want them which is not Alpha or Account number order. I want it the Income Statement to be in a more business oriented basis based on my client's business?
How do I get Undeposited Funds to be included in the ""Bank"" section with Checking accounts?
This requires customizing your report. You can follow this SuiteAnswers article for the detailed step
https://suiteanswers.custhelp.com/app/answers/detail/a_id/79145/loc/en_US
Will you please cover multiple outlets in the income statement - to show or not to show (consolidated)
you are able to change that by leveraging the ""Subsidiary Context"" tool of your Filters region
For showing zero rows, how would you modify it to just show particular rows - like instead of all zero rows, you only want to show a particular row whether it's zero or not?
For Show Zeros on reports, the preference if enabled will show zeros for all accounts included in your report. One way to remove the other rows in your reports with zero balances is to configure the criteria of the account section to exclude the specific accounts you have with zero balances.
To do that, click on customize in your report, enable the show zero preference and preview the report to note all the accounts you do not want to show up in the report.
Go back to customize and click on the account section for example income. And on the lower right side of the screen you should see the Edit Criteria button.
Click Edit Criteria and set the filter to account name or account number to exclude the accounts you don't want included in your report.
Can we build Cash/Bank receipts and payments report ---- 1. Left hand side all the receipts, right hand side all the payments. 2. left hand side all the opening bank and cash balances and receipts during a selected a period 3. right hand side all the payments during a selected a period and balancing figure will closing balances of all cash and Bank
Yes, it is customizable.
can you elaborate more please. probably an email ID will be good if provided.
You can look for the appropriate field under the fields section and add it. You have the option to rename it.
You can read the help, which tells you where the field is coming from. If that doesn't help, add the field and test it out.
Is there a way to build a report for ap summary showing the employee expense ?
We do have a separate reporting feature for AP summary, you can check it by navigating to Reports > Vendors/Payables > AP Aging
Is LCS virtual?
That's correct!
can you create reports with multiple comparison periods? i.e. Q1 Q2 Q3 Q4
Do mind if I ask, which specific report. So for instance, in the summary version of the income statement. There will already be a field call column.
how do you add a column for each period then? if i want to see a BS report that has a column for Q1, Q2 Q3 Q4 or by month for a certain period?
Yeah that is definitely an alternative
You should be able to select in the summary version of a report, choose column field. In the column field You should be able to select period, and if you extend the date filter you will be able to see multiple comparison periods.
Does FRB come standard with NetSuite?
Yes, Financial Report Builder is a standard feature in NetSuite.
What I generate a balance sheet for the year but wanted to display them by month, the balance is showing all the period available. When I try to filter out only for 12 months, each column is only showing the change for the period, not the end of the period balance. How can I fix that?
This may require further testing or discussion. We encourage you to post it in our community, where our experts can provide guidance. Here's the link: https://community.oracle.com/netsuite/english/categories/ask-a-guru
can you explain the difference between audience vs access?
I understand that you would want to know the difference between audience vs access.
Audience tab:
Audience:
Users selected under the Audience tab of a custom report can only run the report if the role they're using has the permission for the standard report on which the custom report is based. This is to prevent accidentally granting report access to users that do not have the necessary permissions.
Access:
If you need to grant custom report access to users who would normally not hav
My financial reports show my company name twice in the header when printed. How to remove one of these?
For your concern regarding the company name appearing twice, this normally happen if ""Always Display Subsidiary Name"" checkbox is checked under the reporting Subsidiary
I run an income statement that shows actual v budget by Subsidiary. I have 6 subsidiaries. How can I add blank columns between the subsidiaries, and also change the order of the subsidiaries on the report? Thank you!
To add a blank column in between your subsidiary columns, click on Customize.
Go to the Edit Columns Tab and on the Left side of the page under add fields, click on the plus sign next to Financial.
As an example, I clicked on the ""Cleared"" row to add
Preview your report and you should see the blank column now added, Repeat the steps as needed and reorder your columns to ensure the blank column is in between your subsidiary columns