Why NetSuite Item Fulfillment Search Nets
Your saved search tracks daily fulfilled quantities, but the numbers are off. Item A shows 89 units fulfilled; Item B shows zero.
Sarah Jenkins, CPAPrincipal Finance Automation Specialist
On this page
Your saved search tracks daily fulfilled quantities, but the numbers are off. Item A shows 89 units fulfilled; Item B shows zero. Both appear on the same report with matching positive and negative lines that cancel out. This is standard behavior on Item Fulfillment records, and the fix is straightforward.
What's Actually Happening on the Item Fulfillment Record
NetSuite stores quantity on Item Fulfillment lines in multiple fields simultaneously. The quantity field represents the net committed quantity, which can be positive or negative depending on how the fulfillment was created.
When you fulfill a sales order, NetSuite sometimes creates both a positive and negative quantity line for the same item on the same record. This occurs most often with:
- Partial fulfillments followed by additional fulfillments on the same sales order
- Returned items that get re-fulfilled
- Inventory items with bin or lot tracking where allocation changes between fulfillment attempts
- Orders fulfilled through the "Fulfill Orders" page rather than directly from the sales order
The negative line isn't a data error. It's NetSuite reversing a previously committed quantity before applying the new fulfillment amount. Your saved search sums both lines because it groups by item and date without filtering out the reversal entries.
Why Your Current Saved Search Fails
Your criteria seem correct: Type = Item Fulfillment, Status = Item Fulfillment:Shipped, Main Line is false, Item Type is Assembly or Inventory Item. The issue is the quantity field you're summing.
| Field | What It Actually Contains |
|---|---|
| Quantity | Net committed quantity, can be negative |
| Quantity Fulfilled/Received | Gross quantity, but often 0 on search results |
| Quantity Picked | Pick confirmation quantity, not shipment quantity |
| Quantity Packed | Pack confirmation quantity, not shipment quantity |
| Quantity Shipped | Usually 0 unless shipping integration populated it |
The quantity field is the only one that reliably populates in saved search results for Item Fulfillment records. It nets out reversal lines. That's why Item B shows zero: the positive 125 and negative 125 cancel each other.
The Fix: Filter Out Reversal Lines
Add a criteria line to exclude negative quantity lines:
- Go to Saved Searches > All Saved Searches > Edit your search
- Under the Criteria subtab, add a new filter
- Choose Quantity from the Field dropdown
- Set the operator to greater than
- Enter 0 in the value field
- Click Add
This filters out the negative reversal lines while keeping genuine fulfillment quantities. Item B now shows 125 instead of zero.
A More Reliable Approach: Use the Item Fulfillment Line Table
For daily fulfillment reporting, create a search that pulls from the item fulfillment line table directly. Go to:
Reports > Saved Searches > New > Transaction
Set Type = Item Fulfillment and Main Line = false. Add the same Quantity greater than 0 filter. This reads line-level data without the summary-level netting behavior.
What About the Zeroes in Other Quantity Fields?
Quantity Picked, Quantity Packed, Quantity Shipped, and Quantity Fulfilled/Received all returning zeroes is expected.
- Quantity Picked only populates if you use the Pick, Pack, Ship workflow with separate confirmation steps
- Quantity Packed only populates if you use the Packing Station or the Pack component
- Quantity Shipped only populates if you use integrated shipping labels through NetSuite's shipping module
- Quantity Fulfilled/Received populates on the sales order line, not the fulfillment line
If you fulfill directly from the sales order without Pick/Pack/Confirm, only the quantity field carries the fulfilled amount.
A Saved Search Formula That Handles This Automatically
If you want a formula that nets out correctly without manual filtering, create a formula (numeric) column:
CASE WHEN {quantity} > 0 THEN {quantity} ELSE 0 ENDAdd this as a Formula (Numeric) column in your Results tab, with Summary Type = Sum. This accomplishes the same thing as the criteria filter but keeps the formula visible in your output.
What About Negative Inventory Situations?
If you're fulfilling more than you have on hand, NetSuite may create additional negative quantity lines. This happens when Fulfillment Based on Commitment is set to allow negative inventory. Check this at:
Setup > Accounting > Accounting Preferences > Order Management tab
If unexpected negative lines appear beyond the reversal pattern, check whether your item records have Allow Negative Inventory enabled. This is on the item record under the Inventory subtab, and it lets fulfillments proceed even when quantity on hand is insufficient.
A Worked Example: Your March 31 Report
Your original search produced:
| Date | Item | Quantity |
|---|---|---|
| 3/31 | Item A | 89 |
| 3/31 | Item A | 89 |
| 3/31 | Item A | -89 |
| 3/31 | Item B | 125 |
| 3/31 | Item B | -125 |
After adding the Quantity > 0 filter:
| Date | Item | Quantity |
|---|---|---|
| 3/31 | Item A | 89 |
| 3/31 | Item A | 89 |
| 3/31 | Item B | 125 |
The negative reversal lines disappear. Item A correctly sums to 178 units fulfilled on 3/31. Item B shows 125.
Why This Matters for Safety Stock Calculations
If your saved search undercounts fulfilled quantities, you'll set reorder points too low and risk stockouts. Overcount and you'll carry excess inventory, tying up cash.
The netting issue directly skews these numbers. Item B showing zero fulfilled when you shipped 125 units makes demand look lower than it is. That's a material error for inventory planning.
Verify Your Results Against the Item Fulfillment Record
After applying the filter, spot-check a few days of data against actual Item Fulfillment records. Open the record, go to the Items subtab, and verify quantities match your search output.
If discrepancies remain, check the Inventory Detail subtab on the fulfillment record. Some fulfillments create multiple inventory detail lines with different bin or lot assignments. Your saved search groups by item, which handles this, but if you're also grouping by location or bin, you may see split lines that appear to double-count.
Filter out negative quantities, verify against source records, and your daily fulfillment report will give you clean, reconciled numbers for inventory planning. Your auditors will thank you when reorder points align with actual demand.
For teams managing multiple fulfillments daily, this fix eliminates the spreadsheet workaround of manually adding up positive lines.
Learn more about NetSuite's user interface basics in the NetSuite Basics Guide.
Understand NetSuite's navigation portlet and shortcuts in the Dashboards Guide.
