Problem with inventory tracking

[Jon_Blackford]

Hello, I have been building out an inventory system that shows all products, the amount of inventory and the price per product. Within the base, this inventory table is used to link to a transaction table that allows you to generate a transaction with multiple products with a total value. Following this, the transactions table links to an invoicing table where you select the transactions that were made and puts it all into an invoice with use of the page designer app. This process works fairly well, I’m not super happy with it but it works for what it needs to do. Where my issue arises is that we are constantly changing pricing on parts we sell and I cant change the pricing without changing past records. I cant change the past records because my company wants to use them to track all past sales. I set up a table to put all inventory received into the system. In the receiving table, you input the item and the price that you want to sell the product at now but I don’t know how to figure out how to set price on past invoices so they don’t change when the new price is inputted. included is a video clip and photos so you can see how it functions.
Attached is a video link and photos!
Video of the base

[Hannah_Wiginton]

Hey @Jon_Blackford!

Welcome to the community!

Love the inventory system you’ve built!

Here’s a solution that someone else used:

Create a Prices table that links to your Inventory table

Preventing old invoices from updating their totals Ask the community

I have an invoice table that looks up prices from my inventory table. However, when I increase prices in my inventory table, all of my old invoices automatically inherit the newly increased prices. How do I keep my old invoices locked down to their old prices, for historical purposes? In other words, new prices should only affect new invoices moving forward… but should leave old invoices alone.