BC Friday Tips #51 Dimension No. in Dimension Value
The Dimension Value table contains a hidden Global Dimension No. field that reveals which shortcut dimension a dimension code belongs to, avoiding the need to check General Ledger Setup and improving lookup performance.
Read it hereOpen in Claudehttps-thatnavguy-com-blog-2025-bc-friday-tips-51-dimension-no-in-dimension-value--f3607da2e9.md
post That NAV Guy
"the Dimension Value table has a hidden field called Global Dimension No."
Key points
- Business Central supports 8 shortcut dimensions configured in General Ledger Setup
- Dimension Value table has a hidden Global Dimension No. field
- Using this field avoids checking General Ledger Setup separately
- Improves performance for dimension lookups
Quotes
- “the Dimension Value table has a hidden field called Global Dimension No.” (Reveals the existence of an undocumented field that enables faster dimension identification)
- “use this hidden field to find the dimension number instantly” (Explains the practical benefit of using this field instead of manual lookups)
AL objects mentioned
As named in the post. A name that matches one object page by exact type and name links to it; the others stay as named.
Context
- Features: shortcut dimensions, dimension lookup, hidden fields
Source: That NAV Guy, community blog. Summary, key points and quotes are derived (CONTENT-NOTICE.md); read the original for the full text.