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 :
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 66

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,177 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 66 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,177 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 100,214 Super User 2026 Season 1 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

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