169
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
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
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!
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
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.
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
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.
The following page extension should fix that for you.
Share
Report
All responses (
Answers (
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;
}
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
290,564
Super User 2024 Season 2
#2
Martin Dráb
228,651
Most Valuable Professional
#3
nmaenpaa
101,148