Discussions
SuiteWorld is where the NetSuite community comes together to learn, connect, and discover what’s next.
Whether you’re looking for product updates, practical tips, new ways to improve efficiency, or insights from other customers, SuiteWorld offers something for every stage of your NetSuite journey.
■ NetSuite 2026.2 Release Notes
■ NetSuite SuiteApps Release Notes
■ NetSuite Sneak Peeks
■ Release Preview Guide
■ Release Preview Test Plan Template
Search involving fulfillment status by line item?
Hi all-
We created a transaction column "ship date" as many of our customers will issue one PO with multiple shipments/split shipments for the same goods. For example, a sales order may have 5000 of X shipping on 4/15, 5000 of X shipping on 4/30, etc, and this would all be on one Sales Order. As our customers work this way, we had no choice but to create a "ship date" column so that a ship date can be listed on a per line item basis.
Now, I am trying to create a saved search to show overdue shipments. That is, a search that shows all POs and sales orders that are still unfulfilled and the ship date was before today. But the problem is, it seems that the fulfillment status is decided for the whole PO/SO, so it is showing me line items that have been complete. For example, if I have a sales order with shipments on 2/15 and 2/30 but the 2/15 shipment has been fulfilled and billed, it still shows me the 2/15 line item on the report. I assume that this