[FHC Contributions: 0Level 1☆]

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 Contributions: 0Level 1☆]

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 Contributions: 0Level 1☆]

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

[Daneau Contributions: 0Level 1☆]

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 Contributions: 0Level 1☆]

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 Contributions: 0Level 1☆]

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