Symptom
Your requirement is to add Sales Territories for existing Accounts using Data Workbench. For the object Sales Territory Account, upon uploading the file in the Update view, system throws the Processing error:
Territory ID XXXXX doesn't exist
Reproducing the Issue
- Login to the HTML5 client
- Go to Data Workbench workcenter
- Go to Import tab
- In the search field, select the object Sales Territory Account
- Select Download Metadata
- Fill data in the fields CustomerID and TerritoryId
- Save the file
To upload the file:
- Login to the HTML5 client
- Go to Data Workbench workcenter
- Go to the Update tab
- Select the object Sales Territory Account
- Select Next and Browse for the file
- Select Upload
- Choose Next
- Select Update
- In the Monitor tab, check for the respective Task ID
- The records in the file have the Processing Error
Resolution
This feature is not supported, there is a Workaround which allows to Import the new Sales Territory data for the Accounts.
You may follow the below steps:
- Export the Sales Territories using Data workbench and Download the exported file
- Export Sales Territory Account (just to use it as template) and Download the exported file
- For the file downloaded in the step-2, Delete columns HeaderObjectID and CustomerUUID
- For the ObjectID column, do not fill any data, leave it empty
- Get ObjectID for Sales Territory from Sales Territory file (which was exported file in step-1) and copy to ParentObjectID field
- Fill the data for CustomerID and TerritoryId
- Go to Update view in Data Workbench and use the above file to Upload
This successfully creates records of Sales Territory Account
Keywords
Sales Territory Account, Sales Territories , KBA , territory id doesn't exist , territory id does not exist , territory id , sales territory account , sales territories , LOD-CRM-INT-API , OData API (C4C Only) , Problem