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

Announcements

News and Announcements icon
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,029

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
    Microsoft Employee 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,029 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
    IB-29041624-0 Profile Picture
    1,191 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

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the May 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,050 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 1,351 Super User 2026 Season 1

#3
Grigorios Mavrogeorgis Profile Picture

Grigorios Mavrogeorgis 1,200 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Microsoft Training Manuals

Product updates

Dynamics 365 release plans