# system.kanoa.inventory.getPartInventoryStock(paramsDict)

Returns a combined view of part inventory balance and policy data for the inv.vwPartInventoryStocking view  � a joined "stock" record per part/bin that merges on-hand and on-order quantities 
with the configured inventory policy (reorder threshold, safety stock, stocked flag, etc.). 
All parameters are optional filters passed in a single dictionary; omitting `paramsDict` keys, or passing an empty dictionary, returns the full unfiltered result set.

---
### Parameters
**paramsDict** `Dictionary`<br />
<table class='dictionaryKeyTable'>
	<tbody>
 	<tr><td> - hasOnHand</td><td>Boolean</td><td></td></tr>	
 	<tr><td> - hasOnOrder</td><td>Boolean</td><td></td></tr>	
 	<tr><td> - inventoryAssetId</td><td>Integer</td><td></td></tr>	
 	<tr><td> - inventoryAssetName</td><td>String</td><td></td></tr>	
 	<tr><td> - inventoryAssetPath</td><td>String</td><td></td></tr>	
 	<tr><td> - inventoryAssetTypeName</td><td>String</td><td></td></tr>	
 	<tr><td> - isBelowReorderThreshold</td><td>Boolean</td><td></td></tr>	
 	<tr><td> - isBelowSafetyStock</td><td>Boolean</td><td></td></tr>	
 	<tr><td> - isStocked</td><td>Boolean</td><td></td></tr>	
 	<tr><td> - partCategoryPath</td><td>String</td><td></td></tr>	
 	<tr><td> - partId</td><td>Integer</td><td></td></tr>	
 	<tr><td> - partInventoryBalanceId</td><td>Integer</td><td></td></tr>	
 	<tr><td> - partInventoryPolicyId</td><td>Integer</td><td></td></tr>	
 	<tr><td> - partNumber</td><td>String</td><td></td></tr>	
	</tbody>
</table>

---
### Returns
**data** `pyDataset`<br />

---
### Example
```python
paramsDict = {
	'inventoryAssetName': 'Parts Room',
	'isBelowReorderThreshold': True,
	'isStocked': True,
}

data = system.kanoa.inventory.getPartInventoryStock(paramsDict)
data = system.kanoa.utilities.convertDatasetToJSON(data)

for i, row in enumerate(data):
	print 'Row %i'%i
	for k,v in row.items():
		print k,v
	
	break	#Just limiting to returning the columns from the first record for display purposes
>>> 
Row 0
partId 26
inventoryAssetPath Kanoa Box Co\Warehouse\Parts Room
lastUpdated Tue Jun 09 14:53:05 UTC 2026
isBelowSafetyStock 1
partInventoryBalanceId None
quantityOnOrder 0.0
quantityOnHand 0.0
partInventoryPolicyId 6
countFrequencyDays 60
inventoryAssetId 2968
inventoryPartPath Kanoa Box Co\Warehouse\Parts Room\Bearings\AAA111
partCategoryPath Bearings
inventoryAssetTypeName Storage Location
quantityAvailable 0.0
defaultUomId 1
uomCode EA
partPath Bearings\AAA111
inventoryAssetName Parts Room
reorderPointQty 50.0
isStocked True
quantityReserved 0.0
isBelowReorderThreshold 1
uomName Each
partNumber AAA111
maxQty 100.0
reorderQty 50.0
safetyStockQty 40.0
minQty 10.0
>>> 
```