You can restrict your view to a particular subsidiary or group of subsidiaries. You can do this in one of two ways: Click a subsidiary from the portlet. Click the Change Subsidiary link below the centers tabs. The system highlights the selected subsidiary and all of the sub-subsidiaries by default.To restrict or select all the… Continue reading Restrict Subsidiary Access Using the Subsidiary Navigator
Month: February 2022
Uninstalling SuiteApps
We can uninstall SuiteApps from SuiteApp MarketPlace by following these steps;- Customization ->SuiteCloud Development -> Installed SuiteApp List We get a list of installed SuiteApps Select Uninstall from Action menu 4. We will get the Install status of the SuiteApp 5.The SuiteApp will be removed from the Installed SuiteApp list after installation
Key things to remember when creating new data sets in SuiteAnalytics Workbook
Here are some key things to remember when creating new data sets. • Only fields added to the source data grid will be available in workbook visualizations. • Data sets can be used as a complement to saved searches for ad hoc data analysis. • Same field cannot be added twice to the data set’s… Continue reading Key things to remember when creating new data sets in SuiteAnalytics Workbook
PROPOSAL FOR VRMA UPDATE AND SETTING TRACKING NUMBER IN PURCHASE ORDER RECORD.
Proposal summary The scope of this proposal includes updating the ready to update checkbox in the vendor return authorization record based on the saved result, as well as updating the additional tracking number field in the purchase order based on the API response. Requirement The current requirement mainly relates to two Netsuite customizations. Updating the… Continue reading PROPOSAL FOR VRMA UPDATE AND SETTING TRACKING NUMBER IN PURCHASE ORDER RECORD.
Display the Foreign Amount without the Currency symbol in Transaction Search
Follow below steps; 1. Go Lists > Search > Saved Searches > New. 2. Select Transaction. 3. Provide a Search Title for Search. 4. On the Criteria tab > Standard subtab, Specify criteria. 5. On the Results tab > Columns subtab set the following: Select the field Formula (Currency) Apply the Formula {fxamount}. Give a Label name 6. Click Add 7. Click Save & Run
Data duplication in SuiteAnalytics Workbook
Due to the nature of the analytics data source, loops can be found in some join paths which may result in unwanted data duplication. Consider this basic example, the green path represents the logical join path from the base transaction record to the account record through the transaction line and transaction accounting line records. The red path represents the loop and the possibility of data duplication. Be aware of this when defining filter criteria or when adding… Continue reading Data duplication in SuiteAnalytics Workbook
Field types in SuiteAnalytics Workbook
All fields in the records and fields browser will display a small icon that identifies the fields type as shown here. There are several different types of fields; Numeric Text Date Boolean fields Hierarchical fields/Polymorphic fields Custom fields.
Excel Formulas And Functions
1. LEN() The function LEN() returns the total number of characters in a string. So, it will count the overall characters, including spaces and special characters. Given below is an example of the Len function. 2. NOW() The NOW() function in Excel gives the current system date and time. The result of the NOW() function… Continue reading Excel Formulas And Functions
ADVANCED FILTER IN EXCEL
Extracting a Unique list using Excel Advanced Filter to quickly extract unique records from a data set (or in other words remove duplicates). Select the entire data set (including the headers). Go Data tab –> Sort & Filter –> Advanced. (You can also use the keyboard shortcut – Alt + A + Q). This will open the… Continue reading ADVANCED FILTER IN EXCEL
Key things to remember when work with SuiteAnalytics Workbook
Here’s some key things to remember when first beginning to work with SuiteAnalytics Workbook. SuiteAnalytics Workbook combines many of the capabilities of NetSuite’s search and reporting tools. But it does not replace these tools. SuiteAnalytics Workbook enables you to identify why a particular business event happened by summarizing, aggregating, and visualizing workbook source data. Analytics home page allows you to manage two primary components, data sets and workbooks. User roles with the SuiteAnalytics Workbook permission can view, modify, share, and delete their own workbooks. User roles with the analytics administrator permission can view, share, modify, and delete all workbooks in your account. When planning your workbooks, refer to sample documents from your legacy system or a planning template such as the provided workbook design template.