Discussions

Check out Oracle NetSuite upcoming events and conferences here
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!
Update your Profile with your Support type to get your Support Type badge.
Expand your NetSuite knowledge by joining our Ask A Guru Live sessions. RSVP on this event now.
Community Poll: What sort of content would you like to see more of?

How to setup SUM of Quantities on Item Search?

edited Jan 26, 2023 8:40PM in Ask A Guru 4 comments

Hi all

I have this same problem before on a Transaction Search and a solution was provided. But now I have the same problem on an item search.

The criteria of the item search includes transaction lines.

It is a summary search and when I try to SUM the location available quantities it adds a line for every transaction I believe.

How would I make an Item Search which includes information on transactions related to that item, display an accurate summary figure of all the available stock.

Some screenshots below to assist.

Many thanks in advance for your help.

Kind regards

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!

Leaderboard

Community Whiz

Quarter 1 (Jan-Mar 2024)

This Week's Leaders

This Month's Leaders

All Time Leaders