Integration between Ongoing WMS and Lemonsoft
Lemonsoft is one of Finlands's most popular financial management systems. Ongoing Warehouse has developed an integration between Lemonsoft and its WMS. By utilizing the integration, you can outsource your logistics handling to a 3PL or fulfillment provider without adding tedious order inputting.
The integration works just as well if you run your own warehouse and with Ongoing WMS you will get an array of new features at your fingertips: batch-picking, obtaining efficient picking routes, creating detailed warehouse maps, perform device-agnostic scanning to reduce pick and pack mistakes, automatic label printing, efficient bulk editing of products and orders, and many more features.
Get started with a free trial of Ongoing WMS today!
Getting started
- Follow the instructions provided by Lemonsoft to generate API keys. The integration requires an API key to be able to fetch information from Lemonsoft to Ongoing WMS.
-
Besides an API key the integration also requires:
- URL to the API
- Username
- Password
- Database
- Location in Lemonsoft that corresponds to the warehouse using Ongoing WMS
- Insert the credentials in Ongoing WMS by navigating to the page Integrations and emails by choosing Lemonsoft in the list of integrations that appear when clicking the button New integration or e-mail.
Note: The selected location will be used to ensure that the integration will only fetch order lines and purchase order lines marked for that specific location in Lemonsoft. This way the integration ensures it will only work with the lines that are meant for the warehouse. The location is also used if the stock sync is activated to ensure the integration updates the quantity in the correct location.
Scheduled functions
Some functions in the integration run on a schedule. Products, orders and purchase orders are synced automatically from Lemonsoft to Ongoing WMS.Product
Products are read automatically from Lemonsoft to Ongoing WMS. If a change is made in Lemonsoft, it will be reflected automatically in Ongoing WMS.
Field mapping
| Ongoing WMS field name | Lemonsoft field name |
|---|---|
| Article ⇒ Article number | Product ⇒ SKU |
| Article ⇒ Name | Product ⇒ Name |
| Article ⇒ Barcode | Product ⇒ EAN code |
| Article ⇒ Product code | Product ⇒ ID |
| Article ⇒ Description | Product ⇒ Extra name |
| Article ⇒ Price | Product ⇒ Price |
| Article ⇒ Customer price | Product ⇒ Sales price taxful |
| Article ⇒ Height | Product ⇒ Height |
| Article ⇒ Width | Product ⇒ Width |
| Article ⇒ Length | Product ⇒ Length |
Filters
By default, all products that have been updated in Lemonsoft since the last time the integration ran will be synced to Ongoing WMS.
Orders
Orders are read automatically from Lemonsoft to Ongoing WMS.
Field mapping
| Ongoing WMS field name | Lemonsoft field name |
|---|---|
| Order info ⇒ Goods owner order ID | Order ⇒ Id |
| Order info ⇒ Order number | Order ⇒ Number |
| Order info ⇒ Delivery date | Order ⇒ Delivery date |
| Order info ⇒ Order remark | Order ⇒ Description |
| Order info ⇒ Delivery instruction | Order ⇒ Delivery text |
| Order info ⇒ Invoice number | Order ⇒ Invoice reference |
| Order info ⇒ Reference number | Order ⇒ Our reference |
| Customer ⇒ Name | Order ⇒ Delivery customer name + Delivery customer name2 |
| Customer ⇒ Address | Order ⇒ Delivery customer address |
| Customer ⇒ Address2 | Order ⇒ Delivery customer address2 |
| Customer ⇒ Address3 | Order ⇒ Delivery customer address3 |
| Customer ⇒ Email | Order ⇒ Delivery customer contact email |
| Customer ⇒ Mobile phone | Order ⇒ Delivery customer contact phone |
| Customer ⇒ Country code | Order ⇒ Delivery customer country |
| Order line ⇒ Product code | Order row ⇒ Product code |
| Order line ⇒ Article Name | Order row ⇒ Product name |
| Order line ⇒ Customer line price | Order row ⇒ Total |
| Order line ⇒ Currency | Order row ⇒ Unit net currency |
| Order line ⇒ Discount | Order row ⇒ Discount |
| Order line ⇒ External Order line ID | Order row ⇒ ID |
| Order line ⇒ Number of Items | Order row ⇒ Quantity |
| Order line ⇒ Order line serial | Order row ⇒ Row serial |
Filters
By default, all orders that have been updated in Lemonsoft since the last time the integration ran will be synced to Ongoing WMS. The order rows will be limited to those that corresponds to the location selected on the integration page in Ongoing WMS to ensure that the warehouse only picks the rows they are meant to pick.
| Lemonsoft field name | Default filter |
|---|---|
| Order ⇒ Last change time | Later than the last time the integration synced |
| Order row ⇒ Location | The location selected on the integrations page |
Purchase orders
Purchase orders are read automatically from Lemonsoft to Ongoing WMS.
Field mapping
| Ongoing WMS field name | Lemonsoft field name |
|---|---|
| Order info ⇒ Order number | Purchase order ⇒ Order number |
| Order info ⇒ Order Remark | Purchase order ⇒ Description |
| Order info ⇒ Goods owner reference | Purchase order ⇒ Our reference |
| Order info ⇒ In date | Purchase order ⇒ Delivery date |
| Order info ⇒ Order date | Purchase order ⇒ Purchase order date |
| Order line ⇒ Article Name | Purchase order row ⇒ Product name |
| Order line ⇒ Product Code | Purchase order row ⇒ Product code |
| Order line ⇒ External Order line code | Purchase order row ⇒ ID |
| Order line ⇒ Number of Items | Purchase order row ⇒ Quantity |
| Order line ⇒ Order line comment | Purchase order row ⇒ Note |
| Order line ⇒ In order line serial | Purchase order row ⇒ Row serial |
Filters
By default, all purchase orders that have been updated in Lemonsoft will be synced to Ongoing WMS. The purchase order rows will be limited to those that corresponds to the location selected on the integration page in Ongoing WMS to ensure that the warehouse is only advised to receive the rows they are meant to receive.
| Lemonsoft field name | Default filter |
|---|---|
| Purchase order ⇒ Last change time | Later than the last time the integration synced |
| Purchase order row ⇒ Location | The location selected on the integrations page |
Functions based on user actions
Outbound deliveries
When an order has been set to status Sent or Collected in Ongoing WMS a call is sent to the Lemonsoft API to update the invoice to "sent" status.
Inbound deliveries
When a delivery is made to the warehouse, this will be recorded on a purchase order. This triggers an update of the purchase order in Lemonsoft, where the received amount for each purchase order line will be updated. It is possible that the received quantities differ from the advised quantities.
Stock synchronization
By activating the stock synchronization the stock from Ongoing will be used to update the stock in Lemonsoft. The stock that will be updated in Lemonsoft is the in stock value.
Note that the information in this document might differ from your integration if any special requests were made during the implementation of the integration.