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.
Now is the time to ask your NetSuite-savvy friends and colleagues to join the NetSuite Support Community! Refer now! Click here to watch and learn more!
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