you are right a custom record would be essential. if you want to streamline it, a script is necessary for automation in capturing what should be the correct standard cost based on the effective date. I can help you on how it should be designed 🙂. No worries - I do not charge, I just want to help out :)