Create Reference Data Sample

Creditor Account

API Request

XML

PUT https://www.aqilla.net/InstanceName/wsapi/2.5/Reference/Creditor Accounts/Creditor Account Edit
Content-Type: application/xml

Body

XML

<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<dataentry>
  <entity>
    <attribute name="Account Code">C07694</attribute>
    <attribute name="Account Name">Blogs and Co</attribute>
    <attribute name="Account Category">Creditors</attribute>
    <attribute name="VAT Area">UK</attribute>
    <attribute name="Not Reported VAT Code">--Not Set--</attribute>
    <attribute name="Currency Rate Group">Default</attribute>
    <attribute name="Payment Method">Default</attribute>
    <attribute name="VAT Registration"></attribute>
    <attribute name="Account Currency">None</attribute>
    <attribute name="Commitment Account"></attribute>
    <attribute name="Payment Account"></attribute>
    <attribute name="Account Address"></attribute>
    <attribute name="Credit Limit"></attribute>
    <attribute name="Terms">None</attribute>
    <attribute name="Remittance Recipient Email"></attribute>
    <attribute name="Bank Account Name"></attribute>
    <attribute name="Bank Branch"></attribute>
    <attribute name="Bank Account Number"></attribute>
    <attribute name="Bank Sort Code"></attribute>
    <attribute name="Bank Reference"></attribute>
    <attribute name="Balance Forward">No</attribute>
    <attribute name="Disabled">No</attribute>
    <attribute name="Currency Variable">No</attribute>
    <attribute name="Suppress Revaluation">No</attribute>
    <attribute name="Client Account">No</attribute>
    <attribute name="Comments"></attribute>
  </entity>
</dataentry>

Response

Response

XML

200 OK

<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<dataentry>
  <entity sguid="8aBYZqDV5lSk29LwEJrcbAR25M">
    <attachments/>
  </entity>
  <subordinates/>
</dataentry>

Customer

API Request

XML

PUT https://www.aqilla.net/InstanceName/wsapi/2.5/Reference/Customers/Customer Edit
Content-Type: application/xml

Body

XML

<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<dataentry>
  <entity>
    <attribute name="Customer Code">LUK001</attribute>
    <attribute name="Customer Name">Lukoil UK Ltd</attribute>
    <attribute name="Address Line 1">The House</attribute>
    <attribute name="Address Line 2">The Street</attribute>
    <attribute name="Address Line 3">The Town</attribute>
    <attribute name="Address Line 4">The County</attribute>
    <attribute name="Post Code">RH5 6HD</attribute>
    <attribute name="Country">UK</attribute>
    <attribute name="Web">lukoil.com</attribute>
    <attribute name="Invoice Recipient Email">ivan.bloggs@lukoil.com</attribute>
    <attribute name="Notes">Just free text</attribute>
    <attribute name="Account Code"></attribute>
  </entity>
</dataentry>

Response

XML

200 OK

<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<dataentry>
    <entity sguid="9VDNyObQ8vsZewLGVYu6qp4n7Q">
        <attachments/>
    </entity>
    <subordinates/>
</dataentry>

Debtor Account

API Request

XML

PUT https://www.aqilla.net/InstanceName/wsapi/2.2/Reference/Debtor Accounts/Debtor Account Edit
Content-Type: application/xml

Body

XML

<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<dataentry>
  <entity>
    <attribute name="Account Code">D67884</attribute>
    <attribute name="Account Name">John Smith and Sons</attribute>
    <attribute name="Account Category">Debtors</attribute>
    <attribute name="VAT Area">UK</attribute>
    <attribute name="Not Reported VAT Code">--Not Set--</attribute>
    <attribute name="Currency Rate Group">Default</attribute>
    <attribute name="Payment Method">Default</attribute>
    <attribute name="VAT Registration"></attribute>
    <attribute name="Account Currency">None</attribute>
    <attribute name="Commitment Account"></attribute>
    <attribute name="Payment Account"></attribute>
    <attribute name="Account Address"></attribute>
    <attribute name="Credit Limit"></attribute>
    <attribute name="Terms">None</attribute>
    <attribute name="Statement Recipient Email"></attribute>
    <attribute name="Bank Account Name"></attribute>
    <attribute name="Bank Branch"></attribute>
    <attribute name="Bank Account Number"></attribute>
    <attribute name="Bank Sort Code"></attribute>
    <attribute name="Bank Reference"></attribute>
    <attribute name="Balance Forward">No</attribute>
    <attribute name="Disabled">No</attribute>
    <attribute name="Currency Variable">No</attribute>
    <attribute name="Suppress Revaluation">No</attribute>
    <attribute name="Comments"></attribute>
  </entity>
</dataentry>

Response

XML

200 OK

<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<dataentry>
  <entity sguid="bXJREqrEz2u29LnRLDeu2KzgL6">
    <attachments/>
  </entity>
  <subordinates/>
</dataentry>

General Ledger Account

API Request

XML

PUT https://www.aqilla.net/InstanceName/wsapi/2.5/Reference/General Ledger Accounts/General Ledger Account Edit
Content-Type: application/xml

Note treatment of Account Type

Body

XML

<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<dataentry>
  <entity>
    <attribute name="Account Code">P3411</attribute>
    <attribute name="Account Name">Private Jet Rental</attribute>
    <attribute name="Account Type"><![CDATA[Profit & Loss]]></attribute>
    <attribute name="Account Category">Expenses</attribute>
    <attribute name="Currency Rate Group">Default</attribute>
    <attribute name="Account Currency">None</attribute>
    <attribute name="Commitment Account"></attribute>
    <attribute name="Balance Forward">No</attribute>
    <attribute name="Disabled">No</attribute>
    <attribute name="Currency Variable">No</attribute>
    <attribute name="Suppress Revaluation">No</attribute>
    <attribute name="Comments"></attribute>
  </entity>
</dataentry>

Response

XML

200 OK

<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<dataentry>
  <entity sguid="myW2YO32XZToRjBj3JvCyqJ1E9">
    <attachments/>
  </entity>
  <subordinates/>
</dataentry>

Item

API Request

XML

PUT https://www.aqilla.net/InstanceName/wsapi/2.5/Reference/Items/Item Edit
Content-Type: application/xml

Body

XML

<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<dataentry>
  <entity>
    <attribute name="Item Code">001-999-2570</attribute>
    <attribute name="Item Description">612TXi PIII 900 CD WME</attribute>
    <attribute name="Item VAT Rate">Standard</attribute>
    <attribute name="Sales">Yes</attribute>
    <attribute name="Account Code">P1100(Direct Sales)</attribute>
    <attribute name="Unit of Sale">Each</attribute>
    <attribute name="Sales Price">1,099.00</attribute>
    <attribute name="Purchasing">Yes</attribute>
    <attribute name="Purchase Account">B5110(Computer Equipment: Cost)</attribute>
    <attribute name="Unit of Purchase">Each</attribute>
    <attribute name="Purchase Price">650.22</attribute>
    <attribute name="Inventory">Yes</attribute>
    <attribute name="Inventory Account Code">B5500(Stock)</attribute>
    <attribute name="Item Unit">Each</attribute>
    <attribute name="Standard Cost">650.22</attribute>
    <attribute name="Costing Method">Standard</attribute>
    <attribute name="Matching Method">FIFO</attribute>
    <attribute name="Item Revision">12b</attribute>
    <attribute name="Item Id">001-023-3080(Aspire 1403XC P4 2.0 )</attribute>
    <attribute name="Re-order Level">100.00</attribute>
    <attribute name="Re-order Quantity">50.00</attribute>
    <attribute name="Supplier Name">APM001(APM Momemtum)</attribute>
    <attribute name="Address Id">Main</attribute>
    <attribute name="Batch Tracking">No</attribute>
    <attribute name="Serial Number Tracking">No</attribute>
    <attribute name="ExpiryDate">No</attribute>
    <attribute name="Product Group">PCs: Notebooks</attribute>
  </entity>
</dataentry>

Response

XML

200 OK

<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<dataentry>
  <entity sguid="Zo9jLq1BEQTRwZxN5PETJOWBRQ">
    <attachments/>
  </entity>
  <subordinates/>
</dataentry>

Supplier

API Request

XML

PUT https://www.aqilla.net/InstanceName/wsapi/2.5/Reference/Suppliers/Supplier Edit
Content-Type: application/xml

Body

XML

<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<dataentry>
  <interface name="Supplier Edit"></interface>
  <entity>
    <attribute name="Supplier Code">SOL001</attribute>
    <attribute name="Supplier Name">Solid Models Ltd</attribute>
    <attribute name="Address Line 1">The House</attribute>
    <attribute name="Address Line 2">The Street</attribute>
    <attribute name="Address Line 3">The Town</attribute>
    <attribute name="Address Line 4">The County</attribute>
    <attribute name="Post Code">RH5 6HD</attribute>
    <attribute name="Country">UK</attribute>
    <attribute name="Web">anyolddomain.com</attribute>
    <attribute name="Purchase Recipient Email">invoices@anyolddomain.com</attribute>
    <attribute name="Notes">Just free text</attribute>
    <attribute name="Account Code"></attribute>
  </entity>
</dataentry>

Response

XML

200 OK

<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<dataentry>
  <entity sguid="gyVlvqLPLltg87d5QNSQq5jaNW">
    <attachments/>
  </entity>
  <subordinates/>
</dataentry>

Project

API Request

XML

PUT https://www.aqilla.net/InstanceName/wsapi/2.5/Reference/Projects/Project Edit
Content-Type: application/xml

Body

XML

<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<dataentry>
  <entity>
    <attribute name="Project Code">P026</attribute>
    <attribute name="Project Name">Mersey</attribute>
    <attribute name="Long Description">This is all about the project</attribute>
    <attribute name="Customer Code">BIO/001</attribute>
    <attribute name="Effective From">01 Sep 2016</attribute>
    <attribute name="Effective To">31 Dec 2016</attribute>
    <attribute name="Project Disabled">No</attribute>
  </entity>
</dataentry>

Response

XML

200 OK

<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<dataentry>
  <entity sguid="G5jovqX0XltekpeB3ECaqmP6VE">
    <attachments/>
  </entity>
  <subordinates/>
</dataentry>