Sage 200 Evolution Supplier Transaction XML

The Sage 200 Evolution Supplier Transaction XML format is used to create new supplier transactions in Sage 200 Evolution. The same task and XML format is used for all transaction types.

Tasks

• Export Supplier Transactions from Sage 200 Evolution
• Import Supplier Transactions into Sage 200 Evolution

Minimal Supplier Transaction XML

The XML below represents the minimum information required to create a supplier transaction.

<?xml version="1.0" encoding="utf-8"?>
<SupplierTransactions>
  <SupplierTransaction>
    <Amount>18.00</Amount>
    <Supplier>
      <Code>ZYNK0001</Code>
    </Supplier>
    <Reference>12345</Reference>
    <TransactionCode>
      <Module>AR</Module>
      <Code>PM</Code>
    </TransactionCode>
  </SupplierTransaction>
</SupplierTransactions>

Supplier Transaction

The following information can be specified in the XML for a supplier transaction.

The supplier to import the transaction against can either be specified by Code, or can be looked up via ExternalId in the Truth Database if the supplier was imported into Sage via Zynk.

If the Prevent Reprocessing setting is enabled Zynk will check to see if the ExternalId provided in the XML has already been imported. If the record has already been processed it will be skipped, and output to the Fail File.

Sage Field	XML Field	Example	Field Type	Input
N/A	ExternalId	123	String	Optional
Credit/Debit	Amount	18.00	Double	Required
Branch	Branch/Code	UK	String	Optional
Credit	Credit	18.00	Double	Optional
Supplier	Supplier/ExternalId	12345	String	Dependant
Supplier	Supplier/Code	ZYN001	String	Dependant
Date	Date	2021-11-15	DateTime	Optional
Debit	Debit	0.00	Double	Optional
Description	Description	Payment received	String	Optional
N/A	ExchangeRate	1.0000	Double	Optional
N/A	ExtOrderNo	12345	String	Optional
N/A	ForeignAmount	18.00	Double	Optional
N/A	ForeignTax	0.00	Double	Optional
N/A	ModId*	Inv	Enum	Optional
N/A	OrderNo	12345	String	Optional
Ledger Account	OverrideCreditAccount/Code	4000	String	Optional
Ledger Account	OverrideDebitAccount/Code	5000	String	Optional
Project	Project/Code	PROJ001	String	Optional
Reference	Reference	12345	String	Required
Reference 2	Reference2	12345	String	Optional
N/A	SettlementTerms/Code	30DAYSNET	String	Optional
N/A	Tax	0.00	Double	Optional
N/A	TaxRate/Code	EXEMPT	String	Optional
Code	TransactionCode/Module*	AR	Enum	Required
Code	TransactionCode/Code	PM	String	Required

*ModId - Enum values: Tax, TaxAR, TaxAP, Bnk, Oth, JL, CB, CBAR, CBAP, SADJ, IJr, AcPrf, Inv, Crn, Grv, Rts, APTx, ARTx, OInv, OGrv, BOM, WTrf, WIBTI, WIBTR, JCI, JCS, JCG, JCM, POS, POSI, POSC, MFDR, MFRT, MFMF, MFWA, MFR4MF, MFBP, MFRP, MFUM, MFVAI, MFVAO, MFR4UNMF, BtAR, BtAP, RPOS, PURGE
*TransactionCode/Module - Enum values: GL, AR, AP, Inventory, JobCosting, Unknown

<?xml version="1.0" encoding="utf-8"?>
<SupplierTransactions>
  <SupplierTransaction>
    <ExternalId>123</ExternalId>
    <Amount>18.00</Amount>
    <Branch>
      <Code>UK</Code>
    </Branch>
    <Credit>18.00</Credit>
    <Customer>
      <ExternalId>12345</ExternalId>
      <Code>ZYN001</Code>
    </Customer>
    <Date>2021-11-15</Date>
    <Debit>0.00</Debit>
    <Description>Payment received</Description>
    <ExchangeRate>1.0000</ExchangeRate>
    <ExtOrderNo>12345</ExtOrderNo>
    <ForeignAmount>18.00</ForeignAmount>
    <ForeignTax>0.00</ForeignTax>
    <ModId>Inv</ModId>
    <OrderNo>12345</OrderNo>
    <OverrideCreditAccount>
      <Code>4000</Code>
    </OverrideCreditAccount>
    <OverrideDebitAccount>
      <Code>5000</Code>
    </OverrideDebitAccount>
    <Project>
      <Code>PROJ001</Code>
    </Project>
    <Reference>12345</Reference>
    <Reference2>12345</Reference2>
    <SettlementTerms>
      <Code>30DAYSNET</Code>
    </SettlementTerms>
    <Tax>0.00</Tax>
    <TaxRate>
      <Code>EXEMPT</Code>
    </TaxRate>
    <TransactionCode>
      <Module>AR</Module>
      <Code>PM</Code>
    </TransactionCode>
  </SupplierTransaction>
</SupplierTransactions>

Allocations

If an OrderNo or AllocateToReference element is provided in the XML, Zynk will attempt to allocate the transaction.

The OrderNo element will search for outstanding transactions related to the sales order number specified, and will allocate this transaction to them.

The AllocateToReference element will search for outstanding transactions with the specified reference, and will allocate this transaction to them.

Sage Field	XML Field	Example	Field Type	Input
N/A	OrderNo	12345	String	Optional
N/A	AllocateToReference	12345	String	Optional

<?xml version="1.0" encoding="utf-8"?>
<SupplierTransactions>
  <SupplierTransaction>
    <OrderNo>12345</OrderNo>
    <AllocateToReference>12345</AllocateToReference>
  </SupplierTransaction>
</SupplierTransactions>