Is there a common logic block that will give me a list of locations for an item along with all the quantities for that item at each location? Things I am looking the get by part location are:
quantityOnHand
quantityOnHold
availableQuantityOnHand
quantityHardCommitted
quantitySoftCommitted
quantityOnOrder
There is not currently a common logic block that will provide a list of balances. The best method available right now is probably to call CalculateAvailableQuantity on a loop and provide the associated Item, Org Unit, and part location. Providing a location should automatically exclude availability within supply org units, but you can also input ExcludeSupplyOrgUnits as True to explicitly rule them out.
This logic will return all calculated values for an input Item, Org Unit, etc., including all of the above values. Hard committed, soft committed, and on order quantity is broken into order type but may be added together.
If it would be satisfactory to read that information in a list view, it can easily be accessed directly within the Item Balances application, Inventory Overview application, or an interactive report built over ItemBalances.