Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
Now is the time to ask your NetSuite-savvy friends and colleagues to join the NetSuite Support Community! Refer now! Click here to watch and learn more!
How to Use Item OnHand Qty in Formula in Summary Search?
I have a Summary Saved Transaction Search (Sales Orders) in which I have the following:
[LIST=1]
[*]Group By Item Name
[*]Max On Hand (from Item Record)
[*]Sum Quantity (line items on Sales Order record)[/LIST]I need to calculate the following from these summary fields:
[LIST]
[*]Total Qty to Make for each Item = Total Qty Ordered (#3) - Qty On Hand for that Item (#2)[/LIST]What would be the formula to calculate this?
I can't use Sum of ({quantity} - {onhand}) because {onhand} should not be summed at the Item level.
I don't know how to write this in NetSuite, but the formula should be:[INDENT]
0