XML eGateway  XML eGateway Examples XML:

The following examples are included to show/test XML import.  See XML eGateway Test Program

Create/Update account using external ID

Create/Update account using account code

Test all field mappings

  • Example 20 Create account and then POR for all fields
  • Example 21 Create JOB for all fields
  • Example 22 Create Stock record for all fields

These files are simply for testing every mapped field for our internal testing, thus are not listed below.

Other types of transactions


Example 0 Import SOR (Sales Order)

 

   XML

 

<?xml version="1.0" ?>

        <ExchequerData>

        <TransactionHeader>
        <acOLECode>ZZZZ02</acOLECode>
        <!-- Create Exchequer SOR Transaction, in XML -->

        <thDocType>SOR</thDocType>
        <thAcCode>ABAP01</thAcCode>
        <thTransDate>16/05/2016</thTransDate>
        <thDueDate>16/05/2016</thDueDate>
        <thYourRef>TEST Data</thYourRef>

<!-- Set transaction defaults. The following are not turned ON in all installation of IRIS Exchequer -->
<!-- These can be expressed on each line, but setting them on the header dictates the values on the lines -->
<!-- Depending on how IRIS Exchequer is setup, these could be set as defaults agains the Account/Stock item,
in which case they do not need expressing -->

       <thLocation>AAA</thLocation>

       <TransactionLine>

               <!-- This line specifies Stock code and Price and VAT -->

               <tlStockCode>ALARMSYS-DOM-1</tlStockCode>

               <tlQty>1</tlQty>

                <tlDescr>Alaram system</tlDescr>

               <tlNetValue>57.45</tlNetValue>

               <tlVATCode>Standard</tlVATCode>

               <!-- Standard is converted to S by conversion list -->

        <tlGLCode>52010</tlGLCode>

        </TransactionLine>

        <TransactionLine>

                <!-- All price, VAT will be automatically calculated -->

                <tlStockCode>CAMERA-BRACKET</tlStockCode>

                <tlQty>5</tlQty> <!-- Price has not been expressed so will use IRIS price -->

        </TransactionLine>

        <TransactionLine>

                <!-- Comment line -->

                <tlStockCode></tlStockCode>

                <tlQty>1</tlQty>

                <tlDescr>A comment line</tlDescr>

                <!-- Price has not been expressed so will use IRIS price -->

        </TransactionLine>

</TransactionHeader>

</ExchequerData>

more about Account entity

more about Transaction entity


Example 1 Create/Update Account using external ID, and then import SOR (Sales Order)

Create or update account with "Alt Ref" = "TEST_Ref_ID", in company TEST01.  Then post an SOR (Sales Order). 

Note the use of acMatchByExternalRef and thMatchByExternalRef = true, which instructs XML eGateway to lookup the account code based on the Account record, Alt Ref field.

If the account is new, then the account code for the account will be created automatically based on the acCompany field and the format as defined in the system settings.  more info about account format

   XML

 

<?xml version="1.0" ?>

 

<ExchequerData>

<Account>
  <thOLECode>TEST01</thOLECode>

  <!-- Create/Update Exchequer Account record, from XML file -->
  <acMatchByExternalRef>Yes</acMatchByExternalRef>
  <!-- Use acAltCode to id account, allowing long account code from external system -->

  <acAltCode>TEST_Ref_ID</acAltCode>
  <acAccType>S</acAccType> <!-- Create as a Supplier -->
  <acCompany>Comtek Accounts</acCompany >
  <acAddress1>Venture House</acAddress1>
  <acAddress2>Venture Court</acAddress2>
  <acAddress3>Bolness Rd.</acAddress3>
  <acAddress4>Wisbech</acAddress4>
  <acAddress5>Cambs</acAddress5>
  <acPostCode>PE13 2QL</acPostCode>
  <acContact>Sam Smith</acContact>
  <acGeneralNotes>General Note can be imported against the Account
  </acGeneralNotes>

</Account>

 

<TransactionHeader>
  <!-- Create Exchequer SOR Transaction, in XML -->

  <thMatchByExternalRef>Yes</thMatchByExternalRef>
  <!-- Use acAltCode to id account, allowing long account code from external system -->

  <thDocType>SOR</thDocType>
  <thAcCode>TEST_Ref_ID</thAcCode>
  <thTransDate>2010-05-30</thTransDate>
  <thDueDate>2010-06-30</thDueDate>
  <thYourRef>EX1 _time_</thYourRef>

  <!-- Set transaction defaults. The following are not turned ON in all installations of Exchequer -->
  <!-- These can be expressed on each line, but setting them on the header dictates the values on the lines -->
  <!-- Depending on how Exchequer is setup, these could be set as defaults against the Account/Stock item, -->
  <!-- in which case they do not need expressing -->
  <thLocation>AAA</thLocation>
  <thCostCentre>AAA</thCostCentre>
  <thDepartment>AAA</thDepartment>

 

  <TransactionLine>
    <!-- This line specifies Stock code and Price and VAT -->
    <tlStockCode>ALARMSYS-DOM-1</tlStockCode>
    <tlQty>1</tlQty>
    <tlDescr>Alaram system</tlDescr>
    <tlNetValue>57.45</tlNetValue>
    <tlVATCode>Standard</tlVATCode> <!-- Standard is converted to S by conversion list -->
    <tlGLCode>52010</tlGLCode>
  </TransactionLine>

 

  <TransactionLine>
    <!-- All price, VAT will be automatically calculated -->
    <tlStockCode>CAMERA-BRACKET</tlStockCode>
    <tlQty>5</tlQty>
    <!-- Price has not been expressed so will use price -->
  </TransactionLine>

 

</TransactionHeader>

 

</ExchequerData>

more about Account entity

more about Transaction entity


Example 2 Create/Update Account using external ID, and then import SOR with long descriptions

Create or update account with "Alt Ref" = "TEST_Ref_ID", in company TEST01.  Then post an SOR with long descriptions which are word wrapped. 

In this example the <tlDescr> has a very long description in it.  This is word wrapped when importing into the transaction. "|" forces new lines.

Note the use of acMatchByExternalRef and thMatchByExternalRef = true, which instructs XML eGateway to lookup the account code based on the Account record, Alt Ref field.

If the account is new, then the account code for the account will be created automatically based on the acCompany field and the format as defined in the system settings.  more info about account format

   XML

 

<?xml version="1.0" ?>

 

<ExchequerData>

<Account>
  <thOLECode>TEST01</thOLECode>

  <!-- Create/Update Exchequer Account record, from XML file -->
  <acMatchByExternalRef>Yes</acMatchByExternalRef>
  <!-- Use acAltCode to id account, allowing long account code from external system -->

  <acAltCode>TEST_Ref_ID</acAltCode>
  <acAccType>S</acAccType> <!-- Create as a Supplier -->
  <acCompany>Comtek Accounts</acCompany >
  <acAddress1>Venture House</acAddress1>
  <acAddress2>Venture Court</acAddress2>
  <acAddress3>Bolness Rd.</acAddress3>
  <acAddress4>Wisbech</acAddress4>
  <acAddress5>Cambs</acAddress5>
  <acPostCode>PE13 2QL</acPostCode>
  <acContact>Sam Smith</acContact>
  <acGeneralNotes>General Note can be imported against the Account
  </acGeneralNotes>

</Account>

 

<TransactionHeader>
  <!-- Create Exchequer SOR Transaction, in XML -->

  <thMatchByExternalRef>Yes</thMatchByExternalRef>
  <!-- Use acAltCode to id account, allowing long account code from external system -->

  <thDocType>SOR</thDocType>
  <thAcCode>TEST_Ref_ID</thAcCode>
  <thTransDate>2010-05-30</thTransDate>
  <thDueDate>2010-06-30</thDueDate>
  <thYourRef>EX2 _time_</thYourRef>

  <TransactionLine>
    <!-- This line specifies Stock code and Price and VAT -->
    <tlStockCode>ALARMSYS-DOM-1</tlStockCode>
    <tlQty>1</tlQty>
    <tlDescr>This is an example of a very long description line. Exchequer has description lines of 55 chars, but     XML eGateway will word wrap the lines. Pipe|will cause a new line.|So you have:|Total control of new lines</tlDescr>
    <tlNetValue>57.45</tlNetValue>
    <tlVATCode>Standard</tlVATCode>
    <tlGLCode>52010</tlGLCode>

    <!-- Unlike Example 1, this example sets thLocation, thCostCentre and thDepartment on each line -->
    <!-- Depending on how Exchequer is setup, these could be set as defaults against the Account/Stock item, -->
    <!-- in which case they do not need expressing -->
    <tlLocation>AAA</tlLocation>
    <tlCostCentre>AAA</tlCostCentre>
    <tlDepartment>AAA</tlDepartment>
  </TransactionLine>

 

  <TransactionLine>
    <!-- All price, VAT will be automatically calculated -->
    <tlStockCode>CAMERA-BRACKET</tlStockCode>
    <tlQty>5</tlQty>

    <tlLocation>AAA</tlLocation>
    <tlCostCentre>AAA</tlCostCentre>
    <tlDepartment>AAA</tlDepartment>
  </TransactionLine>

 

</TransactionHeader>

 

</ExchequerData>

more about Account entity

more about Transaction entity


Example 3 Create/Update Account using external ID, and then import SOR with description pulled from Stock record in Exchequer

Create or update account with "Alt Ref" = "TEST_Ref_ID", in company TEST01.  Then post an SOR (Sales Order), using the stock description held in the stock record.

No <tlDescr> tag, makes XML eGateway, look up stock description.   If 6 lines of description are defined then they are carried over to the transaction.

Note the use of acMatchByExternalRef and thMatchByExternalRef = true, which instructs XML eGateway to lookup the account code based on the Account record, Alt Ref field.

If the account is new, then the account code for the account will be created automatically based on the acCompany field and the format as defined in the system settings.  more info about account format

   XML

 

<?xml version="1.0" ?>

 

<ExchequerData>

<Account>
  <thOLECode>TEST01</thOLECode>

  <!-- Create/Update Exchequer Account record, from XML file -->
  <acMatchByExternalRef>Yes</acMatchByExternalRef>
  <!-- Use acAltCode to id account, allowing long account code from external system -->

  <acAltCode>TEST_Ref_ID</acAltCode>
  <acAccType>S</acAccType> <!-- Create as a Supplier -->
  <acCompany>Comtek Accounts</acCompany >
  <acAddress1>Venture House</acAddress1>
  <acAddress2>Venture Court</acAddress2>
  <acAddress3>Bolness Rd.</acAddress3>
  <acAddress4>Wisbech</acAddress4>
  <acAddress5>Cambs</acAddress5>
  <acPostCode>PE13 2QL</acPostCode>
  <acContact>Sam Smith</acContact>
  <acGeneralNotes>General Note can be imported against the Account
  </acGeneralNotes>

</Account>

 

<TransactionHeader>
  <!-- Create Exchequer SOR Transaction, in XML -->

  <thMatchByExternalRef>Yes</thMatchByExternalRef>
  <!-- Use acAltCode to id account, allowing long account code from external system -->

  <thDocType>SOR</thDocType>
  <thAcCode>TEST_Ref_ID</thAcCode>
  <thTransDate>2010-05-30</thTransDate>
  <thDueDate>2010-06-30</thDueDate>
  <thYourRef>EX2 _time_</thYourRef>

  <TransactionLine>
    <!-- This line specifies Stock code and Price and VAT -->
    <tlStockCode>ALARMSYS-DOM-1</tlStockCode>
    <tlQty>1</tlQty>
    <tlNetValue>57.45</tlNetValue>
    <tlVATCode>Standard</tlVATCode>
    <tlGLCode>52010</tlGLCode>

    <!-- Unlike Example 1, this example sets thLocation, thCostCentre and thDepartment on each line -->
    <!-- Depending on how Exchequer is setup, these could be set as defaults against the Account/Stock item,
    in which case they do not need expressing -->
    <tlLocation>AAA</tlLocation>
    <tlCostCentre>AAA</tlCostCentre>
    <tlDepartment>AAA</tlDepartment>
  </TransactionLine>

 

  <TransactionLine>
    <!-- All price, VAT will be automatically calculated -->
    <tlStockCode>CAMERA-BRACKET</tlStockCode>
    <tlQty>5</tlQty>

    <tlLocation>AAA</tlLocation>
    <tlCostCentre>AAA</tlCostCentre>
    <tlDepartment>AAA</tlDepartment>
  </TransactionLine>

 

</TransactionHeader>

 

</ExchequerData>

more about Account entity

more about Transaction entity


Example 4 Create/Update Account using external ID, and then import SIN with manual VAT

Create or update account with "Alt Ref" = "TEST_Ref_ID", in company TEST01.  Then post an SIN (sales invoice) with manual VAT.

Manual VAT makes sure there are no rounding differences between the total in the external transaction and the transaction.  If Manual VAT is used then the VAT must be stated correctly in the XML as it will by pass any validation by Exchequer.

Note the use of acMatchByExternalRef and thMatchByExternalRef = true, which instructs XML eGateway to lookup the account code based on the Account record, Alt Ref field.

If the account is new, then the account code for the account will be created automatically based on the acCompany field and the format as defined in the system settings.  more info about account format

   XML

 

<?xml version="1.0" ?>

 

<ExchequerData>

<Account>
  <thOLECode>TEST01</thOLECode>

  <!-- Create/Update Exchequer Account record, from XML file -->
  <acMatchByExternalRef>Yes</acMatchByExternalRef>
  <!-- Use acAltCode to id account, allowing long account code from external system -->

  <acAltCode>TEST_Ref_ID</acAltCode>
  <acCompany>Comtek Accounts</acCompany >
  <acAddress1>Venture House</acAddress1>
  <acAddress2>Venture Court</acAddress2>
  <acAddress3>Bolness Rd.</acAddress3>
  <acAddress4>Wisbech</acAddress4>
  <acAddress5>Cambs</acAddress5>
  <acPostCode>PE13 2QL</acPostCode>
  <acContact>Sam Smith</acContact>
  <acGeneralNotes>General Note can be imported against the Account
  </acGeneralNotes>

</Account>

 

<TransactionHeader>
  <!-- Create Exchequer SIN Transaction, in XML -->

  <thMatchByExternalRef>Yes</thMatchByExternalRef>
  <!-- Use acAltCode to id account, allowing long account code from external system -->

  <thDocType>SIN</thDocType>
  <thAcCode>TEST_Ref_ID</thAcCode>
  <thTransDate>2010-05-30</thTransDate>
  <thDueDate>2010-06-30</thDueDate>
  <thYourRef>EX1 _time_</thYourRef>

  <!-- Set transaction defaults. The following are not turned ON in all installations of Exchequer -->
  <!-- These can be expressed on each line, but setting them on the header dictates the values on the lines -->
  <!-- Depending on how Exchequer is setup, these could be set as defaults against the Account/Stock item, -->
  <!-- in which case they do not need expressing -->
  <thLocation>AAA</thLocation>
  <thCostCentre>AAA</thCostCentre>
  <thDepartment>AAA</thDepartment>

  <!-- Transaction is going to be Manual VAT expressed on each line of transaction -->
  <thManualVAT>Yes</thManualVAT>

  <TransactionLine>
    <!-- This line specifies Stock code and Price and VAT -->
    <tlStockCode>ALARMSYS-DOM-1</tlStockCode>
    <tlQty>5</tlQty>
    <tlDescr>Alarm system</tlDescr>
    <tlNetValue>10.00</tlNetValue> <!-- Price each -->
    <tlVATCode>S</tlVATCode>
    <tlVATAmount>10.00</tlVATAmount > <!-- Total VAT for line (5*10 * 20% = 10) -->
    <tlGLCode>52010</tlGLCode>
  </TransactionLine>


  <TransactionLine>
    <!-- All price, VAT will be automatically calculated -->
    <tlStockCode>CAMERA-BRACKET</tlStockCode>
    <tlQty>2</tlQty>
    <tlDescr>Camera Braket</tlDescr>
    <tlNetValue>20.00</tlNetValue> <!-- Price each -->
    <tlVATCode>S</tlVATCode>
    <tlVATAmount>8.00</tlVATAmount > <!-- Total VAT for line (2*20 * 20% = 8) -->
    <tlGLCode>52020</tlGLCode>
    </TransactionLine>

 

</TransactionHeader>

 

</ExchequerData>

more about Account entity

more about Transaction entity


Example 5 Create/Update Account using external ID, and then import SRI with manual VAT

Create or update account with "Alt Ref" = "TEST_Ref_ID", in company TEST01.  Then post an SRI (sales invoice with payment)with manual VAT.

Manual VAT makes sure there are no rounding differences between the total in the external transaction and the transaction.  If Manual VAT is used then the VAT must be stated correctly in the XML as it will by pass any validation by Exchequer.

Note the use of acMatchByExternalRef and thMatchByExternalRef = true, which instructs XML eGateway to lookup the account code based on the Account record, Alt Ref field.

If the account is new, then the account code for the account will be created automatically based on the acCompany field and the format as defined in the system settings.  more info about account format

   XML

 

<?xml version="1.0" ?>

 

<ExchequerData>

<Account>
  <thOLECode>TEST01</thOLECode>

  <!-- Create/Update Exchequer Account record, from XML file -->
  <acMatchByExternalRef>Yes</acMatchByExternalRef>
  <!-- Use acAltCode to id account, allowing long account code from external system -->

  <acAltCode>TEST_Ref_ID</acAltCode>
  <acCompany>Comtek Accounts</acCompany >
  <acAddress1>Venture House</acAddress1>
  <acAddress2>Venture Court</acAddress2>
  <acAddress3>Bolness Rd.</acAddress3>
  <acAddress4>Wisbech</acAddress4>
  <acAddress5>Cambs</acAddress5>
  <acPostCode>PE13 2QL</acPostCode>
  <acContact>Sam Smith</acContact>
  <acGeneralNotes>General Note can be imported against the Account
  </acGeneralNotes>

</Account>

 

<TransactionHeader>
  <!-- Create Exchequer SRI Transaction, in XML -->

  <thMatchByExternalRef>Yes</thMatchByExternalRef>
  <!-- Use acAltCode to id account, allowing long account code from external system -->

  <thDocType>SRI</thDocType>
  <thAcCode>TEST_Ref_ID</thAcCode>
  <thTransDate>2010-05-30</thTransDate>
  <thDueDate>2010-06-30</thDueDate>
  <thYourRef>EX2 _time_</thYourRef>

  <!-- Transaction is going to be Manual VAT expressed on each line of transaction -->
  <thManualVAT>Yes</thManualVAT>

  <!-- Set transaction defaults. The following are not turned ON in all installations of Exchequer -->
  <!-- These can be expressed on each line, but setting them on the header dictates the values on the lines -->
  <!-- Depending on how Exchequer is setup, these could be set as defaults against the Account/Stock item, -->
  <!-- in which case they do not need expressing -->
  <thCostCentre>AAA</thCostCentre>
  <thDepartment>AAA</thDepartment>

  <TransactionLine>
    <!-- Sale Line -->
    <tlQty>1</tlQty>
    <tlDescr>Goods bought</tlDescr>
    <tlNetValue>10.00</tlNetValue> <!-- Price each -->
    <tlVATCode>S</tlVATCode>
    <tlVATAmount>2.00</tlVATAmount> <!-- Total VAT for line (1 * 10 * 20% = 2) -->
    <tlGLCode>52010</tlGLCode> <!-- Sales GL -->
  </TransactionLine>

 

  <TransactionLine>
    <!-- Payment Line -->
    <tlPayInRef>Payment Ref</tlPayInRef>
    <tlChequeNo>23623623</tlChequeNo>
    <tlNetValue>12.00</tlNetValue>
    <tlGLCode>2010</tlGLCode> <!-- Bank Account GL -->
  </TransactionLine>

 

</TransactionHeader>

 

</ExchequerData>

more about Account entity

more about Transaction entity


Example 6 Create/Update Account using external ID, and then import PPI with manual VAT

Create or update account with "Alt Ref" = "TEST_Ref_ID", in company TEST01.  Then post a PPI (purchase invoice with payment). 

Note the use of acMatchByExternalRef and thMatchByExternalRef = true, which instructs XML eGateway to lookup the account code based on the Account record, Alt Ref field.

If the account is new, then the account code for the account will be created automatically based on the acCompany field and the format as defined in the system settings.  more info about account format

   XML

 

<?xml version="1.0" ?>

 

<ExchequerData>

<Account>
  <thOLECode>TEST01</thOLECode>

  <!-- Create/Update Exchequer Account record, from XML file -->
  <acMatchByExternalRef>Yes</acMatchByExternalRef>
  <!-- Use acAltCode to id account, allowing long account code from external system -->

  <acAltCode>TEST_Ref_ID</acAltCode>
  <acAccType>S</acAccType> <!-- Create as a Supplier -->
  <acCompany>Comtek Accounts</acCompany >
  <acAddress1>Venture House</acAddress1>
  <acAddress2>Venture Court</acAddress2>
  <acAddress3>Bolness Rd.</acAddress3>
  <acAddress4>Wisbech</acAddress4>
  <acAddress5>Cambs</acAddress5>
  <acPostCode>PE13 2QL</acPostCode>
  <acContact>Sam Smith</acContact>
  <acGeneralNotes>General Note can be imported against the Account
  </acGeneralNotes>

</Account>

 

<TransactionHeader>
  <!-- Create Exchequer PPI Transaction, in XML -->

  <thMatchByExternalRef>Yes</thMatchByExternalRef>
  <!-- Use acAltCode to id account, allowing long account code from external system -->

  <thDocType>PPI</thDocType>
  <thAcCode>TEST_Ref_ID</thAcCode>
  <thTransDate>2010-05-30</thTransDate>
  <thDueDate>2010-06-30</thDueDate>
  <thYourRef>EX6 _time_</thYourRef>

  <!-- Transaction is going to be Manual VAT expressed on each line of transaction -->
  <thManualVAT>Yes</thManualVAT>

  <!-- Set transaction defaults. The following are not turned ON in all installation of Exchequer -->
  <!-- These can be expressed on each line, but setting them on the header dictates the values on the lines -->
  <!-- Depending on how Exchequer is setup, these could be set as defaults against the Account/Stock item, -->
  <!-- in which case they do not need expressing -->
  <thCostCentre>AAA</thCostCentre>
  <thDepartment>AAA</thDepartment>

  <TransactionLine>
    <!-- Sale Line -->
    <tlQty>1</tlQty>
    <tlDescr>Goods bought</tlDescr>
    <tlNetValue>10.00</tlNetValue> <!-- Price each -->
    <tlVATCode>S</tlVATCode>
    <tlVATAmount>2.00</tlVATAmount> <!-- Total VAT for line (1 * 10 * 20% = 2) -->
    <tlGLCode>52010</tlGLCode> <!-- Sales GL -->
  </TransactionLine>

 

  <TransactionLine>
    <!-- Payment Line -->
    <tlPayInRef>Payment Ref</tlPayInRef>
    <tlChequeNo>23623623</tlChequeNo>
    <tlNetValue>12.00</tlNetValue>
    <tlGLCode>2010</tlGLCode> <!-- Bank Account GL -->
  </TransactionLine>

 

</TransactionHeader>

 

</ExchequerData>

more about Account entity

more about Transaction entity


Example 7 Create/Update Account using external ID, and then import POR (purchase order)

Create or update account with "Alt Ref" = "TEST_Ref_ID", in company TEST01.  Then post a POR. 

Note the use of acMatchByExternalRef and thMatchByExternalRef = true, which instructs XML eGateway to lookup the account code based on the Account record, Alt Ref field.

If the account is new, then the account code for the account will be created automatically based on the acCompany field and the format as defined in the system settings.  more info about account format

   XML

 

<?xml version="1.0" ?>

 

<ExchequerData>

<Account>
  <thOLECode>TEST01</thOLECode>

  <!-- Create/Update Exchequer Account record, from XML file -->
  <acMatchByExternalRef>Yes</acMatchByExternalRef>
  <!-- Use acAltCode to id account, allowing long account code from external system -->

  <acAltCode>TEST_Ref_ID</acAltCode>
  <acAccType>S</acAccType> <!-- Create as a Supplier -->
  <acCompany>Comtek Accounts</acCompany >
  <acAddress1>Venture House</acAddress1>
  <acAddress2>Venture Court</acAddress2>
  <acAddress3>Bolness Rd.</acAddress3>
  <acAddress4>Wisbech</acAddress4>
  <acAddress5>Cambs</acAddress5>
  <acPostCode>PE13 2QL</acPostCode>
  <acContact>Sam Smith</acContact>
  <acGeneralNotes>General Note can be imported against the Account
  </acGeneralNotes>

</Account>

 

<TransactionHeader>
  <!-- Create Exchequer POR Transaction, in XML -->

  <thMatchByExternalRef>Yes</thMatchByExternalRef>
  <!-- Use acAltCode to id account, allowing long account code from external system -->

  <thDocType>POR</thDocType>
  <thAcCode>TEST_Ref_ID</thAcCode>
  <thTransDate>2010-05-30</thTransDate>
  <thDueDate>2010-06-30</thDueDate>
  <thYourRef>EX6 _time_</thYourRef>

  <!-- Transaction is going to be Manual VAT expressed on each line of transaction -->
  <thManualVAT>No</thManualVAT>

  <!-- Set transaction defaults. The following are not turned ON in all installation of Exchequer -->
  <!-- These can be expressed on each line, but setting them on the header dictates the values on the lines -->
  <!-- Depending on how Exchequer is setup, these could be set as defaults against the Account/Stock item, -->
  <!--   in which case they do not need expressing -->
  <thCostCentre>AAA</thCostCentre>
  <thDepartment>AAA</thDepartment>

  <TransactionLine>
    <!-- Sale Line -->
    <tlQty>1</tlQty>
    <tlDescr>Goods bought</tlDescr>
    <tlNetValue>10.00</tlNetValue> <!-- Price each -->
    <tlVATCode>S</tlVATCode>
    <tlVATAmount>2.00</tlVATAmount> <!-- Total VAT for line (1 * 10 * 20% = 2) -->
    <tlGLCode>52010</tlGLCode> <!-- Sales GL -->
  </TransactionLine>

 

</TransactionHeader>

 

</ExchequerData>

more about Account entity

more about Transaction entity


Example 10 Create/Update Account using external ID, and then import SOR (Sales Order)

Create or update account TEST001, in company TEST01.  Then post a SOR

   XML

 

<?xml version="1.0" ?>

 

<ExchequerData>

<Account>
  <thOLECode>TEST01</thOLECode>

  <acCode>TEST001</acCode>
  <acCompany>Comtek Accounts</acCompany >
  <acAddress1>Venture House</acAddress1>
  <acAddress2>Venture Court</acAddress2>
  <acAddress3>Bolness Rd.</acAddress3>
  <acAddress4>Wisbech</acAddress4>
  <acAddress5>Cambs</acAddress5>
  <acPostCode>PE13 2QL</acPostCode>
  <acContact>Sam Smith</acContact>
  <acGeneralNotes>General Note can be imported against the Account
  </acGeneralNotes>

</Account>

 

<TransactionHeader>
  <!-- Create Exchequer SOR Transaction, in XML -->

  <thDocType>SOR</thDocType>
  <thAcCode>TEST001</thAcCode>
  <thTransDate>2010-05-30</thTransDate>
  <thDueDate>2010-06-30</thDueDate>
  <thYourRef>EX11 _time_</thYourRef>

  <!-- Set transaction defaults. The following are not turned ON in all installation of Exchequer -->
  <!-- These can be expressed on each line, but setting them on the header dictates the values on the lines -->
  <!-- Depending on how Exchequer is setup, these could be set as defaults against the Account/Stock item, -->
  <!-- in which case they do not need expressing -->
  <thLocation>AAA</thLocation>
  <thCostCentre>AAA</thCostCentre>
  <thDepartment>AAA</thDepartment>

 

  <TransactionLine>
    <!-- This line specifies Stock code and Price and VAT -->
    <tlStockCode>ALARMSYS-DOM-1</tlStockCode>
    <tlQty>1</tlQty>
    <tlDescr>Alaram system</tlDescr>
    <tlNetValue>57.45</tlNetValue>
    <tlVATCode>Standard</tlVATCode> <!-- Standard is converted to S by conversion list -->
    <tlGLCode>52010</tlGLCode>
 </TransactionLine>

 

  <TransactionLine>
    <!-- All price, VAT will be automatically calculated -->
    <tlStockCode>CAMERA-BRACKET</tlStockCode>
    <tlQty>5</tlQty>
    <!-- Price has not been expressed so will use price -->
  </TransactionLine>

 

</TransactionHeader>

 

</ExchequerData>

more about Account entity

more about Transaction entity


Example 40 TSH (timesheet)

Post a Timesheet into company TEST01

   XML

 

<?xml version="1.0" ?>

 

<ExchequerData>

<TransactionHeader>
  <thOLECode>TEST01</thOLECode>

  <!-- Create Exchequer TSH Transaction, in XML -->
  <thDocType>TSH</thDocType>
  <thTSHEmployee>DEAN01</thTSHEmployee> <!-- Employee within Exchequer Job Costing -->
  <thTransDate>2010-05-30</thTransDate>
  <thTSHDescription>EX40 _time_</thTSHDescription>

 

  <TransactionLine>
    <tlDescr>Screwing Light Bulbs</tlDescr>
    <tlTSHRateCode>ELEC-STD</tlTSHRateCode> <!-- Rate code within Exchequer Job Costing, this sets many line defaults -->
    <tlTSHHours>5</tlTSHHours>
    <tlTSHChargeOutRate>20</tlTSHChargeOutRate>
    <tlTSHCostPerHour>7.5</tlTSHCostPerHour>
    <tlJobCode>BATH01</tlJobCode> <!-- Job within Exchequer Job Costing -->
  </TransactionLine>

 

  <TransactionLine>
    <tlDescr>Plugging in sockets</tlDescr>
    <tlTSHRateCode>ELEC-STD</tlTSHRateCode>
    <tlTSHHours>7</tlTSHHours>
    <!-- Use default tlTSHChargeOutRate/tlTSHCostPerHour setup in exchequer -->
    <tlJobCode>BICL01</tlJobCode>
  </TransactionLine>


</TransactionHeader>

 

</ExchequerData>

more about Transaction entity


Example 50 NOM (nominal journal)

Post a nominal journal into company TEST01

   XML

 

<?xml version="1.0" ?>

 

<ExchequerData>

<TransactionHeader>
  <thOLECode>TEST01</thOLECode>

  <!-- Create Exchequer NOM Transaction, in XML -->
  <thDocType>NOM</thDocType>
  <thTransDate>2010-05-30</thTransDate>
  <thNOMDescription>EX50 _time_</thNOMDescription>

  <thNOMAutoReversing>Yes</thNOMAutoReversing>

  <TransactionLine>
    <tlDescr>Credit line 1</tlDescr>
    <tlNOMCredit>20.00</tlNOMCredit> <!-- Credit -->
    <tlGLCode>52010</tlGLCode>
    <tlCostCentre>AAA</tlCostCentre>
    <tlDepartment>AAA</tlDepartment>
  </TransactionLine>

  <TransactionLine>
    <tlDescr>Credit line 2</tlDescr>
    <tlNOMCredit>20.00</tlNOMCredit> <!-- Credit -->
    <tlGLCode>52010</tlGLCode>
    <tlCostCentre>AAA</tlCostCentre>
    <tlDepartment>AAA</tlDepartment>
  </TransactionLine>

 

  <TransactionLine>
    <tlDescr>Debit line</tlDescr>
    <tlNOMDebit>40.00</tlNOMDebit> <!-- Debt -->
    <tlGLCode>62020</tlGLCode>
    <tlCostCentre>AAA</tlCostCentre>
    <tlDepartment>AAA</tlDepartment>
  </TransactionLine>

 

</TransactionHeader>

 

</ExchequerData>

more about Transaction entity


Example 60 ADJ (stock adjustment)

Post a simple stock adjustment, into company TEST01

   XML

 

<?xml version="1.0" ?>

 

<ExchequerData>

<TransactionHeader>
  <thOLECode>TEST01</thOLECode>

  <!-- Create Exchequer ADJ Transaction, in XML -->
  <thDocType>ADJ</thDocType>
  <thAcCode>TEST__x_</thAcCode>
  <thTransDate>2010-05-30</thTransDate>
  <thADJDescription>EX60 _time_</thADJDescription>

 

  <TransactionLine>
    <tlStockCode>ALARMSYS-DOM-1</tlStockCode>
    <tlDescr>Alarm out of main location</tlDescr>
    <tlADJQtyOUT>1</tlADJQtyOUT>
    <tlLocation>AAA</tlLocation>
    <tlCostCentre>AAA</tlCostCentre>
    <tlDepartment>AAA</tlDepartment>
  </TransactionLine>

 

  <TransactionLine>
    <tlStockCode>ALARMSYS-DOM-1</tlStockCode>
    <tlDescr>Alarm in of main location</tlDescr>
    <tlADJQtyIN>1</tlADJQtyIN>
    <tlLocation>VAN</tlLocation>
    <tlCostCentre>AAA</tlCostCentre>
    <tlDepartment>AAA</tlDepartment>
  </TransactionLine>

 

</TransactionHeader>

 

</ExchequerData>


more about Transaction entity


Example 61 ADJ (stock adjustment) and build BOM

This example ticks the "Build" tick box on the ADJ line, to instruct Exchequer to build the BOM item.

   XML


<?xml version="1.0" ?>

 

<ExchequerData>

<TransactionHeader>
  <thOLECode>TEST01</thOLECode>

  <!-- Create Exchequer ADJ Transaction, in XML -->
  <thDocType>ADJ</thDocType>
  <thTransDate>2010-05-30</thTransDate>
  <thADJDescription>EX60 _time_</thADJDescription>

 

  <TransactionLine>
    <tlStockCode>ALARMSYS-DOM-1</tlStockCode>
    <tlDescr>Alarm out of main location</tlDescr>
    <tlADJBuild>yes</tlADJBuild>
    <tlADJQtyIN>1</tlADJQtyIN>
    <tlLocation>AAA</tlLocation>
    <tlCostCentre>AAA</tlCostCentre>
    <tlDepartment>AAA</tlDepartment>
  </TransactionLine>

 

</TransactionHeader>

 

</ExchequerData>  

more about Transaction entity