Inventory that drops below zero over a date range

I am still fairly new to Jet. we are using Jet Pro 2018 with NAV 2016.

I have seen how to use the inventory net change to output the quantity on hand for a given day and built a report with that. However I am trying to see if I can report on everything that has dropped to zero over a given time period.

For example, report on all items that hit zero at some point through the month of May. Even better would be to know how many times, or how many days, it was in this state.

Any suggestions how I might be able to accomplish this?


Please sign in to leave a comment.