Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
New AI Community Guidelines. Please review and follow them to ensure AI use stays safe, accurate, and compliant.
Put static value and Summary value in same report
I wasn't really sure how to describe it for the topic, but I'm trying to get a list of "understocked" product. By the simple definition we're using, we're trying to to compare 6 months of sales to the current inventory level, and then subtract those two values to get the amount of product we would need to order to fulfill the next 6 months.
Here are the issues:
- I can't just use "On Hand" or "Warehouse on hand" because we only want to look at 2 of our many warehouses for this search.
- If I try to use a formula to add those warehouses, it adds it for every line of the report, giving me a massive number
0