Hi All,
On an inventory database, product costs change over the time. How do I maintain proper costs/prices on all invoices that do not get recalculated when new costs are setup for that same product.
Example,
On February 2010 we sold a TV Set for $300.00. Our cost for that TV Set on February was $200.00. How ever, today, the same TV Set now costs $225.00. When I add this new cost to the database it modifies all my previous transactions for that same TV Set and updates the cost to $225.00. How can I keep the previous transactions as they were entered with that previous cost of $200.00 and allow all future transactions to use the new cost of $225.00?
I am using Access 2007.
Thanks!