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

ISC/UATP Calculation

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 Benjamin R on 2010-09-28 10:34:01 Back to Topics

ISC/UATP Calculation

Hi,

We need some help with ISC and UATP calculation in the RM coupon breakdown, elements 35 and 61. For both the validation column reads:

1. In case of Rejection Stage in the parent Rejection Record = "1" or "3"  ISC/UATP Amount Difference = ISC/UATP Amount Allowed (Element YY) - ISC /UATP Amount Accepted (Element XX)
2. In case of Rejection Stage in the parent Rejection Record = "2"  ISC /UATP Amount Difference = ISC/UATP Amount Accepted (Element XX) - ISC /UATP Amount Allowed (Element YY) 

On 2nd rejection stage, where you have to deduct the "amount allowed" from the "amount accepted", the calculation somehow doens't make sense, as it results to the contrary as actually intended. Please refer to attached Excel for more clarification. Thanks.
 
Replied by James S on 2010-09-29 10:11:18

Hi.

We've looked at this and it seems OK. Note that we're using negatives as the ISC is deducted from the fare.

gross

isc %

isc amt

Total

Rej 1

billed/allowed

100

-5%

-5

95

accepted

80

-5%

-4

76

difference

20

-1

19

19

gross

isc %

isc amt

Rej 2

billed/allowed

80

-5%

-4

76

accepted

90

-5%

-4.5

85.5

difference

10

-0.5

9.5

9.5

See the attached excel for better formatting / formulas.

James

 
ADVERTISEMENT


Additional information

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