I'm unable to find a (NL) table that includes the short-cut dimensions? As an example, the table...‘General Journal Line’ outputs the 2 global dimensions, but no shortcut dimensions. I’m looking for suggestions on the best way to output shortcut dimension data records – transaction level. Thanks!
1 comment
-
Harry Lewis Hello Chris -
From your question, I assume you are working with Dynamics NAV.
You'll probably want to take a look at the Dimension, Default Dimension, and Dimension Value tables.
In legacy versions of NAV:
The Dimension table (as the name suggests) lists all of the Dimensions (both Global and Advanced [aka shortcut]).
The Dimension Value table lists all the possible value each Dimension can contain.
The Default Dimension table (which can get quite large) lists all the Dimensions, their Values, and the other NAV tables to which that particular dimension and value are applied.
I have heard that *NEW* installations of NAV 2013 and higher (not those that have been *upgraded* from legacy versions) handle dimensions differently. You would need to take a look at your tables.