Importing Transactions into Sage 50 UK

This task will import most types of audit trail transactions to Sage 50 that is supplied in Sage 50 UK Transaction XML format.

Settings

Sage 50 Connection

Required
The connection to Sage 50 UK to use. See the Connecting to Sage 50 UK article if you require more information on how to create/manage connections.

Fail File

Required
The name of a file for "failed" imports to be sent to

Input File

Required
The source file that you want to import in Zynk XML format

Success File

Required
The name of a file for "successful" imports to be sent to.

Auto Allocate Transactions

Required
Attempt auto-allocation of SR, SA, PA or PP transactions by matching to to an Invoice with the same Account Ref and Reference.

Prevent Duplicates

Required
Set this to 'True' to check whether the record Id supplied in the input XML file has already been imported, and if so skip the record.

Zynk Settings

See Common Task Settings

Examples

Sample input file, for full documentation and samples see Sage 50 UK Transaction XML:

<?xml version="1.0"?>
<Company
  xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  xmlns:xsd="http://www.w3.org/2001/XMLSchema">
  <Transactions>
    <Transaction>
      <Id>631</Id>
      <TransactionType>SalesInvoice</TransactionType>
      <AccountReference>ABS001</AccountReference>
      <CustomerId>232</CustomerId>
      <TransactionDate>2009-03-02T00:00:00</TransactionDate>
      <NominalCode>4000</NominalCode>
      <Department>1</Department>
      <Reference>35</Reference>
      <PaymentReference />
      <Details>AT Mini Tower Case</Details>
      <NetAmount>12.56</NetAmount>
      <TaxCode>1</TaxCode>
      <BankReference>1200</BankReference>
      <OssReportType>UnionOSS</OssReportType>
      <OssCountryOfVat>FR</OssCountryOfVat>
    </Transaction>
  </Transactions>
</Company>