Locale question in an International company context

SOLVED

Hi,

Would like some experienced opinions on using Sage X3 on international scale.

Assume I have a theoretical international company here which have branches in:

Nation - User example

UK (HQ) - Jack

USA - Bob

Singapore - Stuart

Japan - Taku 

China - Lee

Assume the current Sage X3 license has standard locale, language, and legislation of the languages above licensed except Singapore and Japan (no Sage X3 official language license).

Currently, I am stuck in a situation on:

[1] How to forcefully set and use the locale for each users. Like, where in syracuse should I set it?

[2] How to handle for locale's description difference? How to handle locale's date order difference (MM/DD/YYYY vs DD/MM/YYYY)?  Or do I enforce use of a single locale for brevity sake?

[3] What do I do for Singapore and Japan users in terms of locale setup? Do I force them to use en-us (ENG)?

For detailed explanation on [2], for sake of easy explanation (since this issue affects a lot of descriptions), suppose Bob (USA) created a user called Desmond:

When Lee (China) looked at the Desmond user:

When Jack (UK) looked at the Desmond user:

I know that a company user could just click on the triple dots to get the translation but it would be tedious to manually add them in based on current language locale.

Is there a way to fill in the description by default if this locale's translation was empty?

Parents
  • 0

    Take a look at Languages in common data (GESTLA). You can set a backup language for a language code.

    For example AUS has ENG as the backup language, so if a AUS translation is missing, I believe it substitutes it with ENG.

    I've not tried this though.

  • 0 in reply to Nick Ward

    Hi Nick,

    No dice.

    When I tried to click on the Backup language or Tab to the column for English - British (BRI; supported by Sage X3 officially), it will move to Bulgarian Description column.

    Same for Chinese (CHI; supported by Sage X3 officially) Backup language which will move to Chinese traditional Description column instead.

Reply
  • 0 in reply to Nick Ward

    Hi Nick,

    No dice.

    When I tried to click on the Backup language or Tab to the column for English - British (BRI; supported by Sage X3 officially), it will move to Bulgarian Description column.

    Same for Chinese (CHI; supported by Sage X3 officially) Backup language which will move to Chinese traditional Description column instead.

Children
  • 0 in reply to chunheng

    Additionally (Note that this is checked on SEED, in folder generation function, which has AUS language and is default language and country to FRA and FR):

    Do I need to do a VALDOS (Folder Validation) on the folder from X3 to update all the languages and locale?

  • 0 in reply to chunheng

    Hi Chunheng,

    You only need to do a VALDOS if you add a language in folders (I've only added a leg + lang at the same time).

    Unfortunately, it appears that if it's a standard language, you cannot enter a backup language, and modifying another language/backup didn't do anything for me.

    What I have done previously on accounting codes/dimensions where the same problem occurs, is to use an import/export template on ATEXTE (Function AINITEXTRA).
    Export filtering the table, identifier and language, change the language code in the exported file (and translations if required), and import. With this method you can update all users at the same time.

    I can provide screenshots of my import/export template if you don't have it.

  • 0 in reply to Nick Ward

    Hi Nick,

    Sorry for the late reply.

    Please provide the screenshots of the import/export template.

  • 0 in reply to chunheng

    Hi Chunheng,

    Here you go:
    Import/Export template

    The user I want to add translations to:

    SQL

    Export settings

    Create the import datafile and import it.

    Updated user