Skip to main content

Notifications

Small and medium business | Business Central, N...
Answered

MASTER card- Display Description from Table 5722

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!

  • Verified answer
    Jyotsna NAV Profile Picture
    Jyotsna NAV 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

  • eoi-Megan Profile Picture
    eoi-Megan 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.

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

    thank you! This should do it!

  • Suggested answer
    Jyotsna NAV Profile Picture
    Jyotsna NAV 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

  • Suggested answer
    JAngle Profile Picture
    JAngle 33,159 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

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!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans