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!
Saved search on backordered items vs on order
Hello I am trying to create a saved search of backordered items in a specific date range of Requested ship date (custom field) , and compare them with quantities that are "on order" , so I can see what items need to be purchased.
To be able to have a backordered quantity for a specific date, I need to use SO lines rather than the backordered quantity on the item record. I therefore created the following saved search :
Criteria:
Results:
Now the result is this :
In the red section is an example of 2 SO lines for the same item : the formula pulls out the backordered quantity per SO line. SO for this item, my total backordered quantity ( for a specific date range) is 4000+2100 = 6100.
0