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

Validation for Sampling: invoice vs. listing

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 Claudia L on 2010-09-07 10:20:11 Back to Topics

Validation for Sampling: invoice vs. listing

Hi James,
 
scenario first billing: IATA validates that the invoice totals for fare, tax, ISC etc. match the total of all coupon records and their breakdowns.
For sampling form A/B, we assume that based on the billing code 3 IATA applies the reported absorption rates before comparing the (non adjusted) coupon amounts with the (adjusted) invoice total amounts?
The validations for SFI 40 (invoice total record) mentioned in the IDEC-xls-document for version 2.1 do not mention anything like that.
 
Please confirm.
Thanks
Claudia
Replied by James S on 2010-09-20 09:09:04
The Invoice total validation in case of Billing Code 3 will be based on Total Gross Amount + (-) Total Provisional Adjustment Amount. The reported individual absorption rate/amounts will be added and checked with the Total Provisional Adjustment Rate/Amount, thus ensuring that they add up correctly.
Replied by Marian S (IBERIA) on 2011-10-20 09:11:02



From:
Posted: Monday, September 20, 2010 9:09 AM
Subject: Validation for Sampling: invoice vs. listing

The Invoice total validation in case of Billing Code 3 will be based on Total Gross Amount + (-) Total Provisional Adjustment Amount. The reported individual absorption rate/amounts will be added and checked with the Total Provisional Adjustment Rate/Amount, thus ensuring that they add up correctly.
Replied by Marian S (IBERIA) on 2011-10-20 09:11:55

Hello, we are having some problems with sampling invoices to be validated in the Sand Box.
The validation that we are not able to pass is the one that is done at PAX-Invoice Total Record:
1. In case "Provisional Adjustment Rate" is provided then it should be equal to "Total Gross Value" multiplied by "Provisional Adjustment Rate"
 
Our problem is that the 'Provisional Adjustment Rate' is calculated adding this amount of each coupon in the invoice. 
As you know is not the same add and then aplly the rate, than apply the rate and then add.
We have very little differences that would disappear if the rate have more decimal places, we would need 5 decimal places. Is these possible? Could you explain us how any other airlines have solved this problem?
Thank you so much.
Marian.


From:
Posted: Monday, September 20, 2010 9:09 AM
Subject: Validation for Sampling: invoice vs. listing

The Invoice total validation in case of Billing Code 3 will be based on Total Gross Amount + (-) Total Provisional Adjustment Amount. The reported individual absorption rate/amounts will be added and checked with the Total Provisional Adjustment Rate/Amount, thus ensuring that they add up correctly.
Replied by Ashley H on 2011-10-20 15:23:41

Dear Marian,

For this particular issue I would like to ask if you can kindly create a Help Desk case via the embedded link. This way the SIS Help Desk can attend to your inquiries in a swifter manner.

For further reference, please follow such a procedure for any issues related to the Sandbox or the SIS live environment. Please also see the SIS Help Desk Process document for details on how SIS Operations will handle your logged cases.

Best regards

 

From: SANCHEZ Marian
Posted At: Thursday, October 20, 2011 9:12 AM
Posted To: SIS Forums - Record Structures
Conversation: Validation for Sampling: invoice vs. listing
Subject: Validation for Sampling: invoice vs. listing

 

 

Hello, we are having some problems with sampling invoices to be validated in the Sand Box.

The validation that we are not able to pass is the one that is done at PAX-Invoice Total Record:

1. In case "Provisional Adjustment Rate" is provided then it should be equal to "Total Gross Value" multiplied by "Provisional Adjustment Rate"

 

Our problem is that the 'Provisional Adjustment Rate' is calculated adding this amount of each coupon in the invoice. 

As you know is not the same add and then aplly the rate, than apply the rate and then add.

We have very little differences that would disappear if the rate have more decimal places, we would need 5 decimal places. Is these possible? Could you explain us how any other airlines have solved this problem?

Thank you so much.

Marian.

 


From:
Posted: Monday, September 20, 2010 9:09 AM
Subject: Validation for Sampling: invoice vs. listing

The Invoice total validation in case of Billing Code 3 will be based on Total Gross Amount + (-) Total Provisional Adjustment Amount. The reported individual absorption rate/amounts will be added and checked with the Total Provisional Adjustment Rate/Amount, thus ensuring that they add up correctly.

Replied by Marian S (IBERIA) on 2011-10-26 04:38:24
Thank you, I have just sent the case to the help desk.
Best Regards
Marian


From:
Posted: Thursday, October 20, 2011 3:23 PM
Subject: Validation for Sampling: invoice vs. listing

Dear Marian,

For this particular issue I would like to ask if you can kindly create a Help Desk case via the embedded link. This way the SIS Help Desk can attend to your inquiries in a swifter manner.

For further reference, please follow such a procedure for any issues related to the Sandbox or the SIS live environment. Please also see the SIS Help Desk Process document for details on how SIS Operations will handle your logged cases.

Best regards

 

From: SANCHEZ Marian
Posted At: Thursday, October 20, 2011 9:12 AM
Posted To: SIS Forums - Record Structures
Conversation: Validation for Sampling: invoice vs. listing
Subject: Validation for Sampling: invoice vs. listing

 

 

Hello, we are having some problems with sampling invoices to be validated in the Sand Box.

The validation that we are not able to pass is the one that is done at PAX-Invoice Total Record:

1. In case "Provisional Adjustment Rate" is provided then it should be equal to "Total Gross Value" multiplied by "Provisional Adjustment Rate"

 

Our problem is that the 'Provisional Adjustment Rate' is calculated adding this amount of each coupon in the invoice. 

As you know is not the same add and then aplly the rate, than apply the rate and then add.

We have very little differences that would disappear if the rate have more decimal places, we would need 5 decimal places. Is these possible? Could you explain us how any other airlines have solved this problem?

Thank you so much.

Marian.

 


From:
Posted: Monday, September 20, 2010 9:09 AM
Subject: Validation for Sampling: invoice vs. listing

The Invoice total validation in case of Billing Code 3 will be based on Total Gross Amount + (-) Total Provisional Adjustment Amount. The reported individual absorption rate/amounts will be added and checked with the Total Provisional Adjustment Rate/Amount, thus ensuring that they add up correctly.

 
ADVERTISEMENT


Additional information

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