Sage 50 CA Vendor XML
The following tasks use the Sage 50 CA Vendor XML format.
Tasks
XML Overview
Any Sage fields not documented below are not supported with our imports/exports. Examples of where in the XML the fields should appear are shown in the samples below.
Minimal Vendor File
<?xml version="1.0" encoding="utf-8"?>
<Vendors>
<Vendor>
<Name>Zynk Software</Name>
</Vendor>
</Vendors>
Complete Vendor File
<?xml version="1.0" encoding="utf-8"?>
<Vendors>
<Vendor>
<ExternalId>123</ExternalId>
<Name>Zynk Software</Name>
<CurrencyCode>CAD</CurrencyCode>
<Contact>John Smith</Contact>
<Street1>i6</Street1>
<Street2>6-8 Charlotte Square</Street2>
<City>Newcastle</City>
<Province>Tyne & Wear</Province>
<PostalCode>NE1 4XF</PostalCode>
<Country>Great Britain</Country>
<Phone1>0191 820 1484</Phone1>
<Phone2>0191 820 1484</Phone2>
<Fax>0191 820 1484</Fax>
<Email>[email protected]</Email>
<Website>www.zynk.com</Website>
</Vendor>
</Vendors>
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 Vendors schema is used below as a reference of where fields should be in the object model.
Header Information
The following fields can be populated at the header level of the vendor record.
The vendor name field acts as the unique identifier for vendors in Sage. So you must either provide a name within the XML, or lookup the value. The are 2 ways to look up the value:
- If the vendor has been imported into Sage by Zynk before, and an ExternalId value was provided at the time, providing the same ExternalId value again will allow Zynk to determine the name via our truth table.
- Use the Match Fields task setting to search Sage for a matching vendor based on the value of one or more fields (such as email address or postal code).
| Sage Field | XML Field | Field Type | Input | Notes |
| --- | --- | --- | --- | --- | --- | --- |
| - | ExternalId | string(255) | Optional | Provide the ID of the vendor from the source system |
| Vendor | Name | string(52) | Required | The value can be looked up in Zynk's truth table via the ExternalId, or the 'Match Fields' task setting |
<?xml version="1.0"?>
<Vendors>
<Vendor>
<ExternalId>123</ExternalId>
<Name>Zynk Software</Name>
</Vendor>
</Vendors>
Address Tab
The following fields can be populated on the Address tab of the vendor record.
| Sage Field | XML Field | Field Type | Input | Notes | | --- | --- | --- | --- | --- | --- | --- | | Contact | Contact | string(30) | Optional | | | Street1 | Street1 | string(50) | Optional | | | Street2 | Street2 | string(50) | Optional | | | City | City | string(35) | Optional | | | Province | Province | string(20) | Optional | | | PostalCode | PostalCode | string(9) | Optional | | | Country | Country | string(30) | Optional | | | Phone1 | Phone1 | string(25) | Optional | | | Phone2 | Phone2 | string(25) | Optional | | | Fax | Fax | string(25) | Optional | | | Email | Email | string(50) | Optional | | | Website | Website | string(50) | Optional | |
<?xml version="1.0" encoding="utf-8"?>
<Vendors>
<Vendor>
<Contact>John Smith</Contact>
<Street1>i6</Street1>
<Street2>6-8 Charlotte Square</Street2>
<City>Newcastle</City>
<Province>Tyne & Wear</Province>
<PostalCode>NE1 4XF</PostalCode>
<Country>Great Britain</Country>
<Phone1>0191 820 1484</Phone1>
<Phone2>0191 820 1484</Phone2>
<Fax>0191 820 1484</Fax>
<Email>[email protected]</Email>
<Website>www.zynk.com</Website>
</Vendor>
</Vendors>
Options Tab
The following fields can be populated on the Options tab of the vendor record.
| Sage Field | XML Field | Field Type | Input | Notes | | --- | --- | --- | --- | --- | --- | --- | | Currency | CurrencyCode | string(3) | Optional | Specify the 3 letter currency ISO code |