Territory

Last post 05-21-2008 12:41 AM by mwiley. 1 replies.
Page 1 of 1 (2 items)
Sort Posts: Previous Next
  • 05-13-2008 3:25 AM

    • Vaani
    • Top 500 Contributor
    • Joined on 05-09-2008
    • Posts 1

    Territory

    Hi,

    I need to create sub territories within a territory. My requirement is that need to create a territory say USA  and within that two sub territories say North US and South US.

    I tried in customizations ended up without any solution. Please do guide me in achieving this.

    Thanks in Advance,

    Vaani  

     

  • 05-21-2008 12:41 AM In reply to

    • mwiley
    • Top 25 Contributor
    • Joined on 01-24-2008
    • Ohio
    • Posts 14

    Re: Territory

    Are you using the salesperson fields? If not, they could be your sub-territories.

    If you are, then I would suggest using the first 3-4 characters (consistantly), as your main territory, then using an additional number of characters for the sub. Then use string functions in report writer and other tools to get the reports you need.

     For example: USA0000 as your main territory, and USA0001 thru USA9999 as your sub territories.

    In reporting for all main territories, the report could look for USA* or Left([Territory],3) to allow you to combnine all of the subs. You can also parse the field and treat it as if it were two fields as long as you are consistant in the number of digits, or use a common delimiter (like a dash).

     

Page 1 of 1 (2 items)