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

Announcements

No record found.

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

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 577 Super User 2026 Season 1

#2
Giorgio Bonacorsi Profile Picture

Giorgio Bonacorsi 309

#3
Diego Mancassola Profile Picture

Diego Mancassola 259

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans