Integration between Ongoing Warehouse and 24SevenOffice

Table of contents

Introduction

24SevenOffice is a Norwegian software company who develops and sells their web-based ERP system with the same name. Ongoing Warehouse offers two different integrations between its WMS and 24SevenOffice.
  • Goods owner 3PL WMS integration - Focus on your core business and outsource your fulfillment process to an Ongoing Warehouse-powered third-party logistics provider. Ongoing Warehouse has made that easily achievable by developing an integration between 24SevenOffice and Ongoing WMS. The integration provides the required functionality to make the logistics information flow seamlessly.
  • 3PL invoicing integration - If you are a 3PL provider and use Ongoing Warehouse for your business process and 24SevenOffice for invoicing you may connect Ongoing Warehouse invoicing module to 24SevenOffice. In that way you may export your invoice specification to 24SevenOffice and reduce manual work in your perodic invoicing process. Contact Ongoing Warehouse for more information.

Features

The integration contains the following processes. They can be independently switched on or off.

Article registry

Ongoing Warehouse pulls article registry updates from 24SevenOffice.

Field mapping

Show field mapping

Ongoing Warehouse field name 24SevenOffice field name
ArticleDefinition ⇒ ProductCodeProduct ⇒ Id
ArticleDefinition ⇒ ArticleNumberProduct ⇒ No
ArticleDefinition ⇒ ArticleNameProduct ⇒ Name
ArticleDefinition ⇒ ArticleDescriptionProduct ⇒ Description
ArticleDefinition ⇒ BarCodeProduct ⇒ EAN1
ArticleDefinition ⇒ WeightProduct ⇒ Weight

Sales orders

Ongoing Warehouse pulls all confirmed sales orders (invoices) from 24SevenOffice to Ongoing Warehouse. Ongoing Warehouse 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 Warehouse. This option is switched off by default.

Field mapping

Show field mapping

Ongoing Warehouse field name 24SevenOffice field name
OrderInfo ⇒ GoodsOwnerOrderNumberInvoiceOrder ⇒ OrderId
OrderInfo ⇒ DeliveryDateInvoiceOrder ⇒ DeliveryDate
OrderInfo ⇒ ReferenceNumberInvoiceOrder ⇒ ReferenceNumber
OrderInfo ⇒ SalesCodeInvoiceOrder ⇒ YourReference
OrderInfo ⇒ WayOfDeliveryInvoiceOrder ⇒ DeliveryMethod ⇒ Description
OrderInfo ⇒ WayOfDeliveryType ⇒ CodeInvoiceOrder ⇒ DeliveryMethod ⇒ Id
OrderInfo ⇒ WayOfDeliveryType ⇒ NameInvoiceOrder ⇒ DeliveryMethod ⇒ Description
OrderInfo ⇒ OrderRemarkInvoiceOrder ⇒ InvoiceTitle
Customer ⇒ CustomerNumberInvoiceOrder ⇒ CustomerId
Customer ⇒ NameInvoiceOrder ⇒ CustomerDeliveryName
Customer ⇒ AddressdeliveryAddress ⇒ Street
Customer ⇒ PostCodedeliveryAddress ⇒ PostalCode
Customer ⇒ CitydeliveryAddress ⇒ PostalArea
Customer ⇒ CountryCodedeliveryAddress ⇒ Country
Customer ⇒ CountryStateCodedeliveryAddress ⇒ State
Customer ⇒ MobilePhoneInvoiceOrder ⇒ CustomerDeliveryPhone *
Customer ⇒ TelePhoneInvoiceOrder ⇒ CustomerDeliveryPhone *
Customer ⇒ EmailInvoiceOrder ⇒ InvoiceEmailAddress **
Customer ⇒ InvoiceAddress ⇒ nameInvoiceOrder ⇒ CustomerName
Customer ⇒ InvoiceAddress ⇒ AddressinvoiceAddress ⇒ Street
Customer ⇒ InvoiceAddress ⇒ PostCodeinvoiceAddress ⇒ PostalCode
Customer ⇒ InvoiceAddress ⇒ CityinvoiceAddress ⇒ PostalArea
Customer ⇒ InvoiceAddress ⇒ CountryCodeinvoiceAddress ⇒ Country
Customer ⇒ InvoiceAddress ⇒ CountryStateCodeinvoiceAddress ⇒ State
CustomerOrderLines ⇒ ProductCodeInvoiceRow ⇒ ProductId
CustomerOrderLines ⇒ ExternalOrderLineCodeInvoiceRow ⇒ RowId
CustomerOrderLines ⇒ NumberOfItemsInvoiceRow ⇒ 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 Warehouse pulls information about the suppliers (companies) when they are updated in 24SevenOffice.

Field mapping

Show field mapping

Ongoing Warehouse field name 24SevenOffice field name
Supplier ⇒ SupplierNumberCompany ⇒ Id
Supplier ⇒ SupplierNameCompany ⇒ Name
Supplier ⇒ Address ⇒ AddressCompany ⇒ Addresses ⇒ Post ⇒ Street
Supplier ⇒ Address ⇒ PostCodeCompany ⇒ Addresses ⇒ Post ⇒ PostalCode
Supplier ⇒ Address ⇒ CityCompany ⇒ Addresses ⇒ Post ⇒ City
Supplier ⇒ Address ⇒ CountryCodeCompany ⇒ Addresses ⇒ Post ⇒ Country

Stock balance updates

Ongoing Warehouse 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 Warehouse can activate the integration.
  1. Synchronization interval.
    Default: Every 15 minutes. It is usually a suitable balance between responsiveness and band-width usage.
  2. Do you have variations of the same article in the ERP system? E.g. different colors, sizes and packaging.
    Default: No.
  3. Which status should sales orders have in order to be pulled to the WMS?
    Default: Confirmed.
  4. Should fulfilled orders be notified to the ERP?
    Default: Yes. If the answer is yes answer the following questions:
    1. When should orders be reported to the ERP?
      Default: When the sent button is pressed in the WMS.
    2. Which status should the fulfilled orders be updated to?
      Default: Sent.
  5. Should status on orders in the ERP system be updated when they are imported?
    Default: No.
  6. Should rest orders (also known as back orders) be created in 24SevenOffice if orders can not be fully picked in the WMS?
    Default: No.
  7. Are any other fields required than the above listed? (E.g. pricing information required for customs handling)

Preparations

For Ongoing Warehouse 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.