system.kanoa.inventory.getPartInventoryBalances(paramsDict)

Returns part inventory balance records, optionally filtered by part, inventory asset, or a specific balance id. Pass an empty dictionary to retrieve all balances, or populate one or more of the recognized keys in paramsDict to narrow the result set.

---

Parameters

paramsDict Dictionary

- assetPath	String
- inventoryAssetId	Integer
- isCriticalSpare	Boolean
- partId	Integer
- partInventoryBalanceId	Integer
- partNumber	String

---

Returns

data pyDataset

---

Example

# Check current warehouse balances for a specific electrical part
paramsDict = {'partId': 1}

data = _kanoa_.inventory.getPartInventoryBalances(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
lastCountedAtUtc None
notes None
partId 1
manufacturerName Johnson & Johnson
assetTypeName Storage Location
isSerialized True
enabled True
partCategoryId 3
changedDate Wed Jun 10 14:13:14 UTC 2026
partInventoryBalanceId 6
assetPath Kanoa Box Co\Warehouse\Parts Room\Rack A
quantityOnOrder 0.0
changedBy 5
quantityOnHand 271.0
inventoryAssetId 2969
partCategoryPath PCA\A11
isCriticalSpare True
defaultUomId 2
uomCode FT
normalizedPartNumber A123
rowVersion array('b', [0, 0, 0, 0, 0, 0, 54, -34])
manufacturerId 1
isConsumable True
averageUnitCost None
manufacturerPartNumber 123A
isRepairable True
createdDate Wed Jun 10 14:01:38 UTC 2026
createdBy 5
partDescription blah
quantityReserved 0.0
assetName Rack A
partCategoryLevel 1
uomName Foot
partNumber A123
partCategoryName A11
>>>