My Products
Help
Snuffsis
CONTRIBUTOR ***

InventoryItem Warehouse changes

by Snuffsis

We are trying to get all inventory where there has been changes to the quantity in the inventory items warehouses. Can't find any endpoint where it's possible to filter and get only items where the stock has been changed.

 

Is it possible at all, and if not, is it something that might be requested?

We don't really want to get the entire inventory stock for certain customers, as some can have thousands and thousands of items. Which would take a long time.

 

We have checked endpoints:

warehouse, inventoryadjustment/issue/summary(only works for specific item)/inventory, stocktake. 

2 REPLIES 2
Yıldırım
VISMA

by Yıldırım (Updated ‎26-08-2021 11:57 by Yıldırım VISMA )

Hello,

 


@Snuffsis wrote:

We are trying to get all inventory where there has been changes to the quantity in the inventory items warehouses. Can't find any endpoint where it's possible to filter and get only items where the stock has been changed.Is it possible at all, and if not, is it something that might be requested?


currently, we don't have a webhook implemented for tracking the "Stock Changes" therefore it's not possible to trigger a specific GET for only fetching the inventories what have been changed.  This improvement has been registered in our backlog.  

 

New implementation requests can be posted and followed at "Ideas" section in the community.


@Snuffsis wrote:

We don't really want to get the entire inventory stock for certain customers, as some can have thousands and thousands of items. Which would take a long time.


In this case, if you'd like to search through all Inventories based on activity instead of a specific one (Inventory Summary)

then the most relevant endpoint would be "Inventory" for the required operation. 

 

Endpoint: GET /controller/api/v1/inventory


e.g:
GET
https://integration.visma.net/API/co.../v1/inventory?
availabilityLastModifiedDateTime=2021-05-07&   (YYYY-MM-DD HH:MM)
availabilityLastModifiedDateTimeCondition=>


Supported comparative operators
>
<
<=
>=

This query parameter should return the inventory items which have had Inventory issue & Inventory Receipt activity based on the released documents in the UI.

The updated field should be [warehouseDetails] "lastModifiedDateTime in the Inventory Endpoint GET response

"warehouseDetails": [
      {
        "isDefault": true,
        "warehouse": "1",
        "quantityOnHand": 174,
        "available": -290,
        "availableForShipment": -4,
        "lastModifiedDateTime": "2019-05-08T10:17:33.92"
      }
    ]

 

We'd also recommend checking and sharing your opinions in the thread that where we're gathering feedback about how the new Inventory Summary Endpoint should be refactored in order to be able to meet the integrations need in a better way.  

Thanks.

Snuffsis
CONTRIBUTOR ***

by Snuffsis

@Yıldırım  skrev:

Hello,

 


@Snuffsis wrote:

We are trying to get all inventory where there has been changes to the quantity in the inventory items warehouses. Can't find any endpoint where it's possible to filter and get only items where the stock has been changed.Is it possible at all, and if not, is it something that might be requested?


currently, we don't have a webhook implemented for tracking the "Stock Changes" therefore it's not possible to trigger a specific GET for only fetching the inventories what have been changed.  This improvement has been registered in our backlog.  

 

New implementation requests can be posted and followed at "Ideas" section in the community.


 I see. that is good to hear.

 

 


@Snuffsis wrote:

We don't really want to get the entire inventory stock for certain customers, as some can have thousands and thousands of items. Which would take a long time.


In this case, if you'd like to search through all Inventories based on activity instead of a specific one (Inventory Summary)

then the most relevant endpoint would be "Inventory" for the required operation. 

 

Endpoint: GET /controller/api/v1/inventory


e.g:
GET
https://integration.visma.net/API/co.../v1/inventory?
availabilityLastModifiedDateTime=2021-05-07&   (YYYY-MM-DD HH:MM)
availabilityLastModifiedDateTimeCondition=>


Supported comparative operators
>
<
<=
>=

This query parameter should return the inventory items which have had Inventory issue & Inventory Receipt activity based on the released documents in the UI.

The updated field should be [warehouseDetails] "lastModifiedDateTime in the Inventory Endpoint GET response

"warehouseDetails": [
      {
        "isDefault": true,
        "warehouse": "1",
        "quantityOnHand": 174,
        "available": -290,
        "availableForShipment": -4,
        "lastModifiedDateTime": "2019-05-08T10:17:33.92"
      }
    ]

Oh this one i completely glossed over and it it exactly what we want.

Thank you!