Add Item Category Code Description to Item List Page

(0) Share

Report

Posted on by Lovisa LH

Dear colleagues

I would like to add Item Category Code Description as a column in the Item List Page, so that Sales People can search by the name of the Item Category

I had success in doing this kind of task recently with Zhu Yun's advice here

However, I could not use this method to add Item Category Code Description

Any help on how to do it?

Thank you,

Louise

I have the same question (0)

All responses (10)

Answers (1)

Suggested answer

Inge M. Bruvik 1,105 Moderator on at

Like (1)

Report
The following page extension should fix that for you.

pageextension 50103 ItemListExt extends "Item List" { layout { addlast(Control1) { field(ItemCategoryName; ItemCategoryName) { Caption = ' Item Category Description'; ApplicationArea = all; } } } trigger OnAfterGetRecord() var ItemCategory: record "Item Category"; begin If ItemCategory.Get(rec."Item Category Code") then ItemCategoryName := ItemCategory.Description else ItemCategoryName := ''; end; var ItemCategoryName: Text; }

Was this reply helpful? Yes No
Ts. Kit Wong 60 on at

Like (1)

Report

Hi, you may use Inge method to add Item Category Code Description.

Or you may add a new flowfield on Item table to get the Item Category Code Description if you have developer license.

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 95,329 Super User 2025 Season 2 on at

Like (1)

Report

Hi, I think the link below can give you some hints, and here I provide four simple solutions. (The practice of NAV is similar to the BC.)

More details: https://yzhums.com/22220/

1.

2.

3.

4.

Hope this helps.

Thanks.

ZHU

Was this reply helpful? Yes No
Suggested answer

Inge M. Bruvik 1,105 Moderator on at

Like (1)

Report

[quote user="Ts. Kit Wong"]
Hi, you may use Inge method to add Item Category Code Description.

Or you may add a new flowfield on Item table to get the Item Category Code Description if you have developer license.
[/quote]

If you do it in AL you do not need a special dev license for that.

The reason i often prefer not to use a flow field is that it can sometimes slow performance and increase the database space used. Especially in large tables that are often modified.

And here we always use the primary key of the Item category table to find the description so the SQL operations for that will be very efficient and only be performed every time you display the list and now for every modification you do to your item table.

Was this reply helpful? Yes No
Suggested answer

Amit Baru 3,037 on at

Like (1)

Report

Hi,

Pls create one Purch. Inv. Line table and make it nature is flowfield and make connection with Item Category Table

Was this reply helpful? Yes No
Suggested answer

Lovisa LH 29 on at

Like (0)

Report

Dear Inge, Kit, Zhu and Amit

Thank you for your suggestions.

Since the categories were few, quite self explanatory and not long, (ie 01: Boxes, 02: Bottles), and 20 characters are allowed for Item Category Code, I decided to change the Item Category Code from numerical to alpha.

So now the Item Cat Code is meaningful for the sales people and I did not need to add flowfields or page extensions, (although these are things that I want to learn how to do soon)

If anyone with more experience sees an issue with this method down the road, please do say so!

Thank you all once again

Louise

Was this reply helpful? Yes No
Suggested answer

Inge M. Bruvik 1,105 Moderator on at

Like (1)

Report

Hi Lovisa LH

To me it sounds like you chose a great approach based on your data.

The Item Category field is a code field handling both alpha and numeric values so you should be all good with that approach.

Just be aware that if you mix numeric values and numeric values in a code field you can get some odd sorting because the numbers will be sorted in alphabetical order and not in numerical order.

And i do not think Microsoft will change the data type for that field so i do not see any problems here.

Keep up to good work!

Was this reply helpful? Yes No
Verified answer

YUN ZHU 95,329 Super User 2025 Season 2 on at

Like (0)

Report

Hi, I don't see a problem with this, many setting data in the system use abbreviations, but please note that the length will be limited.

For example,

Hope this helps as well.

Thanks.

ZHU

Was this reply helpful? Yes No
Lovisa LH 29 on at

Like (0)

Report

Thank you Inge for you continued helpful feedback!

Was this reply helpful? Yes No
Lovisa LH 29 on at

Like (0)

Report

Thank you Zhu for your helpful and thoughtful advice!

Was this reply helpful? Yes No