SAP Knowledge Base Article - Public

2153275 - Not able to Cancel a Contract Line Item with the Same Date as the Start Date


You are not able to cancel a contract line item for which the Cancellation Effective On date is the same date as the as Contract Item Start date due to the following error message: Item XX: Effective cancellation date must be between contract start and end dates.


SAP Business ByDesign

Reproducing the Issue

  1. Go to the Sales Orders work center. 
  2. Select the Contracts view.
  3. Open contract XYZ (XYZ represents the ID of the contract).
  4. Go to the Items tab.
  5. Select the line item XX (XX represents the line item number).
  6. Go to the General sub tab.
  7. Enter a Cancellation Received On date, a Cancellation Requested For date and a Cancellation Reason.
  8. In the field Cancellation Effective On enter the same date as in the field Contract Item Start.
  9. The following error occurs: Item XX: Effective cancellation date must be between contract start and end dates.


The contract was migrated. In a migrated contract the Cancellation Effective On date cannot be the same date as the as Contract Item Start date.

In a manually created contract the contract item start date, the item end date and the cancellation effective date are saved in the backend in UTC time zone (taking into account the proper conversion from local time zone to UTC) . When a contract is migrated then we have to explicitly specify the timestamp as 00:00:00 therefore, the timestamp of the original contract is lost and is defaulted to 00:00:00 for a migrated contract. Now, when the user tries to cancel this contract then timestamp is taken into consideration according to the users settings.

For example: The Contract Item Start Date for a migrated contract is 09.10.1999 (the timestamp is saved as 09.10.1999 00:00:00 backend). If a user is using a different time zone than UTC, e.g. the time zone AUSNSW (UTC+10) and the  user enters the cancellation effective date as 09.10.1999, then in the backend this is stored as 08.10.1999 14:00:00 (respective to the UTC conversion) and therefore the cancellation effective date will be less than contract item start date.


You can cancel the contract line item with a Cancellation Effective On date that is 1 day after the Contract Item Start date.


effective cancellation date must be between contract start and end dates, effective cancellation date, cancel, contract, contract item start date, cancellation effective on, migrated contract , KBA , effective cancellation date , contract start and end dates , AP-SLO , Sales Order Processing , How To


SAP BUSINESS BYDESIGN 1611 ; SAP BUSINESS BYDESIGN 1705 ; SAP Business ByDesign 1502 ; SAP Business ByDesign 1505 ; SAP Business ByDesign 1508 ; SAP Business ByDesign 1511 ; SAP Business ByDesign 1602 ; SAP Business ByDesign 1605 ; SAP Business ByDesign 1608 ; SAP Business ByDesign 1702