Consignment Purchases Dataset in NetSuite 2025.2

TL;DR Opening

Starting in NetSuite 2025.2, the new Consignment Purchases Dataset has been introduced under the Inventory SuiteAnalytics Workbooks. This enhancement enables users to effectively track vendor-consigned items that have been purchased, received, consumed, and billed, thereby enhancing inventory management capabilities.

What's New: Consignment Purchases Dataset

The addition of the Consignment Purchases Dataset provides invaluable insights for businesses utilizing consigned inventory. This dataset combines relevant fields from both the Transaction and Transaction Line record types, allowing for a comprehensive view of consigned items throughout their lifecycle.

Key Features of the Consignment Purchases Dataset

• Multi-Record Type Integration: Combines fields from multiple transactions which include purchase orders, allowing businesses to track all aspects of consigned inventory.
• Filtering and Customization: Users can define criteria such as Purchase Contract filtering for enhanced specificity when monitoring vendor-consigned items. Ensure that calculations for quantities are clear and display correctly, especially concerning over-receiving and over-billing.
• Data Utilization: Facilitates tracking of consigned items that are purchased, received, or returned but not yet billed, which aids in more accurate inventory assessments and financial planning.

Important Fields Included in the Dataset

• Transaction Record Fields:
  • Internal ID
  • Document Number/ID
  • Date
  • Type
  • Entity, and more.
• Transaction Line Fields:
  • Line Number
  • Full Name (Item)
  • Location
  • Quantity Billed
  • Consigned
  • Total Amount, etc.

Criteria for Dataset Filtering

• Transaction Type must be Purchase Order.
• Transaction Status must not include: Closed, Fully Billed, Pending Supervisor Approval.
• Transaction Date must start from the beginning of the current month.
• Ensure Main Line and Tax Line criteria are correctly set to avoid inconsistencies.

This enhanced dataset is pivotal for accurate reporting and decision-making in organizations using vendor-consigned inventory systems, ensuring that all transactions are tracked effectively.

Who This Affects

• Administrators: Responsible for setting up and maintaining inventory datasets.
• Inventory Managers: In charge of overseeing vendor-consigned inventory.
• Finance Teams: Managing financial aspects of inventory and purchases.

Key Takeaways

• The introduction of the Consignment Purchases Dataset streamlines inventory tracking for consigned items.
• Users can filter and customize datasets to suit specific business needs.
• By leveraging this dataset, organizations enhance their ability to manage and report on inventory transactions effectively.