Answered

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

(0) Share

Report

Posted on by Community Member

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

I have the same question (0)

All responses (6)

Answers (2)

Suggested answer

Teddy Herryanto (Th... 14,253 Super User 2025 Season 2 on at

Like (2)

Report

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.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
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

Was this reply helpful? Yes No
Verified answer

Teddy Herryanto (Th... 14,253 Super User 2025 Season 2 on at

Like (1)

Report

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.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Verified answer

Teddy Herryanto (Th... 14,253 Super User 2025 Season 2 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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.

Was this reply helpful? Yes No