[icedchai]

You would solve this in a RDBMS the same way: de-normalize when you're saving the invoice (example: a line items table with snap shot of current item price, description, etc.)

[rmrfrmrf]

Yes, which suggests that the "serious problems" mentioned by the grandparent aren't serious (or problems) at all.