I am running an Item Quantity sold per month based on Sales Order search and am trying to add a column to show safety stock level for the location selected. How do i do this

AI generated answer (using internal Slack threads):

****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ****** To add a column to show safety stock level for the location selected in your Item Quantity sold per month based on Sales Order search, you can follow these steps: 1. In your saved search, you need to add a new column. 2. In the field selection, go to the bottom of the list and select "Transaction Fields". 3. Then select "quantity". However, it's important to note that the Safety Stock field is not directly available in reports. You might want to consider using the "Preferred Stock Level" field instead, as it is available in reports and carries over to the Order Items Feature. If you want to show the quantities per location, you need to use the "Location On Hand" field instead of the "On Hand" field. The "On Hand" field will always show the total company holding, while the "Location On Hand" field will show the quantities by location. Remember to set the Column to Location on the bottom part of the page and click Refresh. This should show the locations at the top as columns. Also, don't forget to add additional filters when you customize the report and check the "Show Filter" checkbox. If you're still having trouble getting the location quantities, you might need to use a DECODE function, like so:

DECODE({inventorylocation},’each location’,{locationavailable},0)

. Depending on how your search is built, you may need to prefix those field values with "item".