Discussions
Read on for the latest updates including:
• Agenda Builder launch
• SuiteWorld On Air registration
• New NetSuite Prompt Studio Contest
• And more!
Check out this thread to learn more!
Don’t miss your chance to meet our SuiteGurus—NetSuite Support professionals and subject matter experts with extensive experience in select product areas, including OneWorld, Advanced & Basic Accounting, Supply Chain Management, Receivables & Payables, CRM, Account Administration, and the SuiteCloud Platform. Full Conference attendees can prebook exclusive 30-minute one-on-one sessions for your product questions.
Spots are limited! Register through your Agenda Builder and find SuiteGuru under Agenda Enhancements.
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