Skip to Content
author's profile photo Former Member
Former Member

How to categorize countries (e.g. Egypt - Africa)

Hello,

We want to categorize country codes by region.

e.g. Korea - Asia, Egypt - Africa

I know that table T005 does not have any fields for this purpose.

So we think all we can do is create a new add-on table.

But the best way is addind field to T005.

Please teach us how to categorize!

Thank you in advance.

Best regard.

Emma S.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

4 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jul 07, 2010 at 11:01 AM

    Hi,

    Unfortunately there are no option for UDFs for Countries. So, you should use given field. The best possible is the "Code for Reports" field. But, it only 3 digit. So you should create another UDT that explain "description" of code in the countries table.

    Create FS in that field referring value in the UDT so that user only choose the correct code.

    Cheers 😊

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 07, 2010 at 02:30 PM

    Hi Emma,

    Have you checked Territory function? You may categorize countries there.

    Thanks,

    Gordon

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Thank you for your information!

      to Yeni Amin

      I agree on you to use given field.

      I'm considering to use Address Layout Key.

      to Gordon

      What's fTerritory function??

      It may be what I'm looking for.

      Would you give me more information, please.

      Emma S.

  • author's profile photo Former Member
    Former Member
    Posted on Aug 19, 2010 at 02:48 PM

    Territory could be set up under Admin - Setup menu. You may create different levels territories to meet your need.

    However, when I read your another thread, I found you may not use SAP Business One. Please confirm. If that is true, please close your thread and post it on a proper forum.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Emma,

      If it is for SBO, please indicate in your next response what it is that you are trying to do - what is the categorizing for. That would help determine what solution may serve you best.

      Heather

  • author's profile photo Former Member
    Former Member
    Posted on Oct 31, 2010 at 01:32 PM

    Hi Emma,

    Please close your thread since your question is not related to SAP Business One

    Thanks,

    Gordon

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.