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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

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

Item category Codes parent vs child Reporting

(4) ShareShare
ReportReport
Posted on by 292

Hi Folks,

Is there a report in the system that shows all the child items when a parent item category code is selected?

I'm aware an AL customisation can solve this, but does anyone know of a standard Power BI dashboard or report that does this as well before going down this path?

Any advise would be appreciated.

  • Suggested answer
    OussamaSabbouh Profile Picture
    20,940 Super User 2026 Season 2 on at

    Hello,
    There isn’t a standard BC report that automatically expands a selected parent Item Category and lists all items from every child category. However, the standard Power BI Sales app does include an Item Category Code Hierarchy based on the Parent Category, so for sales reporting you can drill/filter through parent and child categories without AL customization. The standard Inventory and Purchases Power BI semantic models expose Item Category, but Microsoft’s documented models don’t include that same hierarchy field. So if your requirement is simply “select parent category and return all descendant items,” a small AL/custom Power BI solution is still the cleanest option.
    Regards,
    Oussama Sabbouh

  • Suggested answer
    Yash_Mistry Profile Picture
    648 Super User 2026 Season 2 on at

    Hello @AmitK-BHub,

    Could you explain exactly what you want like if you just want to see all the child items maybe you can filter the record or just want a report you can use Open in Excel Option as you can see in Below image:


    if you find answer helpful mark it as Verified.

    Thanks 
    Yash Mistry

  • Suggested answer
    Ahmad Subhani Profile Picture
    878 on at

    Hi,

    Business Central has no standard report that takes a parent Item Category and automatically includes all of its child categories. Before going for Customization, if you have a requirement to see some values like total purchase, etc. against category than I think so the standard option that is worth trying is using the Analysis Mode on Item Ledger Entries. You can see use 2 tables connectivity option on that.

    Item Ledger Entries and Item Category.
    From that I think so you can get good financial on Reports. If not or you have any specific Parent Child Relation related Report than you have to go for Customization.

    Best Regards,

    Ahmad Subhani

    www.linkedin.com/in/ahmad-subhani-9b5602216

  • Suggested answer
    Grigorios Mavrogeorgis Profile Picture
    3,940 Super User 2026 Season 2 on at

    Hi, as far as I know there’s no standard report that walks the category tree down to the items for you. The Item Category Code filter on the item list matches only the exact code, it doesn’t pull in the children. Quick workaround without any code, filter the Item List with a pipe, like ACCES|ACCES-01|01-TAPE|02-SEAL|03-CABLE, and save it as a view. On the Item Categories page you can also filter on Parent Category to see which codes sit under ACCES-01. For Power BI I’m not sure if the standard Inventory app shows the category hierarchy, I would check it before building anything. The pipe filter gets messy if the tree grows deep or changes often, then a small AL report is cleaner.

    Glad to help - follow up if anything is unclear.   

    ►  If this solved it, marking it verified helps others too.       

    Regards,
    Grigorios Mavrogeorgis
    Business Central Consultant & AL Developer

    Work: Gmsoft Limited
    Blog:  insidebusinesscentral
    LinkedIn: linkedin.com/in/gregorymavrogeorgis

  • Suggested answer
    YUN ZHU Profile Picture
    104,157 Super User 2026 Season 2 on at

    As other experts have mentioned, this does not appear to be a standard BC feature. Please reach out to the partner who developed this customization.

    Please note, however, that pages with this layout will not display a tree structure in 'Open in Excel' either, as shown in the standard page below.

     

    Thanks.

    ZHU

  • HassanNazeer Profile Picture
    228 on at

    There is still no standard BC report that takes a parent Item Category Code and expands every descendant category onto items. The Item List filter matches the exact Item Category Code only.

    What you do get out of the box for reporting:

    • In the Power BI Sales app semantic model, the Item Category dimension includes Item Category Code Hierarchy, built from the Parent Category links. Use that hierarchy on Sales by Item (and related Sales app reports) to drill or filter parent → children without AL.
    • The Inventory / Purchases Power BI apps expose Item Category, but Microsoft's documented Sales model is the one that calls out the hierarchy field explicitly.

    Quick BC-only checks without code:

    1. On Item Categories, filter Parent Category = your parent to see the child codes.
    2. On the Item List, multi-select those codes in the filter (pipe-separated) and save a view — fine for a shallow, stable tree; painful if the hierarchy changes often.

    If you need "pick one parent → all descendant items" inside BC (print/Excel), a small Query or report that walks Item Category by Parent Category and joins to Item is the clean path. Analysis Mode on Item Ledger Entries helps for amounts by category, but it still won't expand a parent to all children by itself.

    https://learn.microsoft.com/en-us/dynamics365/business-central/sales-powerbi-app-semantic-model
    https://learn.microsoft.com/en-us/dynamics365/business-central/application/base-application/table/microsoft.inventory.item.item-category

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 554 Super User 2026 Season 2

#2
YUN ZHU Profile Picture

YUN ZHU 344 Super User 2026 Season 2

#3
Teagen Boll Profile Picture

Teagen Boll 189 Super User 2026 Season 2

Last 30 days Overall leaderboard

Featured topics

Microsoft Training Manuals

Product updates

Dynamics 365 release plans