Changing price on a line item question.
Hi guys, just wondering if i can get some help on this one. I have a database in which i have clients, products and the ability to invoice clients with products. If i ever change the price on a line item, all the past invoices will then have a discrepency in the total amount. Is the only way around this to never change the price on a line item and create a new product everytime i want to change price?
2 replies
-
Hi,
Please have a look into the user manual in the paragraph Calculations -> Triggers
https://ninoxdb.de/en/manual/calculations/triggers
Kind regards, Jörg
-
Good afternoon,
i faced tye same issue and to prevent this to happen, I have created a field “price” in my invoice which field is populated from the main price list when the product is updated. In other word, the price is copied from the main price list into the invoice price field when the product is chosen.
doing this will allow you to change pricing in your main price list without changing prices in existing invoices.
Content aside
- 6 yrs agoLast active
- 2Replies
- 1747Views