Shortcut Dimensions

jhanvincent14

Hello, Good day.

Im a newbie here in terms of dimensions, does anyone knows how to filter shortcut dimensions in General Journal Line (Table 81)? I check the table and only global dimensions (1 and 2) and shortcut dimensions (1 and 2) are present in the table but I need to filter shortcut dimension 3 and 4. can somebody help me with this ? or any link of information that I can read to proceed?

Slawek_Guzek

The screenshot shows Businessgroup Code dimension in General Journal, but the Dimension Set Entry shown below is filtered for BUSINESSUNIT dimension code. Are there those two same dimension (code and caption of the same dimension code)?

Run the table 480 Dimension Set Entry, filter in there for required dimension code / dimension value code pair. You will get a list of all dimension set ids which needs to be in your filter.

This is your goal - filter all journal lines for any dimension set id which includes your dimension code/value pairs.

rfajdiga

Hi,

if you want to filter table 81 by shortcut dimension I think you need to use Dimension Set ID field and then go to table Dimension Set Entry and filter Dimension Set ID based on Dimension Set ID from table 81.

Example, on my general journal I have dimension set ID 156.

jhanvincent14

rfajdiga wrote: »

Hi,

if you want to filter table 81 by shortcut dimension I think you need to use Dimension Set ID field and then go to table Dimension Set Entry and filter Dimension Set ID based on Dimension Set ID from table 81.

Example, on my general journal I have dimension set ID 156.

@rfajdiga thank you for your reply, well appreciated. you have a list of 156 in Dimension Set Entry, I need to filter specific line from general ledger entry using shortcut dimension 5 (lets say BUSINESSGROUP), how will I do that ?

Slawek_Guzek

You need to build a filter including all Dimension Set IDs which include your BUSINESSGROUP dimension, and then use that filter against the Dimension Set ID field in General Journal Line table.

You don't have to to start from scratch, look into C408 DimensionManagement, there is a function GetNextDimSetFilterChunk doing just this. It works in conjunction with another function GetDimSetIDsForFilter in C408 which must be called before using GetNextDimSetFilterChunk - look into Table 1112 Cost Center to see how they have been used together in standard NAV

jhanvincent14

Slawek_Guzek wrote: »

You need to build a filter including all Dimension Set IDs which include your BUSINESSGROUP dimension, and then use that filter against the Dimension Set ID field in General Journal Line table.

You don't have to to start from scratch, look into C408 DimensionManagement, there is a function GetNextDimSetFilterChunk doing just this. It works in conjunction with another function GetDimSetIDsForFilter in C408 which must be called before using GetNextDimSetFilterChunk - look into Table 1112 Cost Center to see how they have been used together in standard NAV

Hello @Slawek_Guzek thank you for the idea, I tried it but somethings weird, Dimension Value Code in Dimension Set Entry is INDUSTRIAL but in my General Journal (Businessgroup Code) is HOME. Dimension Value Code is supposed to be HOME, right ? and not INDUSTRIAL. by the way, Shortcut dimension
5 declared in General Ledger setup is BUSINESSUNIT and has a description of Businessgroup, (see attached photo
)

Slawek_Guzek

The screenshot shows Businessgroup Code dimension in General Journal, but the Dimension Set Entry shown below is filtered for BUSINESSUNIT dimension code. Are there those two same dimension (code and caption of the same dimension code)?

Run the table 480 Dimension Set Entry, filter in there for required dimension code / dimension value code pair. You will get a list of all dimension set ids which needs to be in your filter.

This is your goal - filter all journal lines for any dimension set id which includes your dimension code/value pairs.