Warehouse Inventory: Inbound Dataset

This dataset combines fields from the Transaction and Transaction Line record types to display inbound transactions for receiving, including purchase orders, transfer orders, and return authorizations. It forms the source data for the Warehouse Inventory: Inbound Workbook.

Dataset Configuration

The Warehouse Inventory: Inbound dataset combines fields from two record types and multiple criteria filters. To edit the dataset, see Defining a Dataset.

Root Record Type

Joined Record Type

Custom Formula Fields

Data Grid

Criteria Filters

Transaction

Transaction Line

(none)

The following fields are included in the dataset.

Transaction:

  • Date

  • Document Number/ID

  • Entity

  • Memo

  • Status

  • Total Amount (Transaction Currency)

  • Transaction

  • Type

Transaction Line:

  • Actual Ship/Receipt/Pickup Date

  • Item

  • Quantity

  • Quantity Shipped/Received/Picked Up

  • To Be Fulfilled / Received

The following criteria is used to filter the dataset:

  • Type any of Purchase Order, Transfer Order, Return Authorization

  • Transaction Line: Item Type none of Shipping Cost Item

  • Transaction Line: Main Line is false

  • Transaction Line: Tax Line is false

Related Topics

Warehouse Inventory Dataset Templates
Warehouse Inventory: Counts & Adjustments Dataset
Warehouse Inventory: Outbound Dataset
Workbook and Dataset Templates
Custom Workbooks and Datasets
Defining a Dataset
Joining Transaction Line and Transaction Accounting Line in a Dataset
Creating a Workbook

General Notices