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

Notifications

Announcements

No record found.

Community site session details

Community site session details

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

Invoice Discount Pct (%) in Posted sales invoice and report 206

(0) ShareShare
ReportReport
Posted on by 3,013

Wondering if there is a straight forward way of printing the Invoice Discount Pct(%) in report 206 sales Invoice. Seems like when you apply an invoice discount % to a sales order, this information does not transfer to the posted sales invoice header; we only have de discount amount. 

It's a very common and basic requirement that the customer likes to have this information in it's printed invoice, so that they know the commercial terms applied.

For example, recently we had this situation:

Total goods amount was 62.42 €

invoice discount pct applied in the sales order: 9.25%

The invoice discount Amount that is posted is rounded to 2 decimals: 5.77 (the actual discount is 5.77385)

In the posted sales invoice, we have no way of knowing the original discount pct, if we calculate using the data we have 62.42 total and 5.77 discount, we get 9.24%, so there is a rounding problem in the calculation.

Any ideas to have the original discount % in the posted sales invoice?

I have the same question (0)
  • Suggested answer
    Franziska Fiegler Profile Picture
    on at

    Hi,

    The field "Invoice discount value" is not part of the standard Report 206, but the information is available in the posted Sales Invoice header. You can check this with Ctrl+Alt+F1.

    If you want this printed on the posted Sales invoice, you need to add this to the report individually.

    Additionally you can create an ideas entry, to make MS aware about this need.

    Product Suggestions (select the forum for Business Central !)

             experience.dynamics.com/.../

    BR

    Franziska

  • Ghetz Profile Picture
    3,013 on at

    I can see the "Invoice discount value" field in the posted Sales Invoice header table, but this is the Amount value of the discount. I can't see any field with the discount %, por example 9.25% in the Ctrl+Alt+F1 window.

  • Suggested answer
    Inge M. Bruvik Profile Picture
    1,111 Moderator on at

    You should find the information you need in the fields no 121 and 122 Invoice discount Calculation and Invoice discount  Value in the sales invoice header table.

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…

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,238

#2
YUN ZHU Profile Picture

YUN ZHU 773 Super User 2025 Season 2

#3
Sumit Singh Profile Picture

Sumit Singh 630

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans