Skip to main content

Test Home
You & IATA

Search

You are here: Home » Services » Financial Services » Simplified Interline Settlement » SIS Forums
  • Print this page
  • Share this page

IS-XML Example V3.2 - PAX_Non_Sampling_IS_XML_Input_File.xml

This is a read-only copy of the discussions. To view the original, where you can reply, go here. For info on how to log in, please see the instructions.

Created by Thomas D (ISO Software Systeme GmbH) on 2011-09-01 02:53:20 Back to Topics

IS-XML Example V3.2 - PAX_Non_Sampling_IS_XML_Input_File.xml

Dear all,
I'm a little bit confused about the invoice summary information of example invoice 'R12K123451'.

Please see the following XML code piece:
<TotalVATAmount>-65.840</TotalVATAmount>
<TotalAmountWithoutVAT>2848.510</TotalAmountWithoutVAT>
<TotalAmount>2782.670</TotalAmount>
<TotalAmountInClearanceCurrency>2782.670</TotalAmountInClearanceCurrency>

In my opinion the calculation of the total amount is not correct. How can it be that "TotalAmountWithoutVAT" is higher than "TotalAmount". I have a guess how it happened: 2781.67 - (-65.84) = 2848.51
Can you please check this?

Thank you and best regards
Thomas
 
Replied by Ashley H on 2011-09-02 14:26:06

Dear Thomas,

 

The VAT amount needs to be added to the Total Amount Without VAT to derive the Total Amount. Therefore this calculation is done as follows:

 

-65.84 + 2848.51 = 2782.67

 

Hope that clarifies.

Best regards

 

From: DORN Thomas [mailto:thomas.dorn@isogmbh.de]
Posted At: Thursday, September 01, 2011 2:53 AM
Posted To: SIS Forums - Record Structures
Conversation: IS-XML Example V3.2 - PAX_Non_Sampling_IS_XML_Input_File.xml
Subject: IS-XML Example V3.2 - PAX_Non_Sampling_IS_XML_Input_File.xml

 

Dear all,

I'm a little bit confused about the invoice summary information of example invoice 'R12K123451'.

Please see the following XML code piece:

<TotalVATAmount>-65.840</TotalVATAmount>
<TotalAmountWithoutVAT>2848.510</TotalAmountWithoutVAT>
<TotalAmount>2782.670</TotalAmount>
<TotalAmountInClearanceCurrency>2782.670</TotalAmountInClearanceCurrency>


In my opinion the calculation of the total amount is not correct. How can it be that "TotalAmountWithoutVAT" is higher than "TotalAmount". I have a guess how it happened: 2781.67 - (-65.84) = 2848.51

Can you please check this?


Thank you and best regards
Thomas

 

Replied by Thomas D (ISO Software Systeme GmbH) on 2011-09-05 03:02:40
Dear Ashley,
 
thanks you for your reply. Yes, that's what I already thought. In my opinion the example file V3.2 is wrong. Is that true? Please see the code pice I included in my first email.
 
Best regrads
Thomas


From:
Posted: Friday, September 02, 2011 2:26 PM
Subject: IS-XML Example V3.2 - PAX_Non_Sampling_IS_XML_Input_File.xml

Dear Thomas,

 

The VAT amount needs to be added to the Total Amount Without VAT to derive the Total Amount. Therefore this calculation is done as follows:

 

-65.84 + 2848.51 = 2782.67

 

Hope that clarifies.

Best regards

 

From: DORN Thomas [mailto:thomas.dorn@isogmbh.de]
Posted At: Thursday, September 01, 2011 2:53 AM
Posted To: SIS Forums - Record Structures
Conversation: IS-XML Example V3.2 - PAX_Non_Sampling_IS_XML_Input_File.xml
Subject: IS-XML Example V3.2 - PAX_Non_Sampling_IS_XML_Input_File.xml

 

Dear all,

I'm a little bit confused about the invoice summary information of example invoice 'R12K123451'.

Please see the following XML code piece:

<TotalVATAmount>-65.840</TotalVATAmount>
<TotalAmountWithoutVAT>2848.510</TotalAmountWithoutVAT>
<TotalAmount>2782.670</TotalAmount>
<TotalAmountInClearanceCurrency>2782.670</TotalAmountInClearanceCurrency>


In my opinion the calculation of the total amount is not correct. How can it be that "TotalAmountWithoutVAT" is higher than "TotalAmount". I have a guess how it happened: 2781.67 - (-65.84) = 2848.51

Can you please check this?


Thank you and best regards
Thomas

 

Replied by Ashley H on 2011-09-08 15:45:43

Hi Thomas,

 

The example is correct. TotalVATAmount should be added to the TotalAmountWithoutVAT to derive at the TotalAmount.

 

Hope that clarifies.

Best regards

 

From: DORN Thomas [mailto:thomas.dorn@isogmbh.de]
Posted At: Monday, September 05, 2011 3:03 AM
Posted To: SIS Forums - Record Structures
Conversation: IS-XML Example V3.2 - PAX_Non_Sampling_IS_XML_Input_File.xml
Subject: IS-XML Example V3.2 - PAX_Non_Sampling_IS_XML_Input_File.xml

 

Dear Ashley,

 

thanks you for your reply. Yes, that's what I already thought. In my opinion the example file V3.2 is wrong. Is that true? Please see the code pice I included in my first email.

 

Best regrads

Thomas


From:
Posted: Friday, September 02, 2011 2:26 PM
Subject: IS-XML Example V3.2 - PAX_Non_Sampling_IS_XML_Input_File.xml

Dear Thomas,

 

The VAT amount needs to be added to the Total Amount Without VAT to derive the Total Amount. Therefore this calculation is done as follows:

 

-65.84 + 2848.51 = 2782.67

 

Hope that clarifies.

Best regards

 

From: DORN Thomas [mailto:thomas.dorn@isogmbh.de]
Posted At: Thursday, September 01, 2011 2:53 AM
Posted To: SIS Forums - Record Structures
Conversation: IS-XML Example V3.2 - PAX_Non_Sampling_IS_XML_Input_File.xml
Subject: IS-XML Example V3.2 - PAX_Non_Sampling_IS_XML_Input_File.xml

 

Dear all,

I'm a little bit confused about the invoice summary information of example invoice 'R12K123451'.

Please see the following XML code piece:

<TotalVATAmount>-65.840</TotalVATAmount>
<TotalAmountWithoutVAT>2848.510</TotalAmountWithoutVAT>
<TotalAmount>2782.670</TotalAmount>
<TotalAmountInClearanceCurrency>2782.670</TotalAmountInClearanceCurrency>


In my opinion the calculation of the total amount is not correct. How can it be that "TotalAmountWithoutVAT" is higher than "TotalAmount". I have a guess how it happened: 2781.67 - (-65.84) = 2848.51

Can you please check this?


Thank you and best regards
Thomas

 

 
ADVERTISEMENT


Additional information

© International Air Transport Association (IATA) 2014. All rights reserved.