System Note Dataset in SuiteAnalytics
This section describes only System Notes. For information about the System Notes v2 dataset, see System Notes v2 Workbook.
You can create a custom dataset with System Note as the root record to analyze information about system notes, enter formulas, and set criteria filters. For more information about editing datasets, see Defining a Dataset.
You can add the following fields to the Data Grid:
-
Context
-
Field
-
Line ID
-
Name
-
New Value
-
Old Value
-
Record
-
Record ID
-
Record Type
-
Role
-
Line Transaction ID
-
Type
To make sure that Line Transaction ID displays an accurate value, create a formula field defined as {linetransactionid#raw} to display raw field values. For more information about using formulas in SuiteAnalytics, see Creating Formula Fields in SuiteAnalytics Workbook.
You can also use SuiteQL to query for Line Transaction ID and Line ID in the system note record. For more information, see SuiteQL in the N/query Module.