Show the sum of discount amount as a separate invoiceline

(0) Share

Report

Posted on by Community Member

I have an invoice with some discounts calculated in the lines. But I want to see the sum of all these discounts as a separate line, so the customer can see how much of a discount they have got.

I can calculate the discount per line, both as discount percentage and discount amount.

*This post is locked for comments

I have the same question (0)

All responses (7)

Answers (2)

Verified answer

Sohaib Cheema 49,438 User Group Leader on at

Like (0)

Report

1) add one more line as discount with -ve amount in it.

or

2) customize your report so that it will add one more line, always after lines are finished and that line will be displayed as part of your tablix on ssrs report

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Sohaib

what do you mean with -ve amount?

Was this reply helpful? Yes No
Sohaib Cheema 49,438 User Group Leader on at

Like (0)

Report

-ve amount means Unit Price less than zero.

it will deduct from your total of invoice and on control document it will appear as separate line

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

It sounds like a good solution. But I cant find this -ve amount in the fieldlist for the report.

Was this reply helpful? Yes No
Sohaib Cheema 49,438 User Group Leader on at

Like (0)

Report

in report it will appear as new line after all lines of +VE amounts.

Otherwise you can simply customize report to generate a extra line for your discount

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

It still sounds as a good solution. But the problem is I dont know how to do set it to -VE amount.

Was this reply helpful? Yes No
Verified answer

Community Member on at

Like (0)

Report
Hi Sohaib

I found a solution on this based on what you told me.

I added an extra line.

And then added this "Expression"
=(Fields!SalesPrice.Value * Fields!Qty.Value)-Fields!LineAmountInclTax.Value

And to set the Hidden property to True, when there are no discounts, I made this expression for the fields. =((Fields!SalesPrice.Value * Fields!Qty.Value)-Fields!LineAmountInclTax.Value) = 0

Was this reply helpful? Yes No