Sage 200 Evolution Customer Transaction XML

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

Tasks

• Import Customer Transactions into Sage 200 Evolution

Minimal Customer Transaction XML

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

<?xml version="1.0" encoding="utf-8"?>
<CustomerTransactions>
  <CustomerTransaction>
    <Amount>18.00</Amount>
    <Customer>
      <Code>ZYN001</Code>
    </Customer>
    <Reference>12345</Reference>
    <TransactionCode>
      <Module>AR</Module>
      <Code>PM</Code>
    </TransactionCode>
  </CustomerTransaction>
</CustomerTransactions>

Customer Transaction

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

The customer to import the transaction against can either be specified by Code, or can be looked up via ExternalId in the Truth Database if the customer 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
Customer	Customer/ExternalId	12345	String	Dependant
Customer	Customer/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
N/A	PostDated	2021-11-15	DateTime	Optional
Project	Project/Code	PROJ001	String	Optional
Reference	Reference	12345	String	Required
Reference 2	Reference2	12345	String	Optional
N/A	SalesRep/Code	JOHN	String	Optional
N/A	SettlementTerms/Code	30DAYSNET	String	Optional
N/A	Tax	0.00	Double	Optional
N/A	TaxRate/Code	EXEMPT	String	Optional
N/A	TillId	1	Int	Optional
Code	TransactionCode/Module*	AR	Enum	Required
Code	TransactionCode/Code	PM	String	Required
N/A	TransactionType	1	Int	Optional

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"?>
<CustomerTransactions>
  <CustomerTransaction>
    <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>
    <PostDated>2021-11-15</PostDated>
    <Project>
      <Code>PROJ001</Code>
    </Project>
    <Reference>12345</Reference>
    <Reference2>12345</Reference2>
    <SalesRep>
      <Code>JOHN</Code>
    </SalesRep>
    <SettlementTerms>
      <Code>30DAYSNET</Code>
    </SettlementTerms>
    <Tax>0.00</Tax>
    <TaxRate>
      <Code>EXEMPT</Code>
    </TaxRate>
    <TillId>1</TillId>
    <TransactionCode>
      <Module>AR</Module>
      <Code>PM</Code>
    </TransactionCode>
    <TransactionType>1</TransactionType>
  </CustomerTransaction>
</CustomerTransactions>

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"?>
<CustomerTransactions>
  <CustomerTransaction>
    <OrderNo>12345</OrderNo>
    <AllocateToReference>12345</AllocateToReference>
  </CustomerTransaction>
</CustomerTransactions>