Skip to main content

Notifications

Microsoft Dynamics NAV (Archived)
Answered

Show shortcut dimensions in Customer (Page-Customer List 22)

Posted on by Microsoft Employee

I have managed to add the dimension shortcut fields to Customer List. Basically i copied the functionality from the page "Item Journal (40)" and table "Item Journal Line (83)" to page "Customer List (22)" and table "Customer (18)".

On the Page itself, the shortcuts get displayed with these function (according to page 40):

OnAfterGetRecord()
ShowShortcutDimCode(ShortcutDimCode);

OnNewRecord(BelowxRec : Boolean)
CLEAR(ShortcutDimCode);

Item No. - OnValidate()
ShowShortcutDimCode(ShortcutDimCode);


I copied the  ShowShortcutDimCode from 83 to 18. It calls GetShortcutDimensions from DimMgt and "Dimension Set ID" parameter is passed.

The problem is that i there is no Dimension Set ID field in the Customer table (18).

How do i get Dimension Set ID to pass it to the funtion and is this what i should be after?

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Show shortcut dimensions in Customer (Page-Customer List 22)

    Hello to both of you,

    First sorry for my ENglish i'll try my best to be understandable :)

    I'm a quite new developer on NAV, i'm a work-study student.

    The thing is that i have to do exactly the same task as you "Show shortcut dimensions in Customer (Page-Customer List 22)"

    I've tried to follow your solutions but it is not working .. :/

    I've probably made a mistake beacause your solution is splitted into multiples messages, i've certainly miss-understand something ..

    Can you one you re-explain to me how to do it ?

    Thanks already for what you've done.

  • Verified answer
    TeddyH Profile Picture
    TeddyH 12,868 Super User 2024 Season 1 on at
    RE: Show shortcut dimensions in Customer (Page-Customer List 22)

    Get the dimension value for the variables in OnAfterGetRecord() function on the page, and assign the variable on the SourceExpr of the column.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Show shortcut dimensions in Customer (Page-Customer List 22)

    Hello Ted,

    This works and thank you for that. But how will that help me with my goal of showing shortcut dimensions in the customer list like in the photo? I need those fields to be filled by the dimensions that are selected.

    Shortcut-Dimensions.png

  • Verified answer
    TeddyH Profile Picture
    TeddyH 12,868 Super User 2024 Season 1 on at
    RE: Show shortcut dimensions in Customer (Page-Customer List 22)

    Yes, create a variable to record Default Dimension and filter the Table ID to 18 (Customer table) and filter No. to Customer code.

    You will get all the default dimensions for that customer record.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Show shortcut dimensions in Customer (Page-Customer List 22)

    Thank you for your reply! Could you please assist me on how to go about doing that? Do you mean i create a variable of type Default Dimension? And what from there? Also, there are only the following fields in the Default Dimension table:

    • Table ID | Integer
    • No. | Code 20
    • Dimension Code | Code 20
    • Dimension Value Code | Code 20
    • Value Posting | Option
    • Table Caption | Text 250
    • Multi Selection Action | Option
  • Suggested answer
    TeddyH Profile Picture
    TeddyH 12,868 Super User 2024 Season 1 on at
    RE: Show shortcut dimensions in Customer (Page-Customer List 22)

    There is no Dimension Set ID in customer table. The ID is only on transactions.

    Make a link to Default Dimension table. The dimensions are there.

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!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,149 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans