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

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Showing Added Column o...
Small and medium business | Business Central, N...
Suggested Answer

Showing Added Column on report

(0) ShareShare
ReportReport
Posted on by Maro9595 105

Hi Guys,

I have added a new column to my sales line(from table and page extension) then up to posted sales invoice and the values are flowing well

pastedimage1671121303392v2.png

from one point user insert only value for narration column in sales line and post, then from posted document if i tried to print, that line is not showing on report

pastedimage1671121668997v3.png

How can I print that line to my report

thank you all

I have the same question (0)
  • Suggested answer
    DAnny3211 Profile Picture
    DAnny3211 11,397 on at

    ciao

    customize the report

    learn.microsoft.com/.../ui-rdlc-report-layouts

    learn.microsoft.com/.../ui-rdlc-report-layouts

    www.youtube.com/watch

    check my answer if it helped you, thanks

    DAniele

  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 95,729 Super User 2025 Season 2 on at

    Hi, Here is a very simple example.

    https://yzhums.com/10723/

    pastedimage1671148187061v1.png

    pastedimage1671148195654v2.png

    pastedimage1671148204996v3.png

    pastedimage1671148218976v4.png

    Hope this helps as well.

    Thanks.

    ZHU

  • Suggested answer
    Nitin Verma Profile Picture
    Nitin Verma 21,708 Moderator on at

    Hi,

    That field is missing to be added the Posted report, you can create a report extension for it.

    learn.microsoft.com/.../devenv-report-ext-object

  • Maro9595 Profile Picture
    Maro9595 105 on at

    Thank you ZHU,

    report extension is there already, but see my image there is a line which does not have type(item,fa,gl etc) in invoice, only narration is there, I want that empty line to show up on report as seen on invoice

  • Maro9595 Profile Picture
    Maro9595 105 on at

    Thank you Nitin,

    I did report extension before, now see once my image from invoice, report does not print that line which have narration only it skip it

  • Suggested answer
    pankaj.k Profile Picture
    pankaj.k 994 on at

    Hi Maro..

    I think this is your customize report. can you please show us your code??

    Note:

    1. if you are using any viability condition then please check it on layout line.

    2. if you are using filter Like  Type:: Item then please remove it.

  • Maro9595 Profile Picture
    Maro9595 105 on at

    Hello Pankaj,

    This is base report i have just extend and add that column, I think there is a way report is skipping line which does not have type

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…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,362

#2
YUN ZHU Profile Picture

YUN ZHU 867 Super User 2025 Season 2

#3
Sumit Singh Profile Picture

Sumit Singh 607

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans