Enhance Your NetSuite Dashboards: Display Inventory Data with Google Charts

Introduction:

In inventory management, understanding the distribution of stock across various locations and bins can help businesses make informed decisions. NetSuite’s SuiteScript and custom portlets provide the flexibility needed to visualize this data effectively. By integrating Google Charts, we can create intuitive visualizations that enhance data comprehension. Specifically, Google Pie Charts can provide a clear and interactive way to compare inventory quantities across different locations and bins.

Enhancing NetSuite Dashboards with Portlet Scripts:

Portlet scripts play a crucial role in enhancing the functionality and user experience of NetSuite dashboards. By leveraging portlet scripts, businesses can create customized, dynamic, and interactive visualizations that are tailored to their specific needs. This allows users to quickly access and interpret key data points, leading to more informed decision-making.

Inline HTML portlet scripts in NetSuite are a powerful way to create custom and interactive content directly within the dashboard. These scripts enable developers to leverage HTML, CSS, and JavaScript to build dynamic user interfaces that can integrate with external libraries and APIs. This flexibility is particularly useful for visualizing data, such as inventory quantities, in a way that is both informative and visually appealing.

Integrating Google Charts in the Portlet:

Integrating Google Charts into NetSuite portlet script enables dynamic and interactive data visualization, enhancing the usability and effectiveness of the dashboard. By incorporating the Google Charts Library, we can use a wide range of chart types and customization options, allowing us to create visually appealing charts that best represent our data.

Google Charts Library:

<script type="text/javascript" src="https://www.gstatic.com/charts/loader.js"></script>

Next, we need to prepare the data that will be visualized. This involves running a saved search in NetSuite to fetch the relevant data and then formatting it in a way that Google Charts can understand. With the data prepared, the next step is to create and customize the chart. Use the Google Charts API to specify the type of chart, configure its appearance, and populate it with data. Customization options include setting titles, colors, and adding interactivity.

Preparing Data Using Saved Search:

To effectively display inventory data in a Google Pie Chart within a NetSuite custom portlet, we need to prepare the data using a saved search. This saved search will retrieve the necessary inventory information, specifically location on-hand and bin on-hand quantities. The retrieved data is formatted into a format that Google Charts can understand. Specifically, it constructs an array of arrays, where each inner array represents a row in the chart data.

Saved Search displaying Location On Hand Quantities:

Saved Search displaying Bin On Hand Quantities:

Outcomes of Google Charts Integration in NetSuite Portlets:

• Portlet Displaying Location On hand & Bin On hand Quantities in the dashboard. Here, "No Bin" indicates that the quantity at the location is not placed in any of the bins

• .Filtering Data Based on Item

FAQ:

1. Can I integrate multiple types of Google Charts in a single portlet script?

• Yes, we can integrate different types of google charts into portlet script like Bar chart, Line chart, Column chart, Donut chart etc.,

2. How to add a custom portlet to the dashboard?

• We add a custom portlet to the dashboard by navigating Personalize > Standard Content Tab > Custom Portlet > Custom Content > Select script into the source field.

3. What are the ways to put “No Bin” items into specific bins?

• We can use the Bin Put-Away Worksheet to assign bins if we do not specify bins on inventory transactions, such as inventory adjustments or transfers.