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

Nam_hakuna
Nam_hakuna Member Posts: 2
edited 2014-01-13 in NAV Three Tier
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.

Comments

  • geordie
    geordie Member Posts: 655
    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.
    * Daniele Rebussi * | * Rebu NAV Diary *
  • ara3n
    ara3n Member Posts: 9,258
    you need a processing codeunit and populate the field
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • BardurKnudsen
    BardurKnudsen Member, Microsoft Employee Posts: 137
    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.
    Bardur Knudsen
    Microsoft - Dynamics NAV
  • ara3n
    ara3n Member Posts: 9,258
    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.
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • mdPartnerNL
    mdPartnerNL Member Posts: 802
    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
    ara3n Member Posts: 9,258
    developer
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n

Categories