Hi I am new here so hello everyone
Ok I have built a point of sale database that I can book stock into and set a sellout price! So when I create an invoice I put the product code in and it pulls the description and sell price in for me (So far so good) Once I compleat the invoice's I can go back and check the older ones for my accounting (No problem) However this all fails when I change the sell price in my products file as it also changes the sell price on my old invoices, Making my accounts a joke
I have very little hair left now so I came here lol I need some idea on how to keep my stored data static please??
Thanks in advance lol

Ok I have built a point of sale database that I can book stock into and set a sellout price! So when I create an invoice I put the product code in and it pulls the description and sell price in for me (So far so good) Once I compleat the invoice's I can go back and check the older ones for my accounting (No problem) However this all fails when I change the sell price in my products file as it also changes the sell price on my old invoices, Making my accounts a joke

Thanks in advance lol
