WMS Integration  Topic is solved

Discussions relating to the REST API of Jiwa 7.

WMS Integration

Postby JiwaNewb » Thu Sep 05, 2019 5:02 pm

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
JiwaNewb
I'm new here
I'm new here
 
Posts: 5
Joined: Thu Sep 05, 2019 4:35 pm

Re: WMS Integration  Topic is solved

Postby Scott.Pearce » Thu Sep 05, 2019 5:28 pm

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
Scott Pearce
Senior Analyst/Programmer
Jiwa Financials
User avatar
Scott.Pearce
Senpai
Senpai
 
Posts: 742
Joined: Tue Feb 12, 2008 11:27 am
Location: New South Wales, Australia
Topics Solved: 221


Return to REST API

Who is online

Users browsing this forum: No registered users and 1 guest

cron