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

Misc question - Start & End Dates

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 Peter W on 2011-03-10 06:23:35 Back to Topics

Misc question - Start & End Dates

Have a question about the Start & End dates on the Line Item &  Line Item Detail records in the Misc XML spec -
 
According to the IS XML Standard V3.1, the Start & End dates on both the Line Item & Line Item Detail records are a Legal requirement - hence mandatory.
 
On the validation for Start Date on the Line Item it states that
 
If the line item refers to a specific date on which goods or services were delivered, then no start date is required. If the line item refers to a period during which goods or services were delivered, then the StartDate is required and refers to the start date of that period.
 
So if the invoice covers one date we would only need to populate the end date, but this is contrary to Start Date being a mandatory field
 
It gets even better on the validation of Start Date on the Line Item Detail record where it states
If there is only one EndDate at the related Line Item level then there should be no StartDate at this level else it will result in a validation error
I take it that where it says only one end date you actually mean start & end date are the same (as End Date has an occurrence of 0-1 you cannot have more than one end date)
 
As far as I can see, if we raise an invoice for just one day (ie not covering a period of days) there is no way we can get this past SIS validation - if we populate Start Date at Line Item Detail level it will fail validation as this is not allowed & if we don't populate it, validation will fail as it's a mandatory field.
 
Would greatly appreciate if you could clarify the exact validation of these dates
Replied by Ashley H on 2011-03-11 12:56:03

Dear Peter,

 

Please find the following clarification to your questions below:

 

If the line item refers to a specific date on which goods or services were delivered, then no start date is required. If the line item refers to a period during which goods or services were delivered, then the StartDate is required and refers to the start date of that period.

 

So if the invoice covers one date we would only need to populate the end date, but this is contrary to Start Date being a mandatory field?

 

‘StartDate’ is an optional field and is legally required only if the service is for a date range. In case of a service provided on a single date, only the ‘EndDate’ should be provided.

I understand the concern you have raised because ‘StartDate’ has been defined as a legal field and the definition of a legal field in the ‘Notes’ worksheet states that all legal fields are mandatory which in this case is misleading. We will rephrase this in the later release of the ISPG.

 

If there is only one EndDate at the related Line Item level then there should be no StartDate at this level else it will result in a validation error

 

I take it that where it says only one end date you actually mean start & end date are the same (as End Date has an occurrence of 0-1 you cannot have more than one end date)

 

‘StartDate’ and ‘EndDate’ cannot be the same. In case of a service provided on a single date, only the ‘EndDate’ needs to be provided.

 

In general, Line Item Detail is basically a breakdown of the Line Item. Hence, if the Line Item states that the charge is for a service provided on a single date then only the ‘EndDate’ would have been provided at the Line Item level. Hence, the breakdown cannot have a date range. Thus the validation restricts the user from providing a date range when there is a single date at the higher level. Secondly, the ‘EndDate’ at the breakdown level (Line Item Detail) should be the same as that provided at the higher level (Line Item).

 

Hope this helps.

Best regards


From:
Posted: Thursday, March 10, 2011 6:23 AM
Subject: Misc question - Start & End Dates

Have a question about the Start & End dates on the Line Item &  Line Item Detail records in the Misc XML spec -
 
According to the IS XML Standard V3.1, the Start & End dates on both the Line Item & Line Item Detail records are a Legal requirement - hence mandatory.
 
On the validation for Start Date on the Line Item it states that
 
If the line item refers to a specific date on which goods or services were delivered, then no start date is required. If the line item refers to a period during which goods or services were delivered, then the StartDate is required and refers to the start date of that period.
 
So if the invoice covers one date we would only need to populate the end date, but this is contrary to Start Date being a mandatory field
 
It gets even better on the validation of Start Date on the Line Item Detail record where it states
If there is only one EndDate at the related Line Item level then there should be no StartDate at this level else it will result in a validation error
I take it that where it says only one end date you actually mean start & end date are the same (as End Date has an occurrence of 0-1 you cannot have more than one end date)
 
As far as I can see, if we raise an invoice for just one day (ie not covering a period of days) there is no way we can get this past SIS validation - if we populate Start Date at Line Item Detail level it will fail validation as this is not allowed & if we don't populate it, validation will fail as it's a mandatory field.
 
Would greatly appreciate if you could clarify the exact validation of these dates
Replied by Peter W (British Airways) on 2011-03-14 09:38:03



From:
Posted: Friday, March 11, 2011 12:56 PM
Subject: Misc question - Start & End Dates

Dear Peter,

 

Please find the following clarification to your questions below:

 

If the line item refers to a specific date on which goods or services were delivered, then no start date is required. If the line item refers to a period during which goods or services were delivered, then the StartDate is required and refers to the start date of that period.

 

So if the invoice covers one date we would only need to populate the end date, but this is contrary to Start Date being a mandatory field?

 

‘StartDate’ is an optional field and is legally required only if the service is for a date range. In case of a service provided on a single date, only the ‘EndDate’ should be provided.

I understand the concern you have raised because ‘StartDate’ has been defined as a legal field and the definition of a legal field in the ‘Notes’ worksheet states that all legal fields are mandatory which in this case is misleading. We will rephrase this in the later release of the ISPG.

 

If there is only one EndDate at the related Line Item level then there should be no StartDate at this level else it will result in a validation error

 

I take it that where it says only one end date you actually mean start & end date are the same (as End Date has an occurrence of 0-1 you cannot have more than one end date)

 

‘StartDate’ and ‘EndDate’ cannot be the same. In case of a service provided on a single date, only the ‘EndDate’ needs to be provided.

 

In general, Line Item Detail is basically a breakdown of the Line Item. Hence, if the Line Item states that the charge is for a service provided on a single date then only the ‘EndDate’ would have been provided at the Line Item level. Hence, the breakdown cannot have a date range. Thus the validation restricts the user from providing a date range when there is a single date at the higher level. Secondly, the ‘EndDate’ at the breakdown level (Line Item Detail) should be the same as that provided at the higher level (Line Item).

 

Hope this helps.

Best regards


From:
Posted: Thursday, March 10, 2011 6:23 AM
Subject: Misc question - Start & End Dates

Have a question about the Start & End dates on the Line Item &  Line Item Detail records in the Misc XML spec -
 
According to the IS XML Standard V3.1, the Start & End dates on both the Line Item & Line Item Detail records are a Legal requirement - hence mandatory.
 
On the validation for Start Date on the Line Item it states that
 
If the line item refers to a specific date on which goods or services were delivered, then no start date is required. If the line item refers to a period during which goods or services were delivered, then the StartDate is required and refers to the start date of that period.
 
So if the invoice covers one date we would only need to populate the end date, but this is contrary to Start Date being a mandatory field
 
It gets even better on the validation of Start Date on the Line Item Detail record where it states
If there is only one EndDate at the related Line Item level then there should be no StartDate at this level else it will result in a validation error
I take it that where it says only one end date you actually mean start & end date are the same (as End Date has an occurrence of 0-1 you cannot have more than one end date)
 
As far as I can see, if we raise an invoice for just one day (ie not covering a period of days) there is no way we can get this past SIS validation - if we populate Start Date at Line Item Detail level it will fail validation as this is not allowed & if we don't populate it, validation will fail as it's a mandatory field.
 
Would greatly appreciate if you could clarify the exact validation of these dates
Replied by Binbin D (Accounting Centre of Chin) on 2011-03-15 03:26:56
May I add my question here?
Do you mean that whenever the End Date equals to Start Date, the IS-xml will fail the validation of SIS?
Please clarify.


From:
Posted: Monday, March 14, 2011 9:38 AM
Subject: Misc question - Start & End Dates




From:
Posted: Friday, March 11, 2011 12:56 PM
Subject: Misc question - Start & End Dates

Dear Peter,

 

Please find the following clarification to your questions below:

 

If the line item refers to a specific date on which goods or services were delivered, then no start date is required. If the line item refers to a period during which goods or services were delivered, then the StartDate is required and refers to the start date of that period.

 

So if the invoice covers one date we would only need to populate the end date, but this is contrary to Start Date being a mandatory field?

 

‘StartDate’ is an optional field and is legally required only if the service is for a date range. In case of a service provided on a single date, only the ‘EndDate’ should be provided.

I understand the concern you have raised because ‘StartDate’ has been defined as a legal field and the definition of a legal field in the ‘Notes’ worksheet states that all legal fields are mandatory which in this case is misleading. We will rephrase this in the later release of the ISPG.

 

If there is only one EndDate at the related Line Item level then there should be no StartDate at this level else it will result in a validation error

 

I take it that where it says only one end date you actually mean start & end date are the same (as End Date has an occurrence of 0-1 you cannot have more than one end date)

 

‘StartDate’ and ‘EndDate’ cannot be the same. In case of a service provided on a single date, only the ‘EndDate’ needs to be provided.

 

In general, Line Item Detail is basically a breakdown of the Line Item. Hence, if the Line Item states that the charge is for a service provided on a single date then only the ‘EndDate’ would have been provided at the Line Item level. Hence, the breakdown cannot have a date range. Thus the validation restricts the user from providing a date range when there is a single date at the higher level. Secondly, the ‘EndDate’ at the breakdown level (Line Item Detail) should be the same as that provided at the higher level (Line Item).

 

Hope this helps.

Best regards


From:
Posted: Thursday, March 10, 2011 6:23 AM
Subject: Misc question - Start & End Dates

Have a question about the Start & End dates on the Line Item &  Line Item Detail records in the Misc XML spec -
 
According to the IS XML Standard V3.1, the Start & End dates on both the Line Item & Line Item Detail records are a Legal requirement - hence mandatory.
 
On the validation for Start Date on the Line Item it states that
 
If the line item refers to a specific date on which goods or services were delivered, then no start date is required. If the line item refers to a period during which goods or services were delivered, then the StartDate is required and refers to the start date of that period.
 
So if the invoice covers one date we would only need to populate the end date, but this is contrary to Start Date being a mandatory field
 
It gets even better on the validation of Start Date on the Line Item Detail record where it states
If there is only one EndDate at the related Line Item level then there should be no StartDate at this level else it will result in a validation error
I take it that where it says only one end date you actually mean start & end date are the same (as End Date has an occurrence of 0-1 you cannot have more than one end date)
 
As far as I can see, if we raise an invoice for just one day (ie not covering a period of days) there is no way we can get this past SIS validation - if we populate Start Date at Line Item Detail level it will fail validation as this is not allowed & if we don't populate it, validation will fail as it's a mandatory field.
 
Would greatly appreciate if you could clarify the exact validation of these dates
Replied by Binbin D (Accounting Centre of Chin) on 2011-03-15 03:27:39
May I add my question here?
Do you mean that whenever the End Date equals to Start Date, the IS-xml will fail the validation of SIS?
Please clarify.


From:
Posted: Monday, March 14, 2011 9:38 AM
Subject: Misc question - Start & End Dates




From:
Posted: Friday, March 11, 2011 12:56 PM
Subject: Misc question - Start & End Dates

Dear Peter,

 

Please find the following clarification to your questions below:

 

If the line item refers to a specific date on which goods or services were delivered, then no start date is required. If the line item refers to a period during which goods or services were delivered, then the StartDate is required and refers to the start date of that period.

 

So if the invoice covers one date we would only need to populate the end date, but this is contrary to Start Date being a mandatory field?

 

‘StartDate’ is an optional field and is legally required only if the service is for a date range. In case of a service provided on a single date, only the ‘EndDate’ should be provided.

I understand the concern you have raised because ‘StartDate’ has been defined as a legal field and the definition of a legal field in the ‘Notes’ worksheet states that all legal fields are mandatory which in this case is misleading. We will rephrase this in the later release of the ISPG.

 

If there is only one EndDate at the related Line Item level then there should be no StartDate at this level else it will result in a validation error

 

I take it that where it says only one end date you actually mean start & end date are the same (as End Date has an occurrence of 0-1 you cannot have more than one end date)

 

‘StartDate’ and ‘EndDate’ cannot be the same. In case of a service provided on a single date, only the ‘EndDate’ needs to be provided.

 

In general, Line Item Detail is basically a breakdown of the Line Item. Hence, if the Line Item states that the charge is for a service provided on a single date then only the ‘EndDate’ would have been provided at the Line Item level. Hence, the breakdown cannot have a date range. Thus the validation restricts the user from providing a date range when there is a single date at the higher level. Secondly, the ‘EndDate’ at the breakdown level (Line Item Detail) should be the same as that provided at the higher level (Line Item).

 

Hope this helps.

Best regards


From:
Posted: Thursday, March 10, 2011 6:23 AM
Subject: Misc question - Start & End Dates

Have a question about the Start & End dates on the Line Item &  Line Item Detail records in the Misc XML spec -
 
According to the IS XML Standard V3.1, the Start & End dates on both the Line Item & Line Item Detail records are a Legal requirement - hence mandatory.
 
On the validation for Start Date on the Line Item it states that
 
If the line item refers to a specific date on which goods or services were delivered, then no start date is required. If the line item refers to a period during which goods or services were delivered, then the StartDate is required and refers to the start date of that period.
 
So if the invoice covers one date we would only need to populate the end date, but this is contrary to Start Date being a mandatory field
 
It gets even better on the validation of Start Date on the Line Item Detail record where it states
If there is only one EndDate at the related Line Item level then there should be no StartDate at this level else it will result in a validation error
I take it that where it says only one end date you actually mean start & end date are the same (as End Date has an occurrence of 0-1 you cannot have more than one end date)
 
As far as I can see, if we raise an invoice for just one day (ie not covering a period of days) there is no way we can get this past SIS validation - if we populate Start Date at Line Item Detail level it will fail validation as this is not allowed & if we don't populate it, validation will fail as it's a mandatory field.
 
Would greatly appreciate if you could clarify the exact validation of these dates
 
ADVERTISEMENT


Additional information

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