Integration between Ongoing Warehouse and Tripletex
Table of contents
Introduction
Ongoing Warehouse has developed an integration with the ERP system Tripletex. This integration makes it possible for businesses which use Tripletex to easily outsource their warehouse needs to a 3PL company which uses the Ongoing Warehouse WMS. The integration can also be used by businesses who run Tripletex and who want to run their own warehouse using the Ongoing Warehouse WMS. By passing information electronically between Tripletex and Ongoing Warehouse, many manual tasks concerning products and orders are eliminated or reduced. As a complement to the integration, users of Tripletex can also be given direct access to the WMS.
The integration works well together with the Ongoing workflow. It uses the Tripletex API. Most functions run every 15 minutes, but some functions are based on user actions.
Note that the information in this document might differ from your particular integration, if any special requests were made during the implementation of the integration.
Scheduled functions
Some functions in the integration run on a schedule. Products and orders are synced automatically from Tripletex to Ongoing Warehouse.Article registry
Products are read automatically from Tripletex to Ongoing Warehouse. If a change is made in Tripletex, it will be reflected automatically in Ongoing Warehouse.
Field mapping
| Ongoing Warehouse field name | Tripletex field name |
|---|---|
| Article ⇒ Article number | Product ⇒ Number |
| Article ⇒ Name | Product ⇒ Name |
| Article ⇒ Customer price | Product ⇒ Price including vat currency |
| Article ⇒ Free decimal 1 | Product ⇒ Version |
| Article ⇒ Is stock article | Product ⇒ Is stock item |
| Article ⇒ Price | Product ⇒ Price excluding vat currency |
| Article ⇒ Product code | Product ⇒ Id |
| Article ⇒ Purchase currency code | Product ⇒ Currency ⇒ Code |
| Article ⇒ Purchase price | Product ⇒ Cost excluding vat currency |
Filters
By default, all products that have been updated in Tripletex will be synced to Ongoing. To check if a product has been updated the version value of the product is compared to FreeDecimal1 of the article definition in Ongoing.
Orders
Orders are read automatically from Tripletex to Ongoing Warehouse.
Field mapping
| Ongoing Warehouse field name | Tripletex field name |
|---|---|
| Order info ⇒ Delivery instruction | Order ⇒ Delivery comment |
| Order info ⇒ Delivery date | Order ⇒ Delivery date |
| Order info ⇒ Goods owner order id | Order ⇒ Id |
| Order info ⇒ Goods owner order number | Order ⇒ Number |
| Customer ⇒ Address | Customer ⇒ Postal Address ⇒ Address line 1 |
| Customer ⇒ Address2 | Customer ⇒ Postal address ⇒ Address line 2 |
| Customer ⇒ City | Customer ⇒ Postal address ⇒ City |
| Customer ⇒ Country code | Customer ⇒ Postal address ⇒ Country ⇒ ISO 3166-1 alpha-2 code |
| Customer ⇒ Customer number | Customer ⇒ Customer number |
| Customer ⇒ Email | Customer ⇒ Email |
| Customer ⇒ External customer code | Customer ⇒ Id |
| Customer ⇒ Mobile | Customer ⇒ Phone number mobile |
| Customer ⇒ Name | Customer ⇒ Name |
| Customer ⇒ Post code | Customer ⇒ Postal address ⇒ Postal code |
| Customer ⇒ Remark | Customer ⇒ Description |
| Customer ⇒ Telephone | Customer ⇒ Phone number |
| Order line ⇒ Article number | Order line ⇒ Order line ⇒ Product ⇒ Number |
| Order line ⇒ Currency code | Order line ⇒ Currency ⇒ Code |
| Order line ⇒ External order line code | Order line ⇒ Id |
| Order line ⇒ Line price | Order line ⇒ Amount including vat currency |
| Order line ⇒ Number of items | Order line ⇒ Count |
| Order line ⇒ Order line comment | Order line ⇒ Description |
| Order line ⇒ Product code | Order line ⇒ Product ⇒ Id |
Filters
By default, any orders matching the following filter in Tripletex is synced to Ongoing. Note that if the order exists in Ongoing it will only be updated if the status of the order in Ongoing allows it to be updated!
| Tripletex field name | Default filter |
|---|---|
| Order ⇒ Is closed | false |
| Order ⇒ Last change time | Later than the last time the integration synced |
Functions based on user actions
Outbound deliveries
When an order has been set to status Sent or Collected in Ongoing a call is sent to the Tripletex API to close the order. It is possible in this step to create an invoice of the order in Tripletex.
Field mapping
| Ongoing Warehouse field name | Tripletex field name |
|---|---|
| Order ⇒ Order info ⇒ Goods owner order id | Order ⇒ Id |
Preparations
In order to configure this integration Onogoing Warehouse will need a user key ID to the Tripletex API. Using this key Ongoing Warehouse will create a session token for accessing the API. This user key is generated by navigating to the profile of the user in Tripletex. Then click on the field "API access" (which might be hidden below the "More" button). Press the button "New key" to generate a new key. Check the option for "Tilpasset oppsett", provide all assets and use "OngoingWarehouse" as the application name. The key that will be created is the one that Ongoing Warehouse needs to set up the integration. Note: The need for providing all assets will soon be removed.