Global Dimension & Dimension Set ID in G/L Ledger Entry

Nam_hakuna

Hi All,

I have a problem with Global Dimension 1 Code and The dimension set ID in G/L Ledger.

The Entry has a dimension set ID but the Global dimension 1 code is not appear in the entry.

How can I fix this issue? Please suggest.

geordie

Take a look at DimensionManagement codeunit: I think UpdateGlobalDimFromDimSetID function can match your case, it's used also in Sales Line/Purchase Line tables.
Calling it with parameters referring to your record will fix the emptyShortcut Dimension 1 Code, if it's included in the related Dimension Set Entry value, of course.

ara3n

you need a processing codeunit and populate the field

BardurKnudsen

One thing is fixing the issue, but you must also have some error in your code somewhere, since you got into this situation, so I think it is important to identify that error first. And is it really only the G/L Entries then? What about all the other tables that have Global/Shortcut dimension 1?
Assuming that this is an issue in all your tables, I think the simplest and safest solution to fix it is to use the "Change Global Dimensions" function from the "General Ledger Setup" page, as that will go through all tables and update them as necessary.

ara3n

I had suggested MS to add a check in CU 11 to check that Dimension Set Entry values are the same as shortcut for the journal because so many people make the mistake and not populating the global 1 and 2 on journal line but nothing has happened.

mdPartnerNL

ara3n wrote:

I had suggested MS to add a check in CU 11 to check that Dimension Set Entry values are the same as shortcut for the journal because so many people make the mistake and not populating the global 1 and 2 on journal line but nothing has happened.

From a user or developer standpoint?

ara3n

developer