This topic contains 5 replies, has 0 voices, and was last updated by JCirocco 7 years, 1 month ago.

  • Author
    Posts
  • #22761 Score: 0

    FHC
    • Contributions: 0
    • Level 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.

  • #22762 Score: 0

    michoel
    • Contributions: 0
    • Level 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.

  • #22763 Score: 0

    FHC
    • Contributions: 0
    • Level 1

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

  • #22764 Score: 0

    Daneau
    • Contributions: 0
    • Level 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.

  • #22765 Score: 0

    michoel
    • Contributions: 0
    • Level 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"

  • #22766 Score: 0

    JCirocco
    • Contributions: 0
    • Level 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})

You must be logged in to reply to this topic.