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

Announcements

Check out the Community Spotlight Video Series
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... / Filter a Sales Invoice...
Small and medium business | Business Central, N...
Suggested Answer

Filter a Sales Invoice. Trying to remove certain columns in the generated sales invoice before sending to customer.

(0) ShareShare
ReportReport
Posted on by Dylan Vincent 70

Hello, 

I am trying to to remove certain columns in the generated sales invoice before sending to customer.

Our POs have all the required information we need when generated. When a sales invoice is geneated, we would like to modify the sales invoice by removing a description colum before posting/ sending. Not sure if this would be an option but we could also post the sales invoice then modify the invoice by removing the colum before sending to the customer. 

Overall just trying to modify the details (1 column removal) before sending to customer. 

I've tried to print and use "filter" but not having any luck

pastedimage1658857127847v1.png

I am trying to remove the "description comment"

pastedimage1658857252962v2.png

INVOICE PREVIEW

pastedimage1658857332655v3.png

Categories:
Dynamics 365 Business Central
I have the same question (0)
  • Suggested answer
    IB-29041624-0 Profile Picture
    IB-29041624-0 1,191 Moderator on at

    Unfortunately you can not filter out that when you run the report.

    You will have to modify the report layout either in word or in report builder.

  • Dylan Vincent Profile Picture
    Dylan Vincent 70 on at

    Internally, would we be able to utilize the report layout, make the sales invoice to what we would want then apply it?

  • Suggested answer
    IB-29041624-0 Profile Picture
    IB-29041624-0 1,191 Moderator on at

    It is not the easiest layout task. So if you not are familiar with working with the report layouts i will recommend you to contact your partner and have them assist you. It should not take them too long and will same you from having to learn it yourself.

  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 102,811 Super User 2026 Season 2 on at

    Hi, This requires customization. First add the field of the condition with the Report Extension.

    https://yzhums.com/10723/

    Then in the RDLC Layout file, Set the colum displayed or not displayed according to the added conditional fields.

    https://docs.microsoft.com/en-us/sql/reporting-services/report-design/expression-examples-report-builder-and-ssrs?view=sql-server-ver16#DecisionFunctions

    Hope this can give you some hints.

    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

News and Announcements

Check out the Community Spotlight Video Series

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders

These are the community rock stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 520 Super User 2026 Season 2

#2
YUN ZHU Profile Picture

YUN ZHU 384 Super User 2026 Season 2

#3
Grigorios Mavrogeorgis Profile Picture

Grigorios Mavrogeorgis 363 Super User 2026 Season 2

Last 30 days Overall leaderboard

Featured topics

Microsoft Training Manuals

Product updates

Dynamics 365 release plans