Export invoice details in XML format

IMPORTANT - The import has to be in an XML format as below. Any other format will not work and the import will fail.  There is also an XSD schema file attached to this FAQ, see the bottom of the FAQ to download it.

Here's an example:

PLEASE NOTE - Normal XML rules apply (element and attribute names are case-sensitive, attribute ordering doesn't matter, whitespace is ignored and so on).File content<Invoices> element

• The posting file must consist of a single <Invoices> element, which can contain any number of <Invoice> elements.
• The Source attribute should give the name of the program which generated the posting file.  Ledger should always be Sales

<Invoice> elements

• Within an <Invoice> element, the Code attribute represents the customer code - this must match an Omega customer code.
• The No attribute must give a unique invoice ID - it must not match an existing Omega invoice.
• The Net, Vat and Total attributes give the overall values for the invoice.
• The DueDate and Discount attributes are optional but should ideally be included.  Discount is the "settlement" discount percentage for the invoice

<NominalAnalysis> element

• An invoice may contain a single <NominalAnalysis> element, containing one or more <Nominal> elements.

<Nominal> elements

• A <Nominal> element should be included for each Nominal code featured on the invoice (this is the Code attribute)

<Centre> elements

• Each <Nominal> element should contain one or more <Centre> elements.
• The <Net> attribute represents the total amount invoiced to the nominal code/cost centre pair.
• The <Description> attribute can be any string that identifies the invoice (as in the example)

<VATAnalysis> element

• An invoice must contain a single <VATAnalysis> element, containing one or more <VAT> elements

<VAT> elements

• A <VAT> element should be included for each VAT code featured on the invoice (this is the Code attribute).
• The Net attribute represents the total amount on the invoice subject to this VAT code.
• the VAT attribute represents the total VAT payable for this VAT code.

 

File Attachment:

File Name: PostingXSDfile.zip
File Size:1 KB