Kapcsolódó információk:
Paraméterezési útmutatók

The Finance/Invoicing modul of the SUP Integrated Accounting Software provides us with the opportunity to issue invoices based on a complete invoice order prepared by an other system. In this case the sender system should send the invoice order with using an XML data format. The invoice order package has to contain all necessary information. The invoice number will be generated by the SUP software during the invoice import process.

As the XML format can be prepared by programming, there is an option to prepare the invoices from an XLS sheet as well. However this provides rather simplier, more limited options vs. the XML import.

Skeleton of XML format

The invoice order uses the below XML format for instructing the invoicing process.

XML scheme
<?xml version="1.0" encoding="UTF-8"?>
<Elojegyzett_Szamlak FileVersion="EJSZ_1.1" FileTimeStamp="2014.01.01." FileDestination="SUPKISZLA">
  <CsomagInfo>...</CsomagInfo>
  <Szamlak>...
    <Szamla>...
      <Fejlec>...
        <TrackingKod>...</TrackingKod>
        <Vevo>...</Vevo>
        <EgyebInfo>...</EgyebInfo>
        <Gyujtok>...</Gyujtok>
      </Fejlec>
      <Tetelsorok>...
        <Tetelsor>...
          <Cikk>...</Cikk>
          <Menny>...</Menny>
        </Tetelsor>
      </Tetelsorok>
      <KontrollFizBruttoOssz>...</KontrollFizBruttoOssz>
    </Szamla>
  </Szamlak>
</Elojegyzett_Szamlak>
 Figyelem

At the preparation of the XML file please pay attention to the characters not supported by the XML format. e.g. '&' character has to be replaced by '#38';

At the preparation of the XML file please pay attention to the characters not supported by the XML format. e.g. '&' character has to be replaced by '#38';

 

 

In the next pages the detailed description of the XML sections will be introduced:

Content description

XML sectionMandatoryDescription
CsomagInfoYesDescription of the package.
SzamlakYesDescription of the invoices.
SzamlaYesDescription of the invoice.
FejlecYesHeader data of the invoice.
TrackingKodYesIdentification, serves follow-up purposes. Will be entered in the comments section of the invoice.
VevoYesCustomer data.
EgyebInfoYesOther information belongs to the invoice.
KontrollFizBruttoOsszYesControl amount. Total of the gross amounts of the invoiced items.
TetelsorokYesItem details.
TetelsorYesItem details.
CikkYesItem definition.
MennyYesItem quantity details.

<CsomagInfo> data group

The <CsomagInfo> XML section describes all the information relevant for the entire invoice order package.

Example

Content description

XML sectionMandatoryTypeLengthDescription
DevnemNoC33 digits long -code of the invoice package currency, ISO code. Separate packages have to be prepared per currency. In case of HUF the field must be blank.
FKNaploYesC3Invoicing journal number identified in the SUP® system

<Szamlak> data group

A <Szamlak> XML section describes the content of the invoices to be issued. An invoice order consists of attributes, header and items.

Example

<Szamlak> invoice attributes

The SUP system sends information to the sender party through the invoice attributes about the succesful completion of the invoicing, while the sender also receives the number of the invoice issued, which can be matched to the tracking code in the sender system.

AttributeTypeDescription
AtvetelStatusBooleanIn case of successful completion of the invoicing: True
AtvetelTimeStampTimeStampIn case of successful completion of the invoicing: Issue date
AtvetelSzlaszCharIn case of successful completion of the invoicing: Invoice number.

<Fejléc> "Header" data group

The invoice header data fields should go to the <Fejlec> data group.

Example

Content description

XML sectionMandatoryTypeLeghtDescription
TrackingKodYesC40

ID code generated by the sender system, which serves for follow-up of the invoices created. It is stored together with the prepared invoice in SUP system. It appears on the printout as well, in the comments sections of the invoice.

e.g.: in case of importing from an ordering system the PO number should be stored here; in case of a service register software the service ticket number should be stored here.

 Megjegyzés

After the import has been completed the <Szamla AtvetelStatus=,  AtvetelSzlasz=,  AtvetelTimeStamp= > attributes of the XML file will be updated, in this way the sender will receive confirmation about the succesful completion of the process.

 

 

After the import has been completed the <Szamla AtvetelStatus=,  AtvetelSzlasz=,  AtvetelTimeStamp= > attributes of the XML file will be updated, in this way the sender will receive confirmation about the succesful completion of the process.

 


Content description - <Vevo>...</Vevo>

XML sectionMandatoryTypeLeghtDescription
VevoKodYesC 11Customer code, in sync with the customer master datas of the SUP system. In case of a new customer the „ system parameters ” setup offers two options: 1) error message 2) automatically pick up and copy the new customer to the SUP customer master database.
VevoMegnevYesC80

Name of the customer.

VevoIrszYesC5Zip code.
VevoVarosYesC30City.
VevoUtcaYesC40Street.
VevoEmailNoC40Email address.
VevoAdoszamNoC15Domestic tax ID, without hyphens.
VevoEuAdoszNoC2

EU tax ID first two digits (country code). ISO 3166-1 standard  must be applied for country codes. Applicable only at EU customers.


Content description - <EgyebInfo>...</EgyebInfo>

XML sectionMandatoryTypeLenghtDescription
NyelvKodNoC2

Invoice printout language, ISO 639 coding applicable. Currently set languages:  'en', 'de', 'sk', 'it'.
In case of Hungarian leave blank, default setting: 'hu'.

DevArfolyamNoNUM 18 +6Foreign currency exchange rate, mandatory only in case of invoices in foreign currency. (Maximum 18 characters + 6 decimals.)
FizmodYesNUM1

Payment method, as per internal coding of the SUP system. e.g:

  0 – Cash
  4 – Wire transfer

TeljYesDATEéé.hh.nnDate of supply.
KeltYesDATEéé.hh.nnInvoice date.
HatinapYesNUM3Payment terms, „x” days.
MegjegyzesNoC1500Comments section of the invoice. It appears between the header and the items sections on the printout of the invoice.
EngSzazYesNUM4 +1

Allowance given to the customer. The value in case of no allowance: 0 (zero).
(Maximum 4 characters +1 decimal.). Usage is not recommended, the allowance settings are preferred at item level.


<Tetelsorok> "items" data group

Example


Content description - <Cikk>...</Cikk> „Material” data group

XML sectionMandatoryTypeLenghtDescription
CikkSzamYesC13
Material number, as per material master of the SUP system.
CikkMegnevMagyarYesC50Name of the material.
MennyEgysYesC5Unit of measure. for example.: pc. If blank, the import will use the UoM set in the material master of the SUP system.
AFAszaznYesNUM2VAT rate (calculated from the net amount).
SzjVtszKodYesC15Material code as per hungarian statistical classification.


Content description - <Menny>...</Menny> „quantity” data group

XML sectionMandatoryTypeLenghtDescription
MennyisegYesNUM18+3Quantity. (Max. 18 character +3 decimals.)
NegysArYesNUM15+6

Item price. (Max. 15 character +6 decimals.)