Integration between Ongoing WMS and Inventory Planner
Table of contents
Introduction
Inventory Planner is a data-driven tool used for inventory forecasting and optimization. Ongoing Warehouse has developed an integration to Inventory Planner that allows for collecting purchase orders created by Inventory Planner and reporting back to Inventory Planner when the purchase order has been delivered to the warehouse.
Scheduled functions
The integration consists of the following functions which run on a scheduled basis. The scheduled processes can be independently switched on or off to match the expected functionality.
Sync purchase orders
Purchase orders are read automatically from Inventory Planner to Ongoing WMS after creation in Inventory Planner. Ongoing WMS will try to match the Vendor field of an Inventory Planner purchase order with an already existing supplier. If no such match can be found a new supplier will be created and linked to the purchase order.
Field mapping
| Ongoing WMS field name | Inventory Planner field name |
|---|---|
| Purchase order info ⇒ Goods owner order number | Purchase order ⇒ ID |
| Purchase order info ⇒ Reference number | Purchase order ⇒ Reference |
| Purchase order info ⇒ In date | Purchase order ⇒ Expected date |
| Purchase order info ⇒ Order date | Purchase order ⇒ Created date |
| Purchase order info ⇒ Supplier | Purchase order ⇒ Vendor |
| Purchase order line ⇒ Article number | line ⇒ Sku |
| Purchase order line ⇒ External order line ID | line ⇒ ID |
| Purchase order line ⇒ Article name | line ⇒ Title |
| Purchase order line ⇒ Number of items | line ⇒ Replenishment |
Filters
By default, all orders that have been created in the last 15 minutes in Inventory Planner are synced to Ongoing WMS. Note that only orders with status Open will be synced to Ongoing WMS.
Report purchase orders
Purchase orders are automatically updated from Ongoing WMS to Inventory Planner when they have been received and processed.
Field mapping
| Ongoing WMS field name | Inventory Planner field name |
|---|---|
| Received purchase order line ⇒ External order line id | Item ⇒ ID |
| Received purchase order line ⇒ Received number of items | Item ⇒ Received |
Filters
By default, all orders that have been updated in the last 15 minutes in Ongoing WMS is synced to Inventory Planner. Note that only orders that have been processed in Ongoing WMS and are in status Received (or Deflection) will be reported back by default.
Preparations
To activate and use the integration to Inventory Planner the following setup and information is necessary.
- To start generating inventory predictions Inventory Planner will need information about your sales and articles. This information can currently be provided either through an integration to one of the web shops mutually supported by Inventory Planner and Ongoing WMS or by CSV/Excel file exports and imports.
- API key and Account Id of your Inventory Planner system. This information can be found in your Inventory Planner account, at Account ⇒ Settings ⇒ API. For further information see the Inventory Planner help pages or contact Inventory Planner.