Integration between Ongoing WMS and 24SevenOffice
The WMS integration between Ongoing WMS and 24SevenOffice can be utilized by logistics partners (3PL) to onboard new customers with 24SevenOffice as ERP, as well as for companies that operate their own warehouse and that uses 24SevenOffice as ERP.
With Ongoing WMS you can enjoy new features such as batch-picking, efficient picking routes, device-agnostic scanning to reduce errors, automatic label printing, bulk product editing, and much more.
Table of contents
Getting started
To be able to activate the integration this information is needed from 24SevenOffice:
- Username and password for the API. The customer can get this information by contacting 24SevenOffice. Alternatively, a new integration user can be created via the user admin tool in 24SevenOffice. Here you can find out how to add integration user (in Norwegian).
After you have this information, go to Administration->Integrations->New integration or email and choose 24SevenOffice in the list. If you need help with settings etc, please contact your Ongoing representative.
Features
The integration contains the following processes. They can be independently switched on or off.
Article registry
Ongoing WMS pulls article registry updates from 24SevenOffice.
Field mapping
| Ongoing WMS field name | 24SevenOffice field name |
|---|---|
| ArticleDefinition ⇒ ProductCode | Product ⇒ Id |
| ArticleDefinition ⇒ ArticleNumber | Product ⇒ No |
| ArticleDefinition ⇒ ArticleName | Product ⇒ Name |
| ArticleDefinition ⇒ ArticleDescription | Product ⇒ Description |
| ArticleDefinition ⇒ BarCode | Product ⇒ EAN1 |
| ArticleDefinition ⇒ Weight | Product ⇒ Weight |
Sales orders
Ongoing WMS pulls all confirmed sales orders (invoices) from 24SevenOffice to Ongoing WMS. Ongoing WMS updates the order status in 24SevenOffice to "Sent" when the order has been shipped. There is an option to update status in 24SevenOffice when an order has been imported to Ongoing WMS. This option is switched off by default.
Field mapping
| Ongoing WMS field name | 24SevenOffice field name |
|---|---|
| OrderInfo ⇒ GoodsOwnerOrderNumber | InvoiceOrder ⇒ OrderId |
| OrderInfo ⇒ DeliveryDate | InvoiceOrder ⇒ DeliveryDate |
| OrderInfo ⇒ ReferenceNumber | InvoiceOrder ⇒ ReferenceNumber |
| OrderInfo ⇒ SalesCode | InvoiceOrder ⇒ YourReference |
| OrderInfo ⇒ WayOfDelivery | InvoiceOrder ⇒ DeliveryMethod ⇒ Description |
| OrderInfo ⇒ WayOfDeliveryType ⇒ Code | InvoiceOrder ⇒ DeliveryMethod ⇒ Id |
| OrderInfo ⇒ WayOfDeliveryType ⇒ Name | InvoiceOrder ⇒ DeliveryMethod ⇒ Description |
| OrderInfo ⇒ OrderRemark | InvoiceOrder ⇒ InvoiceTitle |
| Customer ⇒ CustomerNumber | InvoiceOrder ⇒ CustomerId |
| Customer ⇒ Name | InvoiceOrder ⇒ CustomerDeliveryName |
| Customer ⇒ Address | deliveryAddress ⇒ Street |
| Customer ⇒ PostCode | deliveryAddress ⇒ PostalCode |
| Customer ⇒ City | deliveryAddress ⇒ PostalArea |
| Customer ⇒ CountryCode | deliveryAddress ⇒ Country |
| Customer ⇒ CountryStateCode | deliveryAddress ⇒ State |
| Customer ⇒ MobilePhone | InvoiceOrder ⇒ CustomerDeliveryPhone * |
| Customer ⇒ TelePhone | InvoiceOrder ⇒ CustomerDeliveryPhone * |
| Customer ⇒ Email | InvoiceOrder ⇒ InvoiceEmailAddress ** |
| Customer ⇒ InvoiceAddress ⇒ name | InvoiceOrder ⇒ CustomerName |
| Customer ⇒ InvoiceAddress ⇒ Address | invoiceAddress ⇒ Street |
| Customer ⇒ InvoiceAddress ⇒ PostCode | invoiceAddress ⇒ PostalCode |
| Customer ⇒ InvoiceAddress ⇒ City | invoiceAddress ⇒ PostalArea |
| Customer ⇒ InvoiceAddress ⇒ CountryCode | invoiceAddress ⇒ Country |
| Customer ⇒ InvoiceAddress ⇒ CountryStateCode | invoiceAddress ⇒ State |
| CustomerOrderLines ⇒ ProductCode | InvoiceRow ⇒ ProductId |
| CustomerOrderLines ⇒ ExternalOrderLineCode | InvoiceRow ⇒ RowId |
| CustomerOrderLines ⇒ NumberOfItems | InvoiceRow ⇒ Quantity |
* If null or empty: try CompanyService phonenumbers.
** If null or empty: try CompanyService email addresses.
Supplier registry
This setting is switched off by default. When it is activated, Ongoing WMS pulls information about the suppliers (companies) when they are updated in 24SevenOffice.
Field mapping
| Ongoing WMS field name | 24SevenOffice field name |
|---|---|
| Supplier ⇒ SupplierNumber | Company ⇒ Id |
| Supplier ⇒ SupplierName | Company ⇒ Name |
| Supplier ⇒ Address ⇒ Address | Company ⇒ Addresses ⇒ Post ⇒ Street |
| Supplier ⇒ Address ⇒ PostCode | Company ⇒ Addresses ⇒ Post ⇒ PostalCode |
| Supplier ⇒ Address ⇒ City | Company ⇒ Addresses ⇒ Post ⇒ City |
| Supplier ⇒ Address ⇒ CountryCode | Company ⇒ Addresses ⇒ Post ⇒ Country |
Stock balance updates
Ongoing WMS writes the stock quantity to 24SevenOffice if the stock levels between the systems differ. This makes sure that you always have accurate stock levels and that you do not sell anything that is out of stock.
Default settings and considerations
The following needs to be considered before Ongoing WMS can activate the integration.-
Synchronization interval.
Default: Every 15 minutes. It is usually a suitable balance between responsiveness and band-width usage. -
Do you have variations of the same article in the ERP system? E.g. different colors, sizes and packaging.
Default: No. -
Which status should sales orders have to be pulled to the WMS?
Default: Confirmed. -
Should fulfilled orders be notified to the ERP?
Default: Yes. If the answer is yes answering the following questions:-
When should orders be reported to the ERP?
Default: When the sent button is pressed in the WMS. -
Which status should the fulfilled orders be updated to?
Default: Sent.
-
When should orders be reported to the ERP?
-
Should status on orders in the ERP system be updated when they are imported?
Default: No. - Are any other fields required than the above listed? (E.g. pricing information required for customs handling)