Report Extension for Production

(0) Share

Report

Posted on by Paul_BC_Newbie

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.

All responses (4)

Answers (1)

Suggested answer

YUN ZHU 84,456 Super User 2025 Season 1 on at

Like (0)

Report

RE: Report Extension for Production

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

Like (0)

Report

RE: Report Extension for Production

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

Paul_BC_Newbie 35 on at

Like (0)

Report

RE: Report Extension for Production

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!!
Suggested answer

Andy Sather on at

Like (1)

Report

RE: Report Extension for Production

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.