Lemonsoft logo

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. Contact us to learn more.

Note that the information in this document might differ from your integration if any special requests were made during the implementation of the integration.

Getting started

  1. 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.
  2. 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
  3. 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

Show field mapping

Ongoing WMS field name Lemonsoft field name
Article ⇒ Article numberProduct ⇒ SKU
Article ⇒ NameProduct ⇒ Name
Article ⇒ BarcodeProduct ⇒ EAN code
Article ⇒ Product codeProduct ⇒ ID
Article ⇒ DescriptionProduct ⇒ Extra name
Article ⇒ PriceProduct ⇒ Price
Article ⇒ Customer priceProduct ⇒ Sales price taxful
Article ⇒ HeightProduct ⇒ Height
Article ⇒ WidthProduct ⇒ Width
Article ⇒ LengthProduct ⇒ 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

Show field mapping

Ongoing WMS field name Lemonsoft field name
Order info ⇒ Goods owner order IDOrder ⇒ Id
Order info ⇒ Order numberOrder ⇒ Number
Order info ⇒ Delivery dateOrder ⇒ Delivery date
Order info ⇒ Order remarkOrder ⇒ Description
Order info ⇒ Delivery instructionOrder ⇒ Delivery text
Order info ⇒ Invoice numberOrder ⇒ Invoice reference
Order info ⇒ Reference numberOrder ⇒ Our reference
Customer ⇒ NameOrder ⇒ Delivery customer name + Delivery customer name2
Customer ⇒ AddressOrder ⇒ Delivery customer address
Customer ⇒ Address2Order ⇒ Delivery customer address2
Customer ⇒ Address3Order ⇒ Delivery customer address3
Customer ⇒ EmailOrder ⇒ Delivery customer contact email
Customer ⇒ Mobile phoneOrder ⇒ Delivery customer contact phone
Customer ⇒ Country codeOrder ⇒ Delivery customer country
Order line ⇒ Product codeOrder row ⇒ Product code
Order line ⇒ Article NameOrder row ⇒ Product name
Order line ⇒ Customer line priceOrder row ⇒ Total
Order line ⇒ CurrencyOrder row ⇒ Unit net currency
Order line ⇒ DiscountOrder row ⇒ Discount
Order line ⇒ External Order line IDOrder row ⇒ ID
Order line ⇒ Number of ItemsOrder row ⇒ Quantity
Order line ⇒ Order line serialOrder 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.

Show filters

Lemonsoft field name Default filter
Order ⇒ Last change timeLater than the last time the integration synced
Order row ⇒ LocationThe location selected on the integrations page

Purchase orders

Purchase orders are read automatically from Lemonsoft to Ongoing WMS.

Field mapping

Show field mapping

Ongoing WMS field name Lemonsoft field name
Order info ⇒ Order numberPurchase order ⇒ Order number
Order info ⇒ Order RemarkPurchase order ⇒ Description
Order info ⇒ Goods owner referencePurchase order ⇒ Our reference
Order info ⇒ In datePurchase order ⇒ Delivery date
Order info ⇒ Order datePurchase order ⇒ Purchase order date
Order line ⇒ Article NamePurchase order row ⇒ Product name
Order line ⇒ Product CodePurchase order row ⇒ Product code
Order line ⇒ External Order line codePurchase order row ⇒ ID
Order line ⇒ Number of ItemsPurchase order row ⇒ Quantity
Order line ⇒ Order line commentPurchase order row ⇒ Note
Order line ⇒ In order line serialPurchase 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.

Show filters

Lemonsoft field name Default filter
Purchase order ⇒ Last change timeLater than the last time the integration synced
Purchase order row ⇒ LocationThe 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.