Item Adjacent Information
Quick one (Hopefully)
I’m once again looking to pull item adjacent information from a customer record.
What i’m attempting to do is something like CASE {transaction.item} = ‘XXX-XXXX’ THEN {transaction.quantity} END
My question is this: If I am looking for all the quantity of part ‘A’ that this customer has purchased, can I get this information by just referencing the item number, and netsuite will find the quantity of that item, or will I have to know the line sequence number, etc?
So if you look as sales orders or invoices, then the easiest would be to do a summary search and sum the qty, and group the customer and item.
