This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

Here' the detail of my search. The Qty Available is a formula field. logic is: if inventory location = bin location, use Bin Available, else use Location Qty. in the search (detailed view), the quantity looks OK. but when I sum up the QTY available the total does not tally. what could be wrong on the search if it shows correct detail results?

Usually when I've seen this it's because something is being joined in either the criteria or the results.

I believe adding additional criteria on the joined records helped. It's been a while since I last saw that problem though.

I guess too <@UBRE35B6K>  thanks! Just looking for what field to use as criteria

Thanks <@UBRE35B6K>  finally solved it! I had to use distinct and that did the trick! Thanks :hugging_face:

<@U011WDSQS0M> I have the same issue before a couple of times. you need to watch out with the Distinct logic because if a certain line which should be considered as unique have the same value as one or more lines, the sum wouldn't be correct because it will only consider that value once. A good example is let's say you have Item A. Then you have 3 bins associated to that item with bin quantity. In the detail level of the search lets say the available quantity for Bin A and B are both 5 and Bin C is 10. Supposed to be if you sum it up it should be 20 but if you use distinct it will only sum 15. Just my 2 cents though.

<@U2AF1TSTX> thanks for the advise! I'll definitely test a d check that scenario. If so, other than distinct what else are the solutions yoy used to overcome the issue on summing up the search values?