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

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Unanswered

sales invoice report total discount

(0) ShareShare
ReportReport
Posted on by 406

hello,

I want to add the total discount % on my sales invoice report, but im facing some issues.

pastedimage1683722655623v4.png

to add the discount percentage which are 3.00/7.00/5.00 , im using the following expression: =iif(Fields!ShowGoodsDiscount1.Value = "No", Fields!DiscPercent.Value, Labels!@SYS95973)

but im having issues on adding the total discount % which is 10% and should show for all the items.( i guess the field name of the total discount % is also DiscPercent)

my other issue is regarding the taxAmount field. the calculation should be: Quantity-Discount Percentage-Total Discount Percentage

any help how it can be done?

thanks

I have the same question (0)

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

News and Announcements

Season of Giving Solutions is Here!

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 > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Abhilash Warrier Profile Picture

Abhilash Warrier 843 Super User 2025 Season 2

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 503 Super User 2025 Season 2

#3
Martin Dráb Profile Picture

Martin Dráb 288 Most Valuable Professional

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans