Integration between Ongoing WMS and 24SevenOffice
Table of contents
Introduction
The integration provides the required functionality to make the logistics information flow seamlessly between 24SevenOffice and Ongoing WMS.
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)
Preparations
For Ongoing WMS to be able to activate the integration this information is needed from the customer:
- 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).