how to show the quantity on hand of location in an item forecast report

AI generated answer (using internal Slack threads):

To show the quantity on hand of a location in an item forecast report, you can use a combination of saved searches and formulas. Here are the steps: 1. Create a new saved search from the item record. 2. In the criteria tab, add the necessary filters. For example, you might want to filter by 'Item Type' (Inventory Item, Assembly/Bill of Materials, Kit/Package), 'Location' (not unassigned), and 'Inactive' (False). 3. In the results tab, add the fields you want to display. To show the quantity on hand for each location, you can use a formula field. The formula would look something like this:

CASE WHEN {location} = {item.inventorylocation} THEN {item.locationquantityonhand} else 0 END

. This formula checks if the location of the item matches the location you're interested in, and if so, it displays the quantity on hand for that location. If not, it displays 0. 4. Repeat the formula for each location you're interested in, replacing

{item.inventorylocation}

with the internal ID of the location. 5. Save and run the search. Remember, the 'Location On Hand' field will show the quantity on hand by location, while the 'On Hand' field will show the total company holding. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******