web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Answered

MASTER card- Display Description from Table 5722

(0) ShareShare
ReportReport
Posted on by 15

Hello.

 Is is there a way to display the item category (not just its code) when I select from table 5722?

In this example, I would like for the card to read "T-shirt (S/S)" instead of  "01"

MASTER-_2D00_-Item-Category-_2800_5722_2900_-Description.JPG

Thank you!

I have the same question (0)
  • Suggested answer
    JAngle Profile Picture
    119 on at
    RE: MASTER card- Display Description from Table 5722

    Will need some small DEV. You can set a variable on the page which is then displayed with the related description value from the item category table. You can set it in the OnOpenPage trigger to fetch the data and then fill the variable.

    This previous post explains it well: community.dynamics.com/.../615422

  • Suggested answer
    Jyotsna NAV Profile Picture
    585 on at
    RE: MASTER card- Display Description from Table 5722

    Hello,

    In this scenario Item Category Code is mapped to 01. I will not recommend passing T-shirt (S/S) in the same field. Create a new field and onValidate() of Item Category Code pass the Description in the newly created field. Hope this helps!

    Regards

    Jyotsna Oberai

    jyotsnanav.blogspot.com

  • eoi-Megan Profile Picture
    15 on at
    RE: MASTER card- Display Description from Table 5722

    thank you! This should do it!

  • eoi-Megan Profile Picture
    15 on at
    RE: MASTER card- Display Description from Table 5722

    thank you.  My boss was asking if there was a way to make it say "t-shirt" since the category number will not mean anything to people who are just viewing the card.

  • Verified answer
    Jyotsna NAV Profile Picture
    585 on at
    RE: MASTER card- Display Description from Table 5722

    You can do a substring, but Description of all the fields will not have the same length. So it is not a feasible solution.

    One thing you can do is let the user search according to Description, for this add Description in Key so that you can search according to it in the dropdown.

    Please mark this answer as verified if it answered your question. Thank you.

    Regards

    Jyotsna Oberai

    jyotsnanav.blogspot.com

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
Rishabh Kanaskar Profile Picture

Rishabh Kanaskar 4,202

#2
Nimsara Jayathilaka. Profile Picture

Nimsara Jayathilaka. 3,248

#3
Sumit Singh Profile Picture

Sumit Singh 2,893

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans