Levi Pruss
10/01/2025, 1:58 PMCeligo AI
10/01/2025, 1:58 PMAI generated answer (using internal Slack threads):To create a saved search showing item availability across all locations, you can follow these steps: 1. Navigate to the Saved Search creation page in NetSuite. 2. Select the 'Item' record type for your search. 3. In the 'Criteria' tab, you can add any necessary filters. If you want to see availability for all items, you may not need to add any criteria. 4. In the 'Results' tab, add the fields you want to see in your search results. To see item availability, you should add the 'Location Available' field. This field shows the quantity available for each item at each location. If you want to see the total quantity available across all locations, you can also add the 'Available' field. 5. If you want to see the results broken down by location, you can add 'Inventory Location' to the 'Group' tab. Remember, when creating a saved search, all joins in searches are left outer joins. This means you get a response for all locations for all location on hand fields. So, you need a location on hand criteria to filter your results down appropriately. Also, note that the 'Quantity Available' field represents the available quantity across all locations when looking at an item saved search. However, if you're looking at a transaction, it typically means the quantity available in the specific location related to that transaction. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******
Celigo AI
10/01/2025, 1:58 PMSlack thread 1: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.848144591
Slack thread 2: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.83026129
Slack thread 3: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.829406857
Celigo AI
10/01/2025, 1:58 PM