0

Negative Qty on Hand - Count # of Items

Karen Atkinson

December 10, 2019 21:05

None

Follow

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.

• Facebook
• Twitter
• LinkedIn

2 comments

• 0
  
  Stephen Williamson December 12, 2019 10:29

  Can you not use =NL("Count","Item",,"Location Filter",$E7,"Inventory","<0") where E7 is your rows of Location Codes

   

  May take a while to run as it is using the flowfield on the item record depending on how many locations, items and ledger entries you have

• 0
  
  Karen Atkinson December 12, 2019 13:35

  Thank you !! That works ;-) And so nice and simple !!