Hello! i'm hoping you can help me with something that i'm sure is a very simple fix. 

We run small inventory counts usually to confirm and reconcile backorders or questions about shipments through the month. Usually, we run an inventory valuation report. That shows us the lot# of the product, and the weight that we are to expect in that lot # (quantity on hand). My question is, is there a way to see the available quantity as opposed to the quantity on hand? 

Unfortunately we cannot always close those shipping batches out before the inventory count takes place. 

Currently using Sage 100 ERP 2021 

Thank you!