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

Community site session details

Session Id :
Small and medium business | Business Central, N...
Answered

"Invoice Discount Amount Excl Tax" no included on printed invoice?

(0) ShareShare
ReportReport
Posted on by 14

I've been setting sales orders up for our billing department to invoice, and our supply & commission orders almost always have a discount on the equipment. To include this discount on the invoice, I've been filling in the Invoice Discount Amount Excl Tax field, and the totals excluding and including tax include the discount in the math. But the printed / pdf invoice that gets generated and sent to the customer doesn't.include the discount, so customers are getting invoices that are substantially higher than their quotes.

How do I get the pdf invoice to take the discount into account?

I have the same question (0)
  • Suggested answer
    YUN ZHU Profile Picture
    91,036 Super User 2025 Season 2 on at
    RE: "Invoice Discount Amount Excl Tax" no included on printed invoice?

    Hi, if you calculate it, but it is not displayed in the layout file, I suggest you modify the layout file and add the "Invoice Discount Amount Excl Tax" field into it.

    https://learn.microsoft.com/en-us/dynamics365/business-central/ui-update-report-layouts

    Hope this helps as well.

    Thanks.

    ZHU

  • Electrogas Profile Picture
    14 on at
    RE: "Invoice Discount Amount Excl Tax" no included on printed invoice?

    Okay, thanks. I'll have to loop our billing people to do that I think.

  • Verified answer
    Jun Wang Profile Picture
    8,154 Super User 2025 Season 2 on at
    RE: "Invoice Discount Amount Excl Tax" no included on printed invoice?

    create a sales credit memo, use copy document to pull in the posted invoice,

    on the line, enter the amount to deduct from the total. If you don't feel comfortable, try test it out in a sandbox before fix it in live.

  • Electrogas Profile Picture
    14 on at
    RE: "Invoice Discount Amount Excl Tax" no included on printed invoice?

    I'll try that for next time. What can I do about the invoice that's already been created?

  • Verified answer
    Jun Wang Profile Picture
    8,154 Super User 2025 Season 2 on at
    RE: "Invoice Discount Amount Excl Tax" no included on printed invoice?

    I guess what happens is you manually entered the invoice discount on the sales order and posted it. If yes, you need to use the following button.  Test to find out if it works. If you want BC to calculate automatically, you need to set up discount for customers or by item per MS documentation which is readily available everywhere , here is a video link. 

    https://info.the365people.com/how-to-videos/dynamics-nav-sales-invoice-discount 

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…

Andrés Arias – Community Spotlight

We are honored to recognize Andrés Arias as our Community Spotlight honoree for…

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

#1
Sumit Singh Profile Picture

Sumit Singh 3,055

#2
Sohail Ahmed Profile Picture

Sohail Ahmed 2,682 Super User 2025 Season 2

#3
YUN ZHU Profile Picture

YUN ZHU 2,209 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans