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.

Please Subscribe

Subscribe to our mailing list to get tips on maximizing your salesforce

We respect your privacy.

Please subscribe

Subscribe to our mailing list and get tips to maximize salesforce to your email inbox.

I am honored to have your subscription. Stay tuned for tips to maximize your salesforce investment

Something went wrong.


Author: buyan47

Hi there! My name is Buyan Thyagarajan. I am a Salesforce consultant specializing in Higher Education, Manufacturing and Marketing Automation. My blogs will help you to maximize your Salesforce CRM investments, prevent problems beforehand and make the right decisions. If you need to talk to me right away, you can email me at or call me at 302-438-4097

Leave a Reply

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