Skip to main content

Notifications

Small and medium business | Business Central, N...
Answered

Dimension value Lists not populated in a dropdown page

(1) ShareShare
ReportReport
Posted on by 17

Entering a journal entry (general journal). the global dimension will not populate. The value list is blank. However the dept value (920) is assigned to the account number. Using a new batch name - not default.

Error Message: The field Dept. Code of table Gen. Journal Line contains a value (920) that cannot be found in the related table (Dimension Value).

The dept value is assigned to the account but drop down list is blank on the jrnl entry.

I'm sure its a setup issue but I can't figure out what I'm missing. I've checked configuration with another company that appears to be working just fine. We're still in setup/test mode.

  • Verified answer
    JA-09011517-0 Profile Picture
    JA-09011517-0 17 on at
    Dimension value Lists not populated in a dropdown page
    Think it's solved since it's working now..  
    1. in my company setup I had only one Global Dimension (dept) setup. The second global dimension was blank.  I was getting the blank on Jnl entry error message. 
     
    2. Added a second global dimension (xyz) that we will never use for this company.  The list now appears as expected in the journal entry. 
     
    Per our consultant - this came from the wayback machine.  Thanks for your help. 
    Jenny 
     
     
  • JA-09011517-0 Profile Picture
    JA-09011517-0 17 on at
    Dimension value Lists not populated in a dropdown page
    Global Dimension Dept - 
    Dimension Value 920 is there.  
    On the general journal page, in the DEPT. dimension - the list comes up in error for all rows.  I've assigned the 920 to the Account number for it to default and it still does not appear and gives me the message the the table is blank.  
     
  • Suggested answer
    Valentin Castravet Profile Picture
    Valentin Castravet 25,785 Super User 2025 Season 1 on at
    Dimension value Lists not populated in a dropdown page
    If you go to the Dimensions page, select your dimension and click on Dimension Values, do you see 920 in there? It seems like its missing from there. 
     
  • Martin Dráb Profile Picture
    Martin Dráb 230,900 Most Valuable Professional on at
    Dimension value Lists not populated in a dropdown page
    Moved from Integration, Dataverse, and general topics forum.
  • JA-09011517-0 Profile Picture
    JA-09011517-0 17 on at
    Dimension value Lists not populated in a dropdown page
    Yes - its the Dynamics Bus Central 365 - the application is the General Ledger (journal entry). 
  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 292,074 Super User 2025 Season 1 on at
    Dimension value Lists not populated in a dropdown page
    Hi,
     
    The table name indicates this might be related to Dynamics 365 Business Central. Can you confirm that please? We can then move the question to the correct forum, so a volunteer will be able to help you.
  • Martin Dráb Profile Picture
    Martin Dráb 230,900 Most Valuable Professional on at
    Dimension value Lists not populated in a dropdown page
    D365 consists of many applications, such as Finance and Operations (former Dynamics AX) or Business Central (former Dynamics NAV). Which one do you have in mind?

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

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Congratulations to the January Top 10 leaders!

Check out the January community rock stars...

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,074 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,900 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans