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

Assigning dimension set ID when creating custom general journal entries

(8) Share

Report

Posted on by AK-13051749-0

142

Is there any out-of-box AL code function we can use to automatically assign the dimension set ID when creating custom general journal entries? I am trying to create custom intercompany general journal entries but having trouble assigning a dimension set ID to the custom entries. I would appreciate it if you can please share some code samples for assigning dimension set IDs for custom general journal entries just the way the system assigns dimension set IDs to system-created general journal entries.

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (6)

Answers (0)

Suggested answer

YUN ZHU 95,331 Super User 2025 Season 2 on at

Like (4)

Report

Hi, hope the following can give you some hints.

Solved: How to set dimensions in C/AL

Modify Dimension Set Entry table through code

Insert 4 dimensions how to improve code — mibuso.com

Thanks.

ZHU

Was this reply helpful? Yes No
Suggested answer

Sohail Ahmed 11,136 Super User 2025 Season 2 on at

Like (2)

Report
To assign a Dimension Set ID to a custom general journal entry or any record like a Sales Order, you need to build a temporary set of dimension entries and then use DimMgt.GetDimensionSetID to generate the correct ID.

var DimVal: Record "Dimension Value"; TempDimSetEntry: Record "Dimension Set Entry" temporary; DimMgt: Codeunit "DimensionManagement"; SalesHeader: Record "Sales Header"; begin // Get the dimension value record DimVal.Get('SALESPERSON', 'SK'); // Build a temporary dimension set entry TempDimSetEntry.Init(); TempDimSetEntry.Validate("Dimension Code", DimVal."Dimension Code"); TempDimSetEntry.Validate("Dimension Value Code", DimVal."Code"); TempDimSetEntry."Dimension Value ID" := DimVal."Dimension Value ID"; TempDimSetEntry.Insert(); // Assign the Dimension Set ID to your record SalesHeader."Dimension Set ID" := DimMgt.GetDimensionSetID(TempDimSetEntry); SalesHeader.Insert();

This is the same method Business Central uses internally, and it ensures proper dimension tracking and posting behavior.

✅ Mark this answer as verified if it helps you.

Was this reply helpful? Yes No
Suggested answer

Mansi Soni 8,907 Super User 2025 Season 2 on at

Like (4)

Report

Hello,

Adding more details:

https://community.dynamics.com/forums/thread/details/?threadid=3156e916-7d62-4638-8949-c66bdbb95a81
https://community.dynamics.com/forums/thread/details/?threadid=c0f908cf-71c4-41d5-8e87-43e7f8ad7f84

Regards,
Mansi Soni

Was this reply helpful? Yes No
Gerardo Rentería Ga... 25,213 Most Valuable Professional on at

Like (2)

Report

Hi, good day
I hope this can help you, and give you some hints.

Solved: GetDimensionSetID on ChangeCompany

Business Central - purchase line - update shortcut/global dimensions — mibuso.com

Best Regards
Gerardo

Was this reply helpful? Yes No
Suggested answer

Jainam M. Kothari 15,631 Super User 2025 Season 2 on at

Like (1)

Report

May this can help : https://learn.microsoft.com/en-us/dynamics365/business-central/design-details-dimension-set-entries-overview

Was this reply helpful? Yes No
Suggested answer

RockwithNav 8,600 Super User 2025 Season 2 on at

Like (1)

Report

This is assigned by default, what are you actually willing to achieve?

Even if you have a custom process of general journal, which dimension set id you want to copy from?

Was this reply helpful? Yes No