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 using the 'New Quantity' field in inventory adjustments
Hello All,
This is my first post so please let me know if i'm missing any crucial information.
I'm looking to create a saved search that can specifically pull inventory adjustments that register zero dollar, but have positive inventory.
Here is an example....
Item:ABC is at -4 qty on hand. Inventory adjustment#1234 is adding +8 . And the 'new quantity is now 4.
NS will not hold the dollar value once an item has gone into the negative. So if an item is adjusted into the positive and an employee forgets to adjust the est. unit cost, we end up with inventory with a zero dollar value.
0