Description

This document explains Purchase order Import workflow.

Detail Steps

1. Create two folders below, preferably in WMSDB folder of any drive, example as below:

C:\WMSDB\Import

C:\WMSDB\Import\Processed


2. Set the folders inside Preferences – WMS > Tools > Preferences > Adaptors tab

Remote Sales Import Folder: C:\WMSDB\Import

Processed Archive Folder: C:\WMSDB\Import\Processed

Save the setting by clicking Record Preferences


3. Place the XML or CSV files in C:\WMSDB\Import (the folder in Step 1)


4. Import Purchase Orders – WMS > File > Import > Remote > Purchases


5. Select Location, and then click Import Orders

6. Once complete, it will show in Status Reporter, example as below:


XML file format (example)


<NewDataSet>
<tREMOTETransHeader>
<Company_ID>DATAPEL</Company_ID>
<StoreCode/>
<PostingDate>2013-02-06T00:00:00+</PostingDate>
<TransID/>
<TransDate>2013-02-06T15:33:32+</TransDate>
<CardIdentification>SUPP000001</CardIdentification>
<Notes>5</Notes>
</tREMOTETransHeader>
<tREMOTETransRecLines>
<LineNumber>001</LineNumber>
<SKU>101248SR</SKU>
<LineQty>4.000</LineQty>
<SKUDescription>10mm Span 600 PBoard 4800x1200</SKUDescription>
</tREMOTETransRecLines>
</NewDataSet>

If need to perform testing, use the sample Purchase Order XML to test Import purchase

  • change the CardIdentification (Supplier ID) and SKU (Item Number) and PostingDate, TransDate (Date) 
  • File > Import > Remote > Purchases


Related Information

Below document explains each Tag format and functions required to provide a well-formed XML Customer sale/Purchase order as input to WMS.

KB - Import - Customer Order Specifications for Sales and Purchases

Import - Customer Order Specifications for Sales and Purchases