How to solve duplicate reports, visibility of accounts for regional sales manager,global account manager for sap customers using salesforce

If you are using Salesforce and SAP and if your regional and global sales managers complain that they see too much accounts or not able to identify the accounts under them, this post is for you. I was working with a customer  recently which had this problem recently and we were able to propose a solution which would work for them. So if your admin creates duplicate reports for each regional and global manager and you are wresting with how to solve this, this post would provide you principles.

Cause of the problem

The primary cause of the problem is the data model in SAP and SFDC are not matched right. In SAP, there is a customer which can have multiple ship to which are shipping locations and sold to which are the primary divisions of the customers dealing with business. There is also a sales org which is the organization division which deals with customer and division which are division of your customers which deal with customers.

In SFDC world, there is just parent and child accounts and no other object structure. So to match the data between both systems, most of the organizations follow these 2 models.

  1. Create a key on the account which is a combination of sales org, division, sold to and ship to in SFDC.
  2. Create a custom object linking the sold to and ship to account account and have sales org and divsion as attributes.

Because of the data model , when sales people are assigned to multiple accounts or global account managers having multiple accounts, visibility is impacted resulted in account owners with no value and other problems.

Territory Management to rescue

To solve the problem of assigning sales people to multiple accounts, Territory management could be an effective solution. 

The key principles on this solution are as follows,

  1. Create parent territories for each sales org in SAP.
  2. Create child division territories for each division in SAP.
  3. Assign Regional sales manager to the parent territory to enable visibility to all accounts in his region.
  4. Assign sales reps based on attribute of the acount which could be sold to, ship to, sales org or divsion code or any criteria which fits your business.

By enabling Enterprise territory management, you have the following advantages.

  1. The default my territories view can be used on views and reports for users to view their accounts.
  2. This can scale to any level of territories and beyond.

Enable visibility for global account managers to see all accounts

Due to current state architectures listed above, global account managers of accounts are not owner of parent accounts and they are not able to see all child accounts. Most of the organizations use parent account but the owner of parent accounts tend to be integration users, dummy accounts owner or users of no value. To solve this problem, here are some guidelines.

  1. Set parent account owner as the global account owner.
  2. Leverage account teams on child accounts and add global account owner to the child account teams using custom code to populate automatically. This would ensure that the global account owner can see all child accounts.

Key take aways.

Here are the top 3 key take aways for you on solving the visibility issue.

  1. Leverage territory management to mimic your SAP object structure to enable visibility and scalability.
  2. Have fields on accounts to allow territory management rules to run to assign users to the right territory.
  3. Leverage account teams to solve global account owners to view all child accounts.

I hope this post provides you the guidelines what you are looking for. Feel free to post your comments or email me at for next steps.

Hi there! Thanks for visiting my blog. My name is Buyan Thyagarajan (Buyan47) . I am a Salesforce consultant specializing in higher education and helping businesses to measure business results , be proactive with their customers , prevent problems before hand and make the right decisions using Salesforce CRM. This blog would help you in the following way. a. For Universities, my articles and tips would help you to increase your student recruitment, get better insights on your marketing campaigns and ensure student success by maximizing the features available in your salesforce org, integrate with your student information systems ( Banner, Ancor etc) and create a connected campus on the digital world. b. For Salesforce admins, my articles would help you to be proactive with your salesforce crm, prevent problems and make the right decisions on different problems with salesforce. c. For Business executives, my articles would help to measure business results with your salesforce crm, increase adoption and provide solutions for your business problems. d. For IT executives and developers, my articles would help you on best practices on change management, provide insights on increasing your performance with your current development teams and guide you to make better architectural decisions with salesforce and salesforce1. I am passionate about the following. a. Software is meant to automate work but in reality IT is the most manual industry where programmers have to type those 100,000 lines of code everyday to make things work. Programmers get lost in the code and business folks wonder why the programmers are not getting it. I have some insights on this and in the process of publishing a book which should help in the following. a. Help IT teams to be innovative and offer business value b. Career pathway for programmers c. Relevant things a business user can provide to IT to get things done quick. Please feel free to post your comments on the site on my articles and any questions you have and I would be glad to answer it for you. To reach me Ph: 302-438-4097 m:

Leave a Reply

Your email address will not be published. Required fields are marked *

Get free tips on Salesforce
Get free tips on Salesforce
We respect your privacy.