Jiwa

Hi all,

We're currently working to integrate a Warehouse Management System (WMS) - we are now working through the Shipments and Bookins end points to integrate all Goods Inwards movements.

Our next item is to synchronise ad-hoc stock adjustments e.g. cycle count adjustments, stock write-offs that are initiated in the WMS.

The end points to use for this are not obvious - do they exist? We're hoping for functions to:

1. Get all JIWA stock levels by warehouse (we'd use this for an overnight validation that stock levels are in sync)
2. Update stock quantities e.g. if we write off stock due to expiry dates in the WMS, how can we sync this with Jiwa

Any assistance much appreciated.

Thanks,
Clay

Hi Clay,

1. There are a number of AutoQueries you can use:

/Queries/IN_WarehouseSOH (Demo: https://api.jiwa.com.au/Queries/IN_WarehouseSOH?apikey=9vjoF4M5-gYVBWjoFyW9nlQieB9FhxpJkAsRJznB_Ok)

/Queries/v_Jiwa_Inventory_Item_ListQuery (Demo (first 10 records): https://api.jiwa.com.au/Queries/InventoryItemList?fields=InventoryID,PartNo,IN_LogicalID,LogicalWarehouseDescription,IN_PhysicalID,PhysicalWarehouseDescription,AvailableStock&Take=10&apikey=9vjoF4M5-gYVBWjoFyW9nlQieB9FhxpJkAsRJznB_Ok)


2. You can use Stock Transfers to move stock quantities in and out of Jiwa. The route is at /StockTransfers/

Hope this helps,

Scott