Skip to main content

Notifications

Small and medium business | Business Central, N...
Answered

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

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?

  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 73,035 Super User 2024 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
    Electrogas 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
    Jun Wang 7,433 Super User 2024 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
    Electrogas 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
    Jun Wang 7,433 Super User 2024 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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,134 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,928 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans