Negative Qty on Hand - Count # of Items

I am using Navision...

I am trying to identify how many Items each location has that are in a current Negative Qty on Hand state.

I am using the Item Ledger Entry table, Location Code filter.

For each location, I would like to calculate the Qty on Hand for each item, and then Count the # of Items where the Qty on Hand calculated to <0.

Any help would be appreciated.


Please sign in to leave a comment.