[FHC]

That's pretty much it. I've got two locations that have inventory that I need to check. I'm trying to create a saved search that will return the Location On Hand for all locations for an item on one line.

Currently, I'm getting results like the attached screenshot. In this example, I'd like 2QUA80101 on one line with a quantity of 12 and 3OL4100SP on one line with a quantity of 23. Is this possible?

Any insight here would be much appreciated.
This is a cached copy. Click here to see the original post.

[michoel]

Use the column "On Hand" in your results instead of "Location On Hand"

You will also need to remove the "Inventory Location" column from your results to avoid duplicate lines.

[FHC]

Ugh. Of course. It's always something simple like that. That did it. Thanks!

[Daneau]

How would you do this if you had a subset of locations you want to total and show up on one line? example: we have 10 Locations, but I want the grand total from only Locations #1 and #2.

[michoel]

You could use a grouped ("summary") search for that.

https://system.netsuite.com/app/help…n_N659760.html

In your criteria, select the two locations you want. In the results tab select "Group" as the Summary Type for the Item Name field, and "Sum" as the Summary Type for "Location On Hand"

[JCirocco]

If you have 2 locations ("111" and "222") and you wanted each in its own column, you could use a custom numeric field with Maximum (don't think allows Grouped):

DECODE({inventorylocation}, '111', {locationquantityonhand})

DECODE({inventorylocation}, '222', {locationquantityonhand})

[Author]

Posts