Pick Task Inventory Balance Dataset

This dataset combines fields from the Pick Task subrecord and those related to inventory balance to display pick task details and inventory quantities within locations. Inventory Balance combines details from the item, bin, and location records. To obtain data for pick tasks associated with orders in waves, it also includes details from the sales order, transfer order, and wave transaction.

If you use the Warehouse Management feature, you can access this dataset.

Data Configuration

The Pick Task Inventory Balance dataset combines fields from multiple record types. To edit the dataset, see Defining a Dataset.

Root Record Type	Joined Record Type	Custom Formula Fields	Data Grid	Criteria Filters
Pick Task Inventory Balance	Item Bin Location Sales Order Transfer Order Wave	(none)	The following fields are included in the dataset. Pick Task subrecord: Pick Task # Pick Task Status Wave # Item Serial/Lot Number Picked Quantity Order # Line Item Status Message Item record: On-Hand Quantity Available Quantity Bin record: Bin Number Location record: Location	(none)

Related Topics

Inventory SuiteAnalytics Workbooks

Warehouse Inventory Dataset Templates

Customizing Inventory SuiteAnalytics Workbooks

SuiteAnalytics Workbook Overview

Enabling SuiteAnalytics Workbook in Your NetSuite Account

The Analytics Administrator Permission

Data Refresh in SuiteAnalytics Workbook

Known Limitations in SuiteAnalytics Workbook

Analytics Data Source Overview

Workbook and Dataset Templates

Customizing Inventory SuiteAnalytics Workbooks

General Notices