Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / Limiting dimension val...
Microsoft Dynamics NAV (Archived)

Limiting dimension values allowed with 1 G/L account

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

I have  a client running NAV 2015.  They have one dimension "Dept".  It is the Global 1 dimension and a short cut dimension.  They have set the  Account Type default to all tables "0" and "Code Mandatory".  Now they want to limit what department values can be entered when using G/L account number 5010.  When I go into G/L account number 5010, it won't let me add the department numbers they want (ie 20220..20280 department codes only).  NAV keeps telling me that there is already a default set up and refers back to the Account type default.  How do I fix this so Department codes are mandatory on all tables but G/L account 5010 can only have 20220..20290?

Thanks in advance

*This post is locked for comments

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Limiting dimension values allowed with 1 G/L account

    they don't have to be global dimensions

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Limiting dimension values allowed with 1 G/L account

    And all of the dimensions would be Global dimensions?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Limiting dimension values allowed with 1 G/L account

    Dimension combinations let you limit what departments and locations can be used together.  Depending on what version you’re using, it can be found here:

    Here is an article explaining it:

    https://msdn.microsoft.com/en-us/library/hh168803%28v=nav.70%29.aspx?f=255&MSPPError=-2147217396

    You would keep your dimensions the way they are.

    You can make a new Short Cut dimension and have it mimic the GL account numbers.  Then you could use the dimension combinations to limit them.

    Here is an article on creating new dimensions:

    https://msdn.microsoft.com/en-us/library/hh167374(v=nav.70).aspx#Setting_Up_Dimensions

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Limiting dimension values allowed with 1 G/L account

    Could you expound on dimension combinations?

    With 70 departments and 20 locations, are you saying 0101 0102 0103...0201 0202 0203......2001 2002 2003...2069 2070? Create dimensions like that? 1,400 dimensions?

     

    We have to have Location AND Department as Global dimensions, or are you suggesting we take that down to one combination dimension? I could see how it would work in most cases but getting reports out, by either Location, or by Department, might be a challenge, especially given our Partner...

     

    And wouldn't you still have an issue restricting a GL account to a specific dimension?

     

    Don't understand your idea of dimensionalizing the GL account number?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Limiting dimension values allowed with 1 G/L account

    I have found that you can set up dimension combinations and limit them that way.  One other option is to set up your GL accounts as a dimension and then use the dimension combinations.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Limiting dimension values allowed with 1 G/L account

    We have purchase accounts for inventory.

    Due to licensing issues, only certain locations can buy/sell liquor.

    We'd like to be able to restrict accounts by a combination of Location and Department (both Global Dimensions).

    So, for location 6 for example, which doesn't have a liquor license, we'd like to restrict use of account 2 (purchases) to departments other than the liquor department dimension i.e. no department 9 (liquor) purchases (account 2) allowed for location 6.  But for location 9, which does have a liquor license, purchases of liquor should be allowed.

     

    We have multiple labor wage accounts that also should be limited in the departments available to use in combination with them.  Repair accounts...

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Limiting dimension values allowed with 1 G/L account

    I can do this.  What I can't do is set the filter to only allow some Dept codes.

  • TharangaC Profile Picture
    TharangaC 23,116 on at
    RE: Limiting dimension values allowed with 1 G/L account

    Check this blog : www.dynamics101.com/.../setup-required-dimension-multiple-gl-accounts-nav-2013

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Limiting dimension values allowed with 1 G/L account

    No, I don't need to add new dimensions.  I have a GL account number (5010)that should only be allowed to have Dept(dimension) 20220..20290 when posting to this GL account.  The problem is that when I try to limit what dimensions are allowed I get this message:

    If I go to the Account Type Default Dim. it shows this:

    How do I properly set up account 5010 so it will only allow depts. 20220..20290?

    Thanks,

    J.Elliott

  • keoma Profile Picture
    keoma 32,675 on at
    RE: Limiting dimension values allowed with 1 G/L account

    i assume you mean using g/l account type in sales lines.

    to add new dimension values, type "dimensions" in the search box of the RTC client and open the page "dimensions". there select the department dimension and click on action button "dimension values". add then the needed dimension values.

    after that you can use the new dimension values in the g/l accounts and sales lines.

    to filter the allowed dimension values for g/laccount 5010 change the onvalidate trigger of the no. field in the sales line.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans