no discount details on invoice

Hello,

I've few products on sale, 10%, through sale maker and many people bought them, but the orders_products table doesn't store all these details e.g. the product price was 225.00/- and because of the sale it is available in 202.50/-

So, how do you check:

1. What was the product price and the sale price?
2. What type and how much discount was given on this particular product?

I checked records in orders_products table and for my surprise,
It simply stores 202.50 as the final price, so for accounting purposes, how do I get this as MRP 225.00 and Final Price 202.50 and discount 10% i.e. 22.50

Following is the record taken from orders_products table, just for reference:

orders_products_id, orders_id, products_id, products_model, products_name, products_price, final_price, products_tax, products_quantity, onetime_charges, products_priced_by_attribute, product_is_free, products_discount_type, products_discount_type_from, products_prid

47180, 20247, 224, '', 'ABC Book', 202.5000, 202.5000, 0.0000, 1, 0.0000, 0, 0, 0, 0, '224'

Since discount is not logged in the table the user gets following in the email:

Products

1 x ABC Book = Rs.202.50

Sub-Total: Rs.202.50
Zones Table Rate (1 x 470.00gms) (International): Rs.550.00
Total: Rs.752.50

So nowhere, it says, that merchant sold a product on sale, the customer doesn't get any discount details, though he is getting the discounted price. The Invoice doesn't say so.

Please tell me, how you are handling this problem?

Thanks