You created an Excel spreadsheet for territory rules and uploaded it to Cloud for Customer, but the territories are not derived as defined in the rules.
SAP Hybris Cloud for Customer
Reproducing the Issue
Pre-requisite: You created an Excel spreadsheet for territory rules including exclusion conditions.
- Go to the Administrator work center.
- Go to the Sales and Campaign Settings view.
- Open Define Rules for Territory Realignment.
- Go to Upload.
- Select your previously created spreadsheet.
- Activate the rules.
Result: The territory rules do not work and territories are not derived.
You created an Excel spreadsheet with exclusion conditions as follows:
Exclude [ZABC ; ZDEF ; ZGHI ; ZJKL ; ZMNO]
In order for the 'Exclude' operator to work correctly, it needs a preceding inclusion operator.
In the Excel spreadsheet, an exclusion list has to be defined as follows:
starts with A; starts with B ; starts with C ; starts with Z ; exclude A001; exclude B002; exclude C003; exclude Z004
(A, B and C stand for standard values; Z stands for custom values).
The exclusion operators can be adjusted to the business needs, as long as they are preceded by the inclusion operators.
No brackets should be maintained in the spreadsheet.
Please note, that multiple exclusion parameters currently only work, when uploaded via Excel.
In the UI, the exclusion operator is currently displayed as inclusion operator.
In the coming releases, it is planned to enhance the value handling related to the 'Exclude' operator.
territory rules, rule download, rule upload, exclusion condition, rule condition, include, exlude, rule operator , KBA , LOD-CRM-TM , Territory Management , Problem