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

CoL to CoB

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 Erik M (SAS) on 2012-01-03 10:38:45 Back to Topics

CoL to CoB

Hi,
Record 10, Element 21 should hold the Listing to Billing Rate. In the example in the ISPG you use INR to USD rate: 46,82086 (which is the 'division rate' as shown IATA rate list).
Record 40, Element 16 should hold the Net Billing Amount.
According to the ISPG the validation in element 16 is: 'equal to Net Total / Listing to Billing Rate (rec 10, element 21).
 
How should the above elements be populated if we were talking about an invoice with Listing = USD and Billing (bilateral) = INR?
Should we use the rate as above but then multiply with 46,82086?
OR should we use the reciprocal rate 1/46,82086 = 0,02136?
If we use the reciprocal rate we see the problem as shown in this example: Amt in Sales Curr INR 100000, converted to CoL USD via 46,82086= USD 2135.80, converted to CoB=INR over 0,02136 = INR 99990.64!
We think that conversion should via the same rate, i.e. when converting from a 'local curr' to USD you shoud multiply, i.e. record 10, element 21 should be 46,82086 AND the validation rule for record 40, element 21 should show this conversion rule, i.e. that we should multiply.
 
Could you please explain what to do / consider our suggestion.
 
Brgds,
Erik Madsen, SAS
Replied by Ashley H on 2012-01-11 16:14:33

Hi Erik,

 

Would you please let us know which documentation you are referring to in your query above (e.g. PAX IS-IDEC, etc.). We would then be able to fully answer your question.

 

Thanks and best regards,

Ashley

 

From: MADSEN Erik
Posted At: January-03-12 10:39 AM
Posted To: SIS Forums - Requirements & Functionality
Conversation: CoL to CoB
Subject: CoL to CoB

 

Hi,

Record 10, Element 21 should hold the Listing to Billing Rate. In the example in the ISPG you use INR to USD rate: 46,82086 (which is the 'division rate' as shown IATA rate list).

Record 40, Element 16 should hold the Net Billing Amount.

According to the ISPG the validation in element 16 is: 'equal to Net Total / Listing to Billing Rate (rec 10, element 21).

 

How should the above elements be populated if we were talking about an invoice with Listing = USD and Billing (bilateral) = INR?

Should we use the rate as above but then multiply with 46,82086?

OR should we use the reciprocal rate 1/46,82086 = 0,02136?

If we use the reciprocal rate we see the problem as shown in this example: Amt in Sales Curr INR 100000, converted to CoL USD via 46,82086= USD 2135.80, converted to CoB=INR over 0,02136 = INR 99990.64!

We think that conversion should via the same rate, i.e. when converting from a 'local curr' to USD you shoud multiply, i.e. record 10, element 21 should be 46,82086 AND the validation rule for record 40, element 21 should show this conversion rule, i.e. that we should multiply.

 

Could you please explain what to do / consider our suggestion.

 

Brgds,

Erik Madsen, SAS

Replied by Erik M (SAS) on 2012-01-20 08:45:30
Hi Ashley,
I'm reffering to the IS-Idec description (Excel) which is included in the ISPG ZIP file.
Brgds,
Erik


From:
Posted: 1/11/2012 4:14 PM
Subject: CoL to CoB

Hi Erik,

 

Would you please let us know which documentation you are referring to in your query above (e.g. PAX IS-IDEC, etc.). We would then be able to fully answer your question.

 

Thanks and best regards,

Ashley

 

From: MADSEN Erik
Posted At: January-03-12 10:39 AM
Posted To: SIS Forums - Requirements & Functionality
Conversation: CoL to CoB
Subject: CoL to CoB

 

Hi,

Record 10, Element 21 should hold the Listing to Billing Rate. In the example in the ISPG you use INR to USD rate: 46,82086 (which is the 'division rate' as shown IATA rate list).

Record 40, Element 16 should hold the Net Billing Amount.

According to the ISPG the validation in element 16 is: 'equal to Net Total / Listing to Billing Rate (rec 10, element 21).

 

How should the above elements be populated if we were talking about an invoice with Listing = USD and Billing (bilateral) = INR?

Should we use the rate as above but then multiply with 46,82086?

OR should we use the reciprocal rate 1/46,82086 = 0,02136?

If we use the reciprocal rate we see the problem as shown in this example: Amt in Sales Curr INR 100000, converted to CoL USD via 46,82086= USD 2135.80, converted to CoB=INR over 0,02136 = INR 99990.64!

We think that conversion should via the same rate, i.e. when converting from a 'local curr' to USD you shoud multiply, i.e. record 10, element 21 should be 46,82086 AND the validation rule for record 40, element 21 should show this conversion rule, i.e. that we should multiply.

 

Could you please explain what to do / consider our suggestion.

 

Brgds,

Erik Madsen, SAS

 
ADVERTISEMENT


Additional information

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