Variant of a new product to the invoice
When I add a product with a different variant of a new product to the invoice; The product variants I added before are changing. I cannot create different product variants on invoice. What could be the problem...
I think you use formula fields to fetch the data? Formula fields are always updated when things are changing in the source. Best practice is to use static fields instead and use a trigger to fill those fields. So after selecting a product, there is a trigger after update field where you can script the disired fields. Have a look at the built-in template 'invoices' example.
I didn't change original function code.
2. items 60cm and color was difrrent, but when I added 7. invoice items 60cm as SILVER .. first item color changed..
That's weird, maybe it's a Ninox bug? I can't explain it.