Error in Detailed Sales Report wih Total Discounts

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??

Reply to
Fabricio
Loading thread data ...

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

Reply to
Antonio Mazzeo

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.