system.kanoa.inventory.getInventoryTransactions(paramsDict)
Returns inventory transaction records from [inv].[inventoryTransaction], optionally filtered by any combination of the fields in paramsDict.
Passing an empty dictionary returns all inventory transactions.
This is a read-only getter used to look up transaction history for a part, inventory asset, supplier, cost center, or source reference (e.g. a PO or WO).
Parameters
paramsDict Dictionary
| - assetId | Integer | |
| - costCenterId | Integer | |
| - createdBy | Integer | |
| - inventoryAssetId | Integer | |
| - inventoryTransactionId | Integer | |
| - inventoryTransactionTypeId | Integer | |
| - partId | Integer | |
| - referenceNumber | String | |
| - referenceType | String | |
| - sourceRecordId | Integer | |
| - sourceSchemaName | String | |
| - sourceTableName | String | |
| - supplierId | Integer |
Returns
data pyDataset
Example
paramsDict = {'partNumber': 'A123', 'transactionTypeCode': 'ISSUE'}
data = system.kanoa.inventory.getInventoryTransactions(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
costCenterCode None
supplierId None
notes None
partId 3
createdByUser jason
assetTypeName None
referenceType None
transactionTypeCode ISSUE
quantitySign -1
inventoryAssetPath Kanoa Box Co\Warehouse\Parts Room
sourceRecordId 62
changedDate None
lastUpdated Wed Jul 01 19:36:58 UTC 2026
sourceTableName workOrderEvent
costCenterId None
referenceNumber None
assetId None
assetPath None
changedBy None
sourceSchemaName cms
changedByUser None
inventoryAssetId 2968
partCategoryPath BBB
inventoryAssetTypeName Storage Location
supplierName None
lastUpdatedBy jason
quantity 30.0
defaultUomId 2
uomCode FT
inventoryAssetName Parts Room
transactionDate Wed Jul 01 19:36:58 UTC 2026
transactionTypeName Issue from inventory
createdDate Wed Jul 01 19:36:58 UTC 2026
createdBy 5
inventoryTransactionId 26
unitCost None
assetName None
costCenterName None
inventoryTransactionTypeId 2
partNumber A1
>>>