I use a customer field in the product data. Let's say Serial Number. When I sell an item I then edit that product and put the appropriate serial number in that field. Problem is that all existing invoices that happen to have that item on now change as well. I would imagine that that's an oversight rather than by design. When I change the price of the product, it does not affect prior invoices. Anything that can be done about this?
if you have a custom field for a products - say Serial Number - then any change to the value of that Custom Field for a specific product will get reflected in all past invoices
- this was the intended design - but i'm still thinking about it if the best option
but i think there are ways to get what you want - you can use Consulting style invoices and enter the serial number in per product - or use custom fields in the invoices - they wont change etc..
There are other options but im not sure what you sell and how much etc..
The Customer Field in invoices will go some way to achieve what I want, but not fully. We sell pc components for example. A hdd would be a product, and we may sell 5 on an invoice, each with its own Serial number. The total invoice option works as well, but is not idea. It's not our core business and hence we don't use a proper point-of-sale system.
I would consider the ability of a customer field that does not change all previous invoices - if only in the light of one forgetting that it does that and once you have made a change you may have wiped important info from an older invoice :-(.
