Our business has recently run into the need to have the actual price of an item on the invoice, as well as what it's price paid is if its on sale. The price paid is included on the invoice object, but finding actual price of the item is impossible since the actual price may have changed since it was purchased.
I understand the mechanics of the EAV system, and i am going to do a lot of research on this problem and probably have to code a custom solution, but i thought i'd throw the question out here in case i'm missing something obvious. I am planning on approaching this from the viewpoint of "I need a custom module with table modifications"
I need this feature for audit reasons, so no looking in the admin log for price change history.