help me create a search comparing preferred stock level and actual stock by location

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 create a search comparing preferred stock level and actual stock by location, you would need to use SuiteScript or a saved search in NetSuite. Unfortunately, transaction line fields don't support summary search derived values, and you can't get to the location preferred stock level (ROP, SSL, etc) fields via the default "sourcing & filtering" method. Here's a brief explanation of the terms: - Safety Stock Level: This is the minimum amount of stock you want to have on hand at all times. For example, if you always want 50 of item A in stock, then that is your safety stock. - Preferred Stock Level (PSL): This is the ideal quantity you want to have on hand (minus the safety stock) to fulfill your daily demand. For example, if you want 50 units of A in the safety stock, and you need 10 days to receive it on a PO, and you sell 1 units per day, your reorder point might be 60, but your preferred stock level is 110. You can create a saved search to compare these values by location. However, please note that you might need to use scripting or workflows to get the desired results, as the default sourcing and filtering methods might not be sufficient. Unfortunately, I can't provide a code sample as none were provided in the threads/conversations.