Knowledge Checks Flashcards
What must be added first to organize data on a form.
A. Fields
B. Lists
C. Subtabs
C. Subtabs
Use a _________ to control how information is entered and viewed
Answer: Custom Form
What can you use if a record cannot be imported though .csv imports?
Answer: Web Services
How should you want to configure duplicate detection on email differently for companies than individuals?
Company duplicate detection for emails should use domain only instead of full email
How should you revise multiple records using criteria and at one go?
A. Mass Update
B. .csv update import
C. Inline editing on a search
A. Mass Update
What are two options for entering serialized inventory into NetSuite?
Answer: (1) manual entry with serial numbers (space, comma or line breaks) that match the inventory count
OR
2. Using the barcode feature
non-inventory items are available for sales, resale and ______ ?
Answer: Purchase
What are dunning letters?
A. A method of reconciling inventory
B. A method of marketing to customers
C. A method of tracking and communicating about overdue invoices
D. A systematic feature for sending customers letters about credit issues
C. A method of tracking and communicating about overdue invoices
\_\_\_ Bill \_\_\_ Vendor Credit \_\_\_ Vendor Payments to be printed \_\_\_ BIll Purchase Order \_\_\_ A/P Aging Summary
A. Listing all unpaid bills in accounts payable
B. Transaction entered to record a payable that does nto have a purchase order, such as a charge of utilities
C. You want to put payable into a print queue
D. Credit from a vendor that can be applied to our payable account
E. Invoice received from vendor and convert PO to a payable
B D C E A
A ______ decrease the amount the customer owes
credit memo
We received a partial quantity of po line item, the vendor will never ship the remaining qty. How should I hand the PO and billing the PO?
A. Bill for what you have received, then close the PO
B. Close the PO
C. Bill the PO only
D. Delete the itemson the PO that will not be shipped
A
How can I maintain more control over the vendor bills and the payment of those bills?
A.Use Purchase Order Approval Settings
B. Remove access to Vendor Bills
C. Review setup > accounting > accounting preferences > order management subtab and the bill and po approval settings
D. Use purchase orders
C
Note: In the Default Supplier Bill Status field, select one of the following:
Approved – Bills default to an Approved status. No further review or processing is required.
Pending Approval – Bills default to a Pending Approval status. Someone with permission must approve the bill before a payment can be processed for it.
I need to start closing accounting periods. What do I do?
A. Go to lists > accounting, accounts and inactivate accounts
B. Go to the manage account periods page and click on the checklist
C. Post all open journals
D Go to setup > Accounting > Accounting preferences
B
Manage Accounting Periods Page
The Manage Accounting Periods page is a list of all of the accounting periods set up in your account, and rolled up in the accounting period hierarchy to which they belong. Use this page to set up, view, and edit periods. You can also access the Period Close Checklist to lock, unlock, and close accounting periods. To see this page, go to Setup > Accounting > Manage G/L > Manage Accounting Periods (Administrator).
Note This page is available if you have the View level or higher of the Manage Accounting Periods permission. You must have at least the Edit level of this permission to set up or edit accounting periods.
If your user role has the Period Closing Management permission and the Allow Quick Close of Accounting Periods preference is enabled, you can close one or more accounting periods with a single click. For more information, see Using Quick Close to Close Periods.
If you use Multi-Book Accounting, you can individually close and reopen accounting periods associated with any accounting book, without impacting your other accounting books. You choose the accounting book for which you want to close a period through the Filters section at the top of this page. The accounting books available for selection depend upon your user role and associated permissions. For more information about the Extended Accounting Period Close Process feature, see Accounting Book Period Close Management.
.
Sales rules and territories are related. If so, how are they related?
A. True. Rules are assigned to territories
B. False. Rules are for Sales Reps to process transaction and territories for sales teams
C. True. Sales Rules ensures that transactions are assigned to the correct territories
D. False. Territories and Rules have absolutely no relationship at al
A
Note:
C is wrong because leads, prospects and customers are the focus of sales rules not Transactions
You can update the underlying data from the report
A) True
B) False
B) False. You have to drill down into the information to get to the actual transaction to update the information.
Using the name (Grouped) exposes any underlying hierarchy
A) True
B) False
A) True. The name (grouped) field exposes any underlying hiearchy
Use the Full Name is the best way to get grouping and subtotaling.
A) True
B) False
B) False. Fullname has the “Parent:Child” relationship but it does not have the hierachy so it lacks the flexibility that name (grouped) could give you.
Report customization is easy, jump right into it
A) True
B) False
B) False
Which of the following defines the accounts that display in a row on a financial statement
A. Report
B. Section
C. Footer
B. Section
Reference rows (which can display a value from a section or row from another report) cannot be used on the following:
A. Cash Flow
B. Income Statement
C. Balance Sheet
B. Income Statement
Header and Summary rows can contain sections.
A. True
B. False
A. True
A. Allows for a section total to display in another report (income in equity)
B. Black space or description notes
C. Not available for financial statements
D. Accounts grouped by user criteria
E. Link financial sections, formula rows and text rows together
F. Combine 2 or more rows/sections using mathematical Functions
_ Summary Row _Financial Section _Formual Row _Reference Row _Web Query _Text Row
D_Summary Row (Accounts grouped by user criteria)
A_Financial Section (Allows for a section total to display in another report (income in equity)
F_Formual Row (Combine 2 or more rows/sections using mathematical Functions)
E_Reference Row (Link financial sections, formula rows and text rows together)
C_Web Query (Not available for financial statements)
B_Text Row (Black space or description notes)
How can you modify the name of multiple report layouts at the same time?
From reports > financial > reports > layouts > financial row layouts. Turn on “Edit” for inline edits.
Layouts cannot be shared across financial statement
A. False, in the sense that a layout created for a balance sheet with another balance sheet
B. True, in the sense that you cannot create a layout for a balance sheet then apply to income statements.
C. Both A and B
C. Both A and B
How do you modify content in a financial report?
A. Modify a layout
B. Drill down into the information and link to and update transactions.
B. Drill down into the information and link to and update transactions.
(ds)
What is the order of the five steps to create a new report?: \_\_ Metric \_\_Format \_\_Subtotal \_\_Data \_\_Summarize
2\_\_ Metric 3\_\_Format 4\_\_Subtotal 1\_\_Data 5\_\_Summarize
My report has a budget column and a formula column to show variances. It is set up tp use periods as a persistent matrix. How many columns does it have? A. 26 B. 24 C. 36 D 16
C. 36
Which date range option is used for date comparison between two columns? A. Relative to report date B. Relative to todays date C. Relative to current fiscal year D. Relative to transaction date
A. Relative to report date
Saved searches can on only display a list of results, rather than a report-style view of results.
A. True
B. False
A. True
In Saved Searches, If using Summary Types, be sure to group on of your values before applying quantitative summary types of your other results.
A. True
B. False
A. True
In a saved search, I need my result to display as an integer, but it displays as 5.3333333 what do I do?
A. Set initial data inputs to round off data
B. Apply the “round’ function with the specified decimal to round of the results
C. Set the results to display integers only
B. Apply the “round’ function with the specified decimal to round of the results
Check available as dashboard view on a saved search to allow the saved search to reside in one of the 6 custom search portlets.
A. True
B. False
B. False. The check available as dashboard view only controls the list portlet.
Provide 1 reason why all saved searches cannot be used as KPIs
KPIs must be supported by a single summary type and a date filter.
For a saved search to be used as a custom KPI that displays results for multiple date ranges in the Key Performance Indicators portlet, a KPI scorecard, a trend graph, or a KPI meter, the search definition must meet the following requirements:
Not include any date fields defined as filters on the Criteria subtab. See Defining Standard Search Filters.
Have exactly one field with a summary type (such as count, group, or sum) defined on the Results subtab. The rest of the fields on the Results subtab should not use any summary types. See Defining Summary Types to Roll Up Search Results.
Have a date field defined as an available filter on the Available Filters subtab. See Selecting Available Filters for Saved Searches.
How many KPIs can you add to the KPI portlet? A. 10 B. 12 C. 14 D. 8
A. 10
Can you display any KPI i as a KPI Meter?
A. Yes. Only if KPI is in the KPI Portlet.
B. Yes. NetSuite can show custom KPIs as KPI Meters any time
C. No
D. Yes. Only admins can configure KPIs that can be shown as Meters.
A. Yes. Only if KPI is in the KPI Portlet.
Where do I create KPI score cards?
A. Home > Set Preferences > Analytics
B. Customizations > Centers and Tabs > KPI Scorecards
C, Setup > Accounting > Analytics > KPI tab
D. Customizations > Analytics > KPI Scorecards
B. Customizations > Centers and Tabs > KPI Scorecards
(ds)
Creating a KPI Scorecard
NetSuite enables you to create custom scorecards that can be displayed in the KPI Scorecard dashboard portlet.
To create a new KPI scorecard:
Go to Customization > Centers and Tabs > KPI Scorecards > New.
If this menu option is not available, the KPI Scorecards feature may not be enabled. See Enabling the KPI Scorecards Feature. Or you may not have permission to create scorecards. Check with your account administrator to ensure you have the KPI Scorecards permission.
At the top of the page, you can enter basic scorecard information. See Entering Basic Scorecard Information.
On the KPIs subtab of the Content subtab, you can add KPIs and define their comparisons, and add formulas and define formula expressions.
Scorecards can intermingle KPIs and formulas and compare them to each other, so you define KPIs and formulas in the same place using some slightly different fields on the subtab.
For KPI steps, see Defining KPI Scorecard Comparisons.
For formula steps, see Defining KPI Scorecard Formulas.
If you define custom KPIs to be used in scorecards, you need to define their underlying saved searches on the Custom subtab of the Content subtab.
Only saved searches with a date field defined under Available Filters are available for use as custom KPIs in scorecards. The exception is if you enable the Use Periods option for a scorecard. Then only saved searches with a Period filter defined under Available Filters are available.
After you have entered KPIs and formulas, you can reorder them by dragging and dropping or using the Move buttons.
On the Date Ranges (or Periods) subtab of the Content subtab, you can define multiple date ranges (or periods). These date ranges apply to all scorecard data. See Defining KPI Scorecard Date Ranges or Periods.
After you have entered date ranges, you can reorder them by dragging and dropping or using the Move buttons.
On the Highlighting subtab of the content subtab, you can set highlighting options to make results more visible in KPI Scorecard portlets. See Highlighting KPI Scorecard Results.
On the Audience subtab, you can define who has access to your scorecard, meaning who can put it in their KPI Scorecard portlet. You can base this definition on roles, departments, subsidiaries, groups, employees, or partners. See Sharing a Custom KPI Scorecard.
When you have completed all steps to define the scorecard, click Save.
Do I have to do anything specific to enable reporting by period from KPI score cards?
A. Select KPIs from saved searches with period a filter
B. Nothing
C. Home > Set Preferences > Analytics > set “Report by Period” to “All Reports”
D. Customizations > Centers and Tabs > KPI Scorecards
C. Home > Set Preferences > Analytics > set “Report by Period” to “All Reports”
Reporting by Accounting Period
When you enable the Accounting Periods feature and set up accounting periods, you have the option of organizing report data by fiscal period instead of by date range. This capability is especially important for financial statements. The use of accounting periods also enables you to filter and calculate KPI scorecard figures by fiscal period.
To set up your reports to be organized by period, set the Report by Period preference, at Home > Set Preferences > Analytics > Reporting section. You can choose to sort and filter all reports by period, or only financial reports like income statements and balance sheets. For more information, see Choosing a Date or Period Range for a Report.
Note
After the Report by Period preference has been set for a user’s reports, these reports cannot display results to the user until accounting periods for the entire fiscal year have been set up.
To set up a KPI scorecard’s data to be organized by period, check the Use Periods option on the scorecard record. For more information, see Defining KPI Scorecard Date Ranges or Periods and Period Ranges for KPI Scorecards.
In NetSuite OneWorld, if you use the Multiple Calendars feature, the subsidiary’s fiscal calendar determines the date ranges for the period selected for a report. For information about running reports for subsidiaries, see Running Reports for Subsidiaries with Different Accounting Periods.
KPIs are columns in the KPI score cards?
A. True
B. False
B. False, there are options:
From help:
Scorecard Data Display Options
Ability to orient KPIs horizontally or vertically
Ability to define custom labels in place of KPI names
Optional popup trend graphs
Ability to limit displayed data to your own or your team’s results.
How many KPI scorecards may be displayed on the home dashboard?
1
How many trend graphs can display on the home dashboard?
5
On a graph, How do I smooth out data from seasonal spikes? A. Show Average B. Show last data point C. Select the trend type D. Review the KPI field
A. Show Average
How many KPI Meter portlets can I add to a dashboard?
You can add up to three KPI Meter portlets to a dashboard. Each meter visually represents data for one KPI that is displayed in the dashboard’s Key Performance Indicators portlet.
This portlet displays a summary line for each critical business metric with clickable links that drill down into the underlying data source (eg. report). It only allows for a single date or period range comparison. A. Report Snapshots B. KPI Meters C. KPI Scorecard D. Key Performance Indicators
D. Key Performance Indicators
A. The focus is on a SINGLE snapshot report
B. Shows a graph for a single meter
C. Often used to show multiple date comparisons
If logged in with the administrator role can a user personalize and publish a dashboard for a custom role that belongs to the sales center?
A. True
B. False
B. False
Will published dashboard updates override user personalizations on specific user dashboards?
A. Yes
Which of the following statements about the audience and access sub tab on the more options tab in financial report builder are true?
A. Roles selected in the audience tab will be able to view the financial report regardless of role based permission granted.
B. Roles selected in the access tab will be able to view the financial report regardless of role based permission granted.
C. If a role and dept are selected in the Audience tab, the user needs to be assigned either the role or department to view the Financial Report.
D. If a role and dept are selected in the Access tab, the user needs to be assigned either the role or department to view the Financial Report.
B.
Notes:
“Audience” and “Access” tabs are very similar.
“Access” will override permissions on the role or user.
A user does need to belong both to the “role” and “department” to have access from either tab.
When configuring a custom KPI saved search, a date or period field needs to be included as an available filter to allow for comparison across different date/period ranges.
A. True
This report feature allows the user to preview results as a matrix style report with subtotals across both rows and columns. A> Standard Reports B> Saved Searches C> Financial Reports D> Pivot Report Beta
D. Pivot
HINT: the trigger here is the reference to subtotals for columns and ROWS.
REMINDER: Quickly scan/review suite answers for new and upcoming functionality. Could be a curve ball there.
Which report/search is configured to create a custom reminder? A. Standard Report B. Saved Search C. Financial Report D. Ad-Hoc Report
B. Saved Search
Do all standard reports allow the user to customize the drill down detail report?
A. Yes
B. No
B. No
Notes:
- Only summary reports can have drill downs.
- Ad Hoc Custom reports cannot have drill downs
- Summary reports can only have one drill down
- Drill down can only be on metrics being summarized - not on related entity fields like customer
What is the difference between the Financial Report Builder and Report Builder? A. Ability to Edit Layout B. Allow Web Query C. A and B D. None of the Above
C. A and B
Issue Which of the following are not customizable elements per the Edit Layout tab in the financial report builder of an income statement? A. Reference Row B. Header and Summary Rows C. Financial Section D. Formula E. Text Row
A. Reference row
Notes:
Trick question because reference rows are not available on income statements. They are used on other financial reports like balance sheets.
Ordered config tabs are: (1) edit layout (2) edit columns (where most formulas are defined)
(3) Sorting (optional)
(4) more options
When adding a formula field as a column per the edit columns tab in either the Financial Report Builder or Report Builder, are you able to use SQL formulas?
A. Yes
B. No
B. No
When and where can you use SQL formulas?
Quick Answers:
- In saved searches for: criteria, formulas in results and custom fields
- Through the SuiteAnalytics ODBC Connector
- NOT SUPPORTED IN REPORTS
(ds)
Research to create answer.
For advanced searches and saved searches, you can define formulas to be used in the following ways:
• As part of a custom field that is defined to use a formula to set its value. These custom fields are available to be used as search criteria or in results columns like any other custom field. See Using a Custom Formula Field in a Search.
For detailed information on how to define formulas in custom fields, see Creating Formula Fields.
• As part of search criteria. The results returned are based on the calculated value of the formula field. See Using a Formula in Search Criteria.
• As a results column field. The displayed values are based on the calculated value of the formula field. See Using a Formula in Search Results.
Formula values are dynamically calculated at the time a search is performed. Formula definitions can include NetSuite field IDs for which field values are substituted, SQL functions, and mathematical operators.
Note
Reports currently do not support the addition of fields calculated through more complex, customized expressions, for example those that use SQL functions. Searches do support the use of these types of formulas for results and criteria fields. See Formulas in Search.
To be able to view item hiearchy in the Revenue by Item standard report, which field would you use/add to as a column in the report?
C. Name Grouped
To display a saved search to a Custom Search portlet, which of the publishing options should be selected? [Hint: Assume that the assigned role has been granted audience and has the required permissions] A. Available As Dashboard View B. Public C. Available as List View D. None of the Above
D.
The normal content/permission restrictions for a portlet do not apply for the customer search portlet
