system.kanoa.inventory.getPartInventoryTotals(paramsDict)

Returns aggregate part inventory totals (summary/rollup figures per part) filtered by part-level attributes such as whether the part is enabled, consumable, repairable, or serialized, its category, its identifier, or its part number. All parameters are optional filters passed in a single dictionary; omitting paramsDict keys, or passing an empty dictionary, returns totals for all parts.

---

Parameters

paramsDict Dictionary

- enabled	Boolean
- isConsumable	Boolean
- isRepairable	Boolean
- isSerialized	Boolean
- partCategoryPath	String
- partId	Integer
- partNumber	String

---

Returns

data pyDataset

---

Example

paramsDict = {
	'isConsumable': True,
	'enabled': True,
	'partCategoryPath': 'PCA\A11',
}

data = system.kanoa.inventory.getPartInventoryTotals(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
notes None
partId 1
createdByUser jason
manufacturerName Johnson & Johnson
isSerialized True
enabled True
partCategoryId 3
totalInventoryValue 0.0
changedDate Sun May 17 21:04:20 UTC 2026
changedBy 5
changedByUser jason
partCategoryPath PCA\A11
isCriticalSpare True
totalQuantityAvailable 3260.0
uomCode FT
defaultUomId 2
normalizedPartNumber A123
totalQuantityOnHand 3260.0
manufacturerId 1
isConsumable True
manufacturerPartNumber 123A
isRepairable True
createdDate Sun May 17 20:40:39 UTC 2026
createdBy 5
partDescription blah
partCategoryLevel 1
uomName Foot
partNumber A123
partCategoryName A11
totalQuantityOnOrder 0.0
totalQuantityReserved 0.0
>>>