Skip to main content

Notifications

Small and medium business | Business Central, N...
Suggested answer

Help with filter, unknown error

Posted on by 20

Inventory-Report.png

I am trying to sort my report so that all the items in that parent category will show up

Here is my current code:

tableextension 50103 MyExtension extends Item
{
    fields
    {
        // Add changes to table fields here
        field(50104; MPN; Text[50])
        {
            DataClassification = ToBeClassified;
        }
        field(50105; Model; Text[50])
        {
            DataClassification = ToBeClassified;
        }
        field(50106; LegacyId; Text[50])
        {
            DataClassification = ToBeClassified;
        }
        field(50108; Recycle; Boolean)
        {
            DataClassification = ToBeClassified;
        }
        field(50109; ParentCode; Text[50])
        {
            DataClassification = ToBeClassified;
            TableRelation = "Item Category"."Parent Category";
        }
        field(50110; "Parent Category"; Code[20])
        {
            DataClassification = ToBeClassified;
            TableRelation = "Item Category"."Parent Category";
        }
    }

    var
        myInt: Integer;

  • Suggested answer
    NAV_with_Narang Profile Picture
    NAV_with_Narang 2,234 Super User 2024 Season 1 on at
    RE: Help with filter, unknown error

    Hi There - I see from the code that you have extended the table, have you modified the report accordingly?

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!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 229,963 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans