Reply
Frequent Visitor
Posts: 7
Registered: ‎06-12-2017

Re: Display\Find The first Date that Inventory QTY goes Negative based on Running Net Inventory Tota

[ Edited ]

Sweet!! Thanks.  How can I also get the Order QTY related to the due when it first went Negative?

Super Contributor
Posts: 3,609
Registered: ‎09-27-2016

Re: Display\Find The first Date that Inventory QTY goes Negative based on Running Net Inventory Tota

[ Edited ]

Hi @Grunstra,

I use the min function, it has calculated the earliest date went Negative. 

Best Regards,
Angelia

Frequent Visitor
Posts: 7
Registered: ‎06-12-2017

Re: Display\Find The first Date that Inventory QTY goes Negative based on Running Net Inventory Tota

Any way to get the ON Hand Inventory QTY on that Due Date?