Hello there. Basically an issue has been cropping up recently wherein when I run a report (sales order with discount) the % discount listed on the report is doubled from what is on the actual system in the sales order itself. However the value is correct.
So for example, if I had in the sales order a value of 100.00 with a discount of 10%, so a discounted value of 90.00, the report would say value of 100.00, with a discount of 20%, and a discounted value of 90.00. This could be misleading to customers. Strangely the glitch does not occur with all customers, however the customers it does occur with it occurs every time I try to produce this report for them, even if I enter a new sales order into the system. If I change the customer to one who is unaffected by the glitch (in the same sales order) then the amounts are then correct again.
Even more bizarrely if I run a proforma invoice with discount, the figures are correct, even when producing the glitched sales order report from the identical order in the system. I have used the report editor to look at the proforma invoice and the sales order reports and they both use "DISCOUNT_RATE" as the criteria for showing the discount %, so I really have no clue as to how the proforma report and the sales order report from the SAME sales order can generate wither 10% or 20% discount under this DISCOUNT_RATE criteria. Any help would be appreciated as this issue is concerning.