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.
Qty of Line Item and Qty of all packages on order?
Trying to find a way within search or report to return a line of data regarding a fulfilled order that will return the item name, the quantity ordered AND the quantity ordered of ALL items on that order.
Example Sales Order#
Item1 Qty=2
Item2 Qty=4
Item3 Qty=6
So I am trying to get results that would be returned as:
Order#, Item, Item Qty, Order Qty
Order#, Item1, 2, 12
Order#, Item2, 4, 12
Order#, Item3, 6, 12
Going to drive a case label that must appear on every box sent to customer.
I do not care if I have to go after fulfillments or sales orders. I know how to do in raw MS/SQL (using a sub-select) but was hoping to do in native NetSuite.
John Cirocco
Sr. NetSuite Administrator