All Collections
Xero Integration
Setting up Xero
Required Tasks in Xero to Setup WMS
Required Tasks in Xero to Setup WMS

Creating required WMS Items in Xero

Updated over a week ago

Creating required WMS Items in Xero

Description

WMS requires two specific items in Xero for a WMS Comment Line and to manage adjustment costs that need to be posted to Xero. This document explains how to create the required WMS items in Xero.

Detailed Steps

1. Create new Item in Xero for WMS Comment Line

  • Create new item via Business – Products and services

  • \c as the Code

  • WMS Comment Line as the Name

  • Set this as both Purchase and Sell only and assign to required account

2. Create new Item in Xero for WMS Shrinkage Line

  • Create new item via Business – Products and services

  • \shrinkage as the Code

  • WMS Shrinkage Line as the Name

  • Set this as both Purchase and Sell only and assign to required account


Creating WMS Locations in Xero

Description

WMS requires at least one Location Contact in Xero to manage the location of your inventory in your WMS. This document explains how to create a new location contact in Xero.

Detailed Steps

1. Create a new Supplier Contact in Xero.

2. The name of the contact can be any name you like; however, we recommend you start the name with a common thread such as "LOC-" to group all the locations in your Xero file.

3. Set the Account number. This is the name you will see in the WMS drop-down list, for example, "COLDSTORE" or "NSW".

4. Enter the Warehouse address and contact details, including a contact name. The location will not be created without it.

5. On the Contact details TAB, set the Primary Person Last name to “datapel.location”

Workflow Restrictions

  • Location contacts should never be deleted, they may however be hidden from users and disabled in the WMS in the tools, locations, manage details menu.

  • Note that BINS are not created within Xero. These are managed from the WMS.

  • The Primary Person Last Name must be set to “datapel.location”

  • For location to work in WMS, it needs minimum of the Street address to be filled up.


Creating WMS required Customer and Supplier Contacts in Xero

Description

WMS requires at least one Customer Contact and one Supplier Contact in Xero. This document explains how to create the contacts in Xero so that they can be used in WMS for sales and purchases.

Detailed Steps

1. Create a new Customer Contact in Xero.

  • The name of the contact can be any name you like

  • Set the unique Account Number

  • Enter the Bill To and Ship To address and contact details.

  • Create and assign to a new group in Xero called “Datapel Customers”

2. Create a new Supplier Contact in Xero.

  • The name of the contact can be any name you like

  • Set the unique Account Number

  • Enter the address and contact details.

  • Create and assign to a new group in Xero called “Datapel Suppliers”


Creating WMS required “Special Pricing Contacts” in Xero

Description

WMS requires THREE “special pricing” contacts in Xero that are used with the Special Pricing Module in WMS. This document explains how to create the contacts in Xero.

Detailed Steps

1. Create a new Customer Contact in Xero.

  • The name of the contact MUST be “#ALLCUSTOMERS

  • Set the unique Account Number to also be “#ALLCUSTOMERS

  • Assign to the group in Xero called “Datapel Customers”

  • No other contact details are required

2. Create a new Supplier Contact in Xero.

  • The name of the contact MUST be “#ALLSUPPLIERS

  • Set the unique Account Number to also be “#ALLSUPPLIERS

  • Assign to the group in Xero called “Datapel Suppliers”

  • No other contact details are required

3. Create a new Supplier Contact in Xero.

  • The name of the contact MUST be “#ALLLOCATIONS

  • Set the unique Account Number to also be “#ALLLOCATIONS

  • On the Contact details TAB, set the Primary Person Last name to “datapel.location”

  • Assign to the group in Xero called “Datapel Suppliers”

  • No other contact details are required

Did this answer your question?