InventoryPlanner logo

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

Show field mapping

Ongoing WMS field name Inventory Planner field name
Purchase order info ⇒ Goods owner order numberPurchase order ⇒ ID
Purchase order info ⇒ Reference numberPurchase order ⇒ Reference
Purchase order info ⇒ In datePurchase order ⇒ Expected date
Purchase order info ⇒ Order datePurchase order ⇒ Created date
Purchase order info ⇒ SupplierPurchase order ⇒ Vendor
Purchase order line ⇒ Article numberline ⇒ Sku
Purchase order line ⇒ External order line IDline ⇒ ID
Purchase order line ⇒ Article nameline ⇒ Title
Purchase order line ⇒ Number of itemsline ⇒ 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

Show field mapping

Ongoing WMS field name Inventory Planner field name
Received purchase order line ⇒ External order line idItem ⇒ ID
Received purchase order line ⇒ Received number of itemsItem ⇒ 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.