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...
Answered

Report Extension for Production

(0) ShareShare
ReportReport
Posted on by 35

Hello, new to extension building and I am struggling to extend the Production Order Job card report with the column "Shelf No" from the "Item" table. 

I believe im just getting the syntax wrong. Im starting the extension with a table extension defining the field to add, then in the same app file defining the report extension. Where I am getting stuck is (i think) the table extension. Currently its this:

tableextension 50999 Shelf extends "Prod. Order Component"
{
    fields
    {
        field(50909; ShelfNo; Integer)
        {
            DataClassification = ToBeClassified;

        }
    }
}
This is creating an empty column. Do I need to use some form of query instead of defining a field above to extend that table then bring it into the reportextension?
Thank you for any help you can provide. 
I have the same question (0)
  • Suggested answer
    Andy Sather Profile Picture
    Microsoft Employee on at

    Hello  - We currently do not have dedicated Dev support via the Dynamics 365 Business Central forums, but I wanted to provide you some additional resources to assist.  If you need assistance with debugging or coding I would recommend discussing this on one of our communities.

    www.yammer.com/dynamicsnavdev

    I will open this up to the community in case they have something to add.

  • Verified answer
    Paul_BC_Newbie Profile Picture
    35 on at

    Hello Andy, 

    Thank you for following up. I actually figured it out (amazing what late nights and too much caffeine can help solve...)

    I ended up using "FlowFields" in the table extension. I wasnt familiar with that function and it worked great!

    To anyone that needs to add a column from another table into a report...Flowfields!!

  • Andy Sather Profile Picture
    Microsoft Employee on at

    Thank you for replying back to the community post with your Answer!

  • Suggested answer
    YUN ZHU Profile Picture
    100,214 Super User 2026 Season 1 on at

    Hi, glad to hear you solved the problem.

    FlowField is not a field that actually exists in the table, which is a bit like a lookup in Excel.

    More details: https://yzhums.com/5802/

    Hope this will also help.

    Thanks.

    ZHU

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the April Top 10 Community Leaders

These are the community rock stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 1,948 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 936 Super User 2026 Season 1

#3
Teagen Boll Profile Picture

Teagen Boll 616 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans