Sage CRM has inbuilt powerful Security mechanism known as “Territories”. By setting territories in Sage CRM, we can restrict one user from accessing records of another user belonging to different territory. Territory field is available on Main entities. A territory can be defined geographically, by product area or by any other criteria.
One of our client came up with a requirement of reorganization of territories created in CRM. Well this can be done using Standard mechanism “Move Territory” provided in Sage CRM. For this we followed below steps.
- Login to Sage CRM.
- Go to Administration -> Users -> Security -> Move Territory.
- Select the Source Territory and click on Next button.
- Select the Target Territory and click on Next button.
Sometimes there are records in primary entities having blank territory which cause this functionality to throw an error and stops the entire process of territory movement. We searched for such records in database but didn’t found the same. So, we searched in CRM logs folder where we saw “ewareterritoryerrors” log file was generated. We checked that file and found below error.
“Territory 1630496512 in table Cases does not have a corresponding territory in the territory table”
We searched for the above territory id in Territories table and found that it does not exists in it. So, for such records we updated other territory id and performed Move Territory functionality again. And it worked successfully.
Greytrix – a globally recognized and one of the oldest Sage Gold Development Partner is a one-stop solution provider for Sage ERP and Sage CRM organizational needs. Being acknowledged and rewarded for multi-man years of experience and expertise, we bring complete end-to-end assistance for your technical consultations, product customizations, data migration, system integrations, third party add-on development and implementation competence.
Greytrix has some unique integration solutions developed for Sage CRM with Sage ERPs namely Sage X3, Sage Intacct, Sage 100, Sage 500 and Sage 300. We also offer best-in-class Sage ERP and Sage CRM customization and development services to Business Partners, End Users and Sage PSG worldwide. Greytrix helps in migration of Sage CRM from Salesforce | ACT! | SalesLogix | Goldmine | Sugar CRM | Maximizer. Our Sage CRM Product Suite includes addons like Greytrix Business Manager, Sage CRM Project Manager, Sage CRM Resource Planner, Sage CRM Contract Manager, Sage CRM Event Manager, Sage CRM Budget Planner, Gmail Integration, Sage CRM Mobile Service Signature and Sage CRM CTI Framework.
Greytrix is a recognized Sage Champion ISV Partner for GUMU™ Sage X3 – Sage CRM integration also listed on Sage Marketplace.
For more information on our integration solutions, please contact us at firstname.lastname@example.org. We will be glad to assist you.