Description

This document explains how the WMS can automatically IMPORT sales created from external systems using the attached XML file format standard.

Detail Steps

To fully automate XML sales processing, please see the WMS as a Service (WaaS) Support Article for more information on configuration requirements.

Datapel WMS provides OPEN INTEGRATION points allowing system designers to integrate WMS functionality and business information with other business applications.

Examples include:

  • Website Integration - online selling

  • Mobile Sales

This article describes the XML Sale Schema - and is currently used to integrate sale orders from remote sources such as websites and MOBILE Point-Of-Sale systems.

SaleOrderSchema:

The following is an example XML Sale Order

  
  
  GTP
  001
  2009-04-29T10:12:20+
  164101
  2009-04-29T10:12:20+
  Y
  11
  S
  F
  11
  1
  2
  01
  O
  1900-01-01T00:00:00+11:00
  N
  
  N
  1
  1
  2009-04-25T13:31:35+10:00
  164101
  
  0.0000
  Y
  2008-04-30T17:02:11+10:00
  2008-04-25T13:30:57+10:00
  D1= D2= D3= D4= D5= D6= D7=
  
  N
  
  - 
  GTP
  001
  2009-04-29T00:00:00+10:00
  164101
  0
  320
  1
  9.95
  10.00
  0.0000
  1
  9.95
  0.90
  Clown Dots
  A
  
  0.0000
  3257
  Y
  2009-04-29T10:12:20+10:00
  
  - 
  GTP
  001
  2009-04-29T00:00:00+10:00
  164101
  1
  555
  2
  0.00
  10.00
  0.0000
  1
  0.00
  0.00
  Motherboard
  A
  
  0.0000
  3257
  Y
  2009-04-29T10:12:20+10:00
  
  - 
  GTP
  001
  2008-04-25T00:00:00+10:00
  164101
  1
  Securepay
  9.95
  
  
  A
  0.0000
  
  Y
  2009-04-29T10:12:20+10:00
  
  - 
  GTP
  001
  2009-04-29T10:12:20+10:00
  164101
  gtp test
  174 Hampden Road
  
  NEDLANDS
  6009
  
  1300 856 533
  
  bevan.holman@gtp.com.au
  1
  gtp test
  2009-04-29T10:12:20+11:00
  
  gtp test
  174 Hampden Road
  
  NEDLANDS
  6009
  Y
  2009-04-29T10:12:20+10:00
  
  
CODE

Many required paths in the above MUST BE provided for sales to be correctly consumed by WMS.



Related Information

On order import, no rounding rules applied. Every imported order should be checked and updated in WMS to fix any rounding issues. Go to Sales register > Open imported Order > check and select ''Update sales order''.

The same invoice number will be rejected and is based on TrandsID.

If the external system does not support a PROPERTY, it should be committed, and WMS will substitute a default value where appropriate.