Integration between Ongoing WMS and PowerOffice Go
Ongoing has developed an integration with the ERP system PowerOffice Go. This integration makes it possible for businesses which use PowerOffice Go to easily outsource their warehouse needs to a 3PL company which uses Ongoing WMS. The integration can also be used by businesses who run PowerOffice Go and who want to run their own warehouse using Ongoing WMS. By passing information electronically between PowerOffice Go and Ongoing WMS, many manual tasks concerning products and invoices are eliminated or reduced. As a complement to the integration, users of PowerOffice Go can also be given direct access to the WMS.
The integration works well together with the Ongoing workflow. It uses the PowerOffice Go API.
Note that the information in this document might differ from your integration if any special requests were made during the implementation of the integration.
Table of contents
Scheduled functions
Products and invoices are synced automatically from PowerOffice Go to Ongoing WMS, every 15 minutes.Article registry
Products are read automatically from PowerOffice Go to Ongoing WMS. If a change is made in PowerOffice Go, it will be reflected automatically in Ongoing WMS.
Filters
By default, all products that have been updated in PowerOffice Go will be synced to Ongoing WMS.
Field mapping
| Ongoing WMS field name | Power Office Go field name |
|---|---|
| ArticleDefinition ⇒ ArticleNumber | Product ⇒ Code |
| ArticleDefinition ⇒ ArticleName | Product ⇒ Name |
| ArticleDefinition ⇒ CustomerPrice | Product ⇒ SalesPrice |
| ArticleDefinition ⇒ PurchasePrice | Product ⇒ CostPrice |
| ArticleDefinition ⇒ BarCode | Product ⇒ Gtin |
| ArticleDefinition ⇒ ArticleDescription | Product ⇒ Description |
| ArticleDefinition ⇒ ArticleUnitCode | Product ⇒ Unit |
| ArticleGroup | Set to the first product group on the product |
Invoices
Invoices are read automatically from PowerOffice Go to Ongoing WMS.
Filters
By default, all invoices which are paid will be synced to Ongoing WMS.
Field mapping
| Ongoing WMS field name | Power Office Go field name |
|---|---|
| OrderInfo ⇒ GoodsOwnerOrderId | Invoice ⇒ Invoice id |
| OrderInfo ⇒ GoodsOwnerOrderNumber | Invoice ⇒ Order no |
| OrderInfo ⇒ DeliveryDate | Invoice ⇒ DeliveryDate (if set, else current date) |
| OrderInfo ⇒ TermsOfDeliveryType | Invoice ⇒ DeliveryTerm |
| OrderInfo ⇒ ProductionCode | Invoice ⇒ DocumentNo |
| OrderInfo ⇒ ReferenceNumber | Invoice ⇒ CustomerReference |
| OrderInfo ⇒ OrderNotification ⇒ Email | Invoice ⇒CustomerEmail |
| OrderInfo ⇒ OrderNotification ⇒ NotifyByEmail | Set to true if CustomerEmail is set |
| OrderInfo ⇒ OrderNotification ⇒ MobilePhone | Invoice ⇒Customer ⇒ PhoneNumber |
| OrderInfo ⇒ OrderNotification ⇒ NotifyBySms | set to true if PhoneNumber is set |
| Customer ⇒ Number | Customer ⇒ MailAddress/StreetAddress** ⇒ CustomerCode |
| Customer ⇒ Name | customer ⇒ MailAddress/StreetAddress** ⇒ Leagal Name + Name + LastName |
| Customer ⇒ Address | customer ⇒ MailAddress/StreetAddress** ⇒ Address1 |
| Customer ⇒ Address2 | customer ⇒ MailAddress/StreetAddress** ⇒Address2 |
| Customer ⇒ PostCode | customer ⇒ MailAddress/StreetAddress** ⇒ZipCode |
| Customer ⇒ City | customer ⇒ MailAddress/StreetAddress** ⇒ City |
| Customer ⇒ CountryCode | customer ⇒ mailAddress/StreetAddress** ⇒ CountryCode |
| Orderline ⇒ ExternalOrderLineCode | Invoice ⇒ Invoice Line ⇒ Id |
| Orderline ⇒ ArticleNumber | Invoice ⇒ Invoice Line ⇒ ProductCode |
| Orderline ⇒ NumberOfItems | Invoice ⇒ Invoice Line ⇒ Qty |
| Orderline ⇒ LinePrice | Invoice ⇒ Invoice Line ⇒ Qty * UnitPrice |
| Orderline ⇒ CurrencyCode | Invoice ⇒ CurrencyCode |
| Orderline ⇒ Discount | Invoice → Invoice Line ⇒ DiscountPercent |
| Orderline ⇒ CustomerLinePrice | Invoice → Invoice Line ⇒ NetAmount |
| Orderline ⇒ LinePrice | Invoice → Invoice Line ⇒ Qty * UnitPrice |
| Orderline ⇒ OrderLineComment | Invoice → Invoice Line ⇒ Description |
| OrderTextLine ⇒ ExternalOrderLineCode | Invoice ⇒ Invoice Line ⇒ Id |
| OrderTextLine ⇒ NumberOfItems | 1 |
| OrderTextLine ⇒ OrderLineComment | Invoice ⇒ Invoice Line ⇒ Description |
Invoice lines of type text is saved as order text lines in Ongoing WMS, and lines of other types are stored as order lines.
* = effected by filters or settings. The set value might vary, or it might not be used by default.
** = the delivery address is taken from customer ⇒ mailAddress if it is set, else from customer ⇒ streetAddress
Stock balance
Stock balance is sent from Ongoing WMS to PowerOffice Go.
Video on the integration
Getting Started
To configure this integration Ongoing WMS will need an Application Key to the PowerOffice Go API. Please ask PowerOffice to generate these.
Please see this guide on how to set up an integration between PowerOffice Go and your Ongoing WMS.