Skip to content

Sage 50 CA Account XML

The following tasks use the Sage 50 CA Account XML format.

Tasks

XML Overview

Any Sage fields not documented below are not supported with our export. Examples of where in the XML the fields should appear are shown in the samples below.

Complete Customer File

<?xml version="1.0" encoding="utf-8"?>
<Accounts xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
  <Account>
    <Number>40000</Number>
    <Name>REVENUE: Services</Name>
    <NameAlt>Produit d'exploitaition: Services</NameAlt>
    <Type>H</Type>
    <Class>5000</Class>
    <GifiCode />
    <CurrencyCode>CAD</CurrencyCode>
    <CurrentBalance>0</CurrentBalance>
    <CurrentForeignBalance>0</CurrentForeignBalance>
    <IsActive>true</IsActive>
  </Account>
</Accounts>

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 Accounts schema is used below as a reference of where fields should be in the object model.

Account Information

The following fields can be exported from the header level of the account record.

Sage Field XML Field  Field Type  Input   Notes
Account (Number) Number string(8) Required
Account (Name En) Name string(35) Required
Account (Name Fr) NameAlt string(35) Optional
Type Type string(1) Optional
Class Class int Optional
GIFI Code GifiCode string(8) Optional
Currency CurrencyCode string(3) Optional
Balance CurrentBalance decimal Optional
Foreign Balance CurrentForeignBalance decimal Optional
Inactive Account IsActive bool Optional 
<?xml version="1.0" encoding="utf-8"?>
<Accounts xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
  <Account>
    <Number>40000</Number>
    <Name>REVENUE: Services</Name>
    <NameAlt>Produit d'exploitaition: Services</NameAlt>
    <Type>H</Type>
    <Class>5000</Class>
    <GifiCode />
    <CurrencyCode>CAD</CurrencyCode>
    <CurrentBalance>0</CurrentBalance>
    <CurrentForeignBalance>0</CurrentForeignBalance>
    <IsActive>true</IsActive>
  </Account>
</Accounts>