Update lookup, but keep old rates for previous transactions
A quandary that has almost certainly been asked previously …
Each state has a sales tax rate.
So you have a lookup to that rate, and the tax properly calculates.
But when that tax rate changes, and the lookup is updated to the new rate, how do you ensure each *previous* transaction keeps calculating on the old rate?
A similar analogy would be a contact in a company. When there’s a new person in that position, and you update the lookup, how do you prevent all your previous transactions from updating to the new contact?
Many thanks in advance for any input on resolving this issue.