Symptom
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.
Environment
SAP Business ByDesign
Reproducing the Issue
- Go to the Sales Orders work center.
- Select the Contracts view.
- Open contract XYZ (XYZ represents the ID of the contract).
- Go to the Items tab.
- Select the line item XX (XX represents the line item number).
- Go to the General sub tab.
- Enter a Cancellation Received On date, a Cancellation Requested For date and a Cancellation Reason.
- In the field Cancellation Effective On enter the same date as in the field Contract Item Start.
- The following error occurs: Item XX: Effective cancellation date must be between contract start and end dates.
Cause
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.
Resolution
You can cancel the contract line item with a Cancellation Effective On date that is 1 day after the Contract Item Start date.
Keywords
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