x Want to participate? Join the group to interact
  • State Verified Answer
  • Replies 8 replies
  • Subscribers 135 subscribers
  • Views 7296 views
  • Users 0 members are here
Browse Forums
Announcements
268
topics
260
replies
Databases and Operating Systems
755
topics
2k
replies
Financials Suite
1k
topics
3k
replies
General Discussion
2k
topics
10k
replies
Operational Suite
851
topics
2k
replies
Reporting and Analytics
1k
topics
3k
replies
Reports, Macros, and Customizations
876
topics
3k
replies
Sage CRM for Sage 300
182
topics
408
replies
Paul C

Web screens date format

SOLVED
Posted By

Just been testing the web screens with Sage 300 2018 PU2.  The dates are all displayed in US (mm/dd/yyyy) format.  I need to get the dates to display in dd/mm/yyyy format.

I tried the browser language settings described in Stephen Smith's blog https://smist08.wordpress.com/2015/09/26/international-support-in-sage-300c but it makes no difference - the browser default language is en-GB; I tried en-AU in IE11 and Chrome but it made no difference.

Does anyone know how to set the Sage 300 C date format?

Thanks, paul

  • 0

    What language code is the user in Sage set to use?  What is the server's date format?

  • 0 in reply to Django

    Sage 300 user language code = English.

    Server language = English (United Kingdom), date format = dd/MM/yyyy.

  • +1
    verified answer

    Hey Paul,

    Prior to Sage 300 2018, the "driver" for the language/locale in the Web Screens browser was the Language set in the browser as per Stephen Smith's blog (i.e. Tool--> Languages --> Select a language --> the top most language is what the Web Screens will respect).

    But, there was also a disconnect if for example es (Spanish) was chosen in the browser and the Sage 300 user was set to ENG (English). This would manifest in the web screens being in English, but certain message coming from the server would be in English.

    So, we made the "driver" be the Sage 300 user starting with Sage 300 2018. When you go into the User screen in the desktop, notice that the language to be assigned to the user now also accepts the locale. These defaults are maintained in the aw4.ini filein the runtime folder. 

    So, by selecting the appropriate language/locale, the web screens will be displayed in the language selected and adhering to the locale selected.

    John

  • 0 in reply to John Thomas

    hi John

    Works perfectly, thanks!

    I added en-GB to the comma separated list of locale codes in A4W.ini which has allowed me to choose "English (United Kingdom)" in the user maintenance screen.  It seems to work OK and the date format is correct in the web screens.  Is this supported or might it cause issues?

    thanks

  • 0 in reply to Paul C

    This is supported and what it is there for. Also, these locales are only recognized by the web screens as the locale settings for the desktop are different. 

    Additionally, Sage 300 supports 5 languages (ENG, ESN, FRA, CHN and CHT). So, while you selected English with a different locale, if you would have added a language that we do not support, the web screens would have defaulted to English as that is the default language. I hope this makes sense.

    John

  • 0 in reply to John Thomas

    Excellent, thanks!

  • FormerMember
    0 FormerMember

    Hi,

    I have solved with simple solution. No need to do anything. just go to Sage 300 User creation Screen, select the user and in the Language select English (Australia) the date format will change in the webscreens to DD/MM/YYYY. just close the webscreens and open again. this should work as i have done it for my customers.

  • 0 in reply to John Thomas

    Worked for me! Been fighting this for a while

*Community Hub is the new name for Sage City