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... / 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 60

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
    Inge M. Bruvik Profile Picture
    Inge M. Bruvik 1,111 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 60 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
    Inge M. Bruvik Profile Picture
    Inge M. Bruvik 1,111 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 95,681 Super User 2025 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

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,606

#2
YUN ZHU Profile Picture

YUN ZHU 931 Super User 2025 Season 2

#3
Jainam M. Kothari Profile Picture

Jainam M. Kothari 773 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans