Integration between Ongoing WMS and Finago Office
The WMS integration between Ongoing WMS and Finago Office, previously known as 24SevenOffice, can be utilized by logistics partners (3PL) to onboard new customers with Finago Office as ERP, as well as for companies that operate their own warehouse and that uses Finago Office 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 Finago Office:
- Username and password for the API. The customer can get this information by contacting Finago. Alternatively, a new integration user can be created via the user admin tool in Finago Office. Here you can find out how to add integration user (in Norwegian).
After you have this information, go to Administration->Integrations->New integration and choose Finago Office 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 Finago Office.
Field mapping
| Ongoing WMS field name | Finago Office 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 Finago Office to Ongoing WMS. Ongoing WMS updates the order status in Finago Office to "Sent" when the order has been shipped. There is an option to update status in Finago Office when an order has been imported to Ongoing WMS. This option is switched off by default.
Field mapping
| Ongoing WMS field name | Finago Office 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 Finago Office.
Field mapping
| Ongoing WMS field name | Finago Office 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 Finago Office 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)