Error in Detailed Sales Report wih Total Discounts

Apr 26, 2005 1 Replies

I got this report from the Reports Library but it has a problem: Does not give the Total Discount right.



If I have sold an item for 2.99 and the regular price is 3.99 the Total Discount is 1.00 OK iF I have sold two items for 2.99 and the regular price is 3.99 the Total Discount is 1.00 WRONG (It should be 2 times 1.00 = 2.00) iF I have returned one item for 2.99 and the regular price is 3.99 the Total Discount is 1.00 WRONG (It should be -1 times 1.00 = -2.00)



Is there a way to fix this??


I have no total discounts in my report.. but you can open your report and go to 'Total Discount' field..

Formula = (TransactionEntry.FullPrice - TransactionEntry.Price)*TransactionEntry.Quantity

bye antonio

Join the Discussion

Have something to add? Share your thoughts — no account required.

Didn't find your answer?

Ask the community — no account required