web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics AX (Archived)

Company code is lowercase?

(0) ShareShare
ReportReport
Posted on by 2,459

hi

Whenever I import a new user into AX (from Active Directory) the company code imports as lowercase. However, the company code in the legal entities setup, is uppercase..

Any ideas?

2017_2D00_03_2D00_28_5F00_0821.png

2017_2D00_03_2D00_28_5F00_0833.png

*This post is locked for comments

I have the same question (0)
  • SU-22040800-0 Profile Picture
    2,459 on at

    any ideas?

  • André Arnaud de Calavon Profile Picture
    301,018 Super User 2025 Season 2 on at

    Hi James,

    Can you tell what happens if another user imports new users? Is the behavior the same? Did you type the value manually or was it copied from your user settings? Can you review your startup company if this is lowercase? Because usually it is copying the options from the user which creates the user.

  • SU-22040800-0 Profile Picture
    2,459 on at

    Thanks for the reply Andre

    I set my company code in File>Tools>Options to uppercase, and then deleted, and reimported the user (where I did not type the company code in manually, I let it derive automatically). The company code then still derives as lowercase.

    I checked the setup in Legal Entities, and all is uppercase there too..

  • André Arnaud de Calavon Profile Picture
    301,018 Super User 2025 Season 2 on at

    Hi James,

    As you did mention you set the company code to uppercase in your profile, does this mean it contained the lowercase characters before? In that case, caching might cause it. Restart the client and/or AOS will clear the cache.

    If you didn't change your user options setting, I misunderstood your previous reply.

  • SU-22040800-0 Profile Picture
    2,459 on at

    Thanks Andre

    the company code in my user setup was already in uppercase.. I even restarted the AOS to test :(.

  • SU-22040800-0 Profile Picture
    2,459 on at

    Hi Andre

    I ran a search on all the tables in the DB, looking for the company code. Then extracted it into excel, filter for the ones with lowercase... The below are tables that I 'think' might be the cause (not 100% sure)..  I'm also not sure what screen they come from.. Do any ring a bell?

    [dbo].[LEDGERALLOCATEKEY].[DATAAREAID]

    [dbo].[LEDGERBALCOLUMNSDIM].[DATAAREAID]

    [dbo].[LEDGERJOURNALPARMPOST].[DATAAREAID]

    [dbo].[LEDGERPARAMETERS].[DATAAREAID]

    [dbo].[LEDGERPERIODCODE].[DATAAREAID]

    [dbo].[LEDGERROWDEF].[DATAAREAID]

    [dbo].[LEDGERROWDEFLINE].[DATAAREAID]

    [dbo].[LEDGERSYSTEMACCOUNTS].[DATAAREAID]

    [dbo].[LEDGERTRANSVOUCHERLINK].[DATAAREAID]

    [dbo].[LOGISTICSLOCATIONEXT].[DATAAREAID]

    [dbo].[NUMBERSEQUENCESCOPE].[DATAAREA]

    [dbo].[RDEFERRALSPARAMETERS].[DATAAREAID]

    [dbo].[SRSTMPDATASTORE].[DATAAREAID]

    [dbo].[SYSEMAILPOPCLIENTCONSTRAINTS].[DATAAREAID]

    [dbo].[SYSEMAILPOPCLIENTFORBIDDENEXTENSION].[DATAAREAID]

    [dbo].[SYSTRACETABLESQL].[DATAAREAID]

    [dbo].[SYSLASTVALUE].[COMPANY]

    [dbo].[SYSSETUPCOMPANYLOG].[COMPANY]

    [dbo].[SYSTRACETABLESQLTABREF].[DATAAREAID]

    [dbo].[TMSPARAMETERS].[DATAAREAID]

    [dbo].[TRANSACTIONLOG].[DATAAREAID]

    [dbo].[XREFDIALOGUPDATE].[DATAAREAID]

    [dbo].[AXDDOCUMENTPARAMETERS].[DATAAREAID]

    [dbo].[CATUSERREVIEWSETTINGS].[DATAAREAID]

    [dbo].[COMPANYDEFAULTLOCATION].[DATAAREAID]

    [dbo].[CONFIRMINGPO].[DATAAREAID]

    [dbo].[COSPARAMETERS].[DATAAREAID]

    [dbo].[DIRPARTYRELATIONSHIP].[LEGALENTITYDATAAREAID]

  • SU-22040800-0 Profile Picture
    2,459 on at

    Hi Crispin

    Thanks for the testing your side. I did the same with my DAT company, and the company went through as lowercase (dat) as well :(

    Not sure why AX would do this..?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Priya_K Profile Picture

Priya_K 4

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#3
Ali Zaidi Profile Picture

Ali Zaidi 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans