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
| - hasOnHand | Boolean | |
| - hasOnOrder | Boolean | |
| - inventoryAssetId | Integer | |
| - inventoryAssetName | String | |
| - inventoryAssetPath | String | |
| - inventoryAssetTypeName | String | |
| - isBelowReorderThreshold | Boolean | |
| - isBelowSafetyStock | Boolean | |
| - isStocked | Boolean | |
| - partCategoryPath | String | |
| - partId | Integer | |
| - partInventoryBalanceId | Integer | |
| - partInventoryPolicyId | Integer | |
| - partNumber | String |
Returns
data pyDataset
Example
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
>>>