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

Notifications

Announcements

No record found.

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
    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
    on at

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

  • Suggested answer
    YUN ZHU Profile Picture
    95,729 Super User 2025 Season 2 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

Responsible AI policies

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

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,238

#2
YUN ZHU Profile Picture

YUN ZHU 773 Super User 2025 Season 2

#3
Sumit Singh Profile Picture

Sumit Singh 630

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans