Sage 200 Location XML

The Import Locations task allows you to create and update locations (typically referred to as warehouses) in Sage 200. Locations are matched based on name, if no match is found a new location will be created, otherwise the existing one will be updated.

Tasks

XML

Any Sage fields not documented below are not currently supported with our imports.

Sample import file for creating a location:

<?xml version="1.0" encoding="utf-8"?>
<Company 
  xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  xmlns:xsd="http://www.w3.org/2001/XMLSchema">
  <Locations>
    <Location>
      <Id>LOC001</Id>
      <Name>MISC</Name>
      <Description>Miscellaneous</Description>
      <AllowSalesTrading>true</AllowSalesTrading>
      <Address>
        <Company>Zynk Software</Company>
        <Address1>Office 16</Address1>
        <Address2>6 Charlotte Square</Address2>
        <Address3>Line 3</Address3>
        <Address4>Line 4</Address4>
        <Town>Newcastle</Town>
        <County>Tyne &amp; Wear</County>
        <Postcode>NE1 4XF</Postcode>
        <Country>Great Britain</Country>
        <ContactName>John Smith</ContactName>
        <Telephone>0191 820 1484</Telephone>
        <Fax>0191 820 1484</Fax>
        <Email>[email protected]</Email>
        <Website>www.zynk.com</Website>
      </Address>
      <VatCountryCode>GB</VatCountryCode>
    </Location>
  </Locations>
</Company>

In each of the following sections most of the XML has been omitted to make the samples easier to read. The whole structure of the Company schema is used below as a reference of where fields should be in the object model.

Warehouse Details

Locations are matched based on the name provided in the XML. If no match is found in Sage, a new location will be created, otherwise the existing one will be updated.

XML Field	Sage Field	Example	Field Type	Field Length	Input	Notes
Id	N/A	LOC001	string	255	Optional	The Id will be stored in the truth table
Name	Name	MISC	string	20	Required	Used for matching existing locations in Sage
Description	Description	Miscellaneous	string	50	Optional
AllowSalesTrading	Use for sales trading	true	bool	-	Optional
Address/Company	Postal name	Zynk Software	string	60	Optional
Address/Address1	Address line 1	Office 16	string	60	Optional
Address/Address2	Address line 2	6 Charlotte Square	string	60	Optional
Address/Address3	Address line 3	Line 3	string	60	Optional
Address/Address4	Address line 4	Line 4	string	60	Optional
Address/Town	City	Newcastle	string	60	Optional	Can only be set if segmented addresses are enabled in Sage
Address/County	County	Tyne & Wear	string	60	Optional	Can only be set if segmented addresses are enabled in Sage
Address/Postcode	Postcode	NE1 4XF	string	10	Optional
Address/Country	Country	Great Britain	string	60	Optional	Can only be set if segmented addresses are enabled in Sage
Address/ContactName	Contact	John Smith	string	50	Optional
Address/Telephone	Telephone	0191 820 1484	string	30	Optional
Address/Fax	Fax	0191 820 1484	string	30	Optional
Address/Email	E-mail	[email protected]	string	255	Optional
Address/Website	Web site	www.zynk.com	string	200	Optional
VatCountryCode	VAT country code	GB	string	2	Optional	Provide a 2 letter ISO country code

<?xml version="1.0" encoding="utf-8"?>
<Company 
  xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  xmlns:xsd="http://www.w3.org/2001/XMLSchema">
  <Locations>
    <Location>
      <Id>LOC001</Id>
      <Name>MISC</Name>
      <Description>Miscellaneous</Description>
      <AllowSalesTrading>true</AllowSalesTrading>
      <Address>
        <Company>Zynk Software</Company>
        <Address1>Office 16</Address1>
        <Address2>6 Charlotte Square</Address2>
        <Address3>Line 3</Address3>
        <Address4>Line 4</Address4>
        <Town>Newcastle</Town>
        <County>Tyne &amp; Wear</County>
        <Postcode>NE1 4XF</Postcode>
        <Country>Great Britain</Country>
        <ContactName>John Smith</ContactName>
        <Telephone>0191 820 1484</Telephone>
        <Fax>0191 820 1484</Fax>
        <Email>[email protected]</Email>
        <Website>www.zynk.com</Website>
      </Address>
      <VatCountryCode>GB</VatCountryCode>
    </Location>
  </Locations>
</Company>