Jun 27, 2024 08:53 AM
Hello !
I am using Airtable for invoicing. Very soon, I will have to increase prices. Is there a simple way to implement the new prices without affecting the already existing invoices?
Jun 27, 2024 03:26 PM
Probably the easiest solution is for you to create new inventory items with the updated price. You might want/need to re-name your old inventory so you don't continue to use them.
Something like adding a year to the name, or creating a new field to show 'current' (or whatever makes sense to you).
On your invoice, your linked field (for line items) can be limited to selection from a specific view or by a condition.
Jun 27, 2024 07:44 PM
It sounds like you're using a lookup field to display the prices? If so, you might want to consider restructuring your base so that you paste those values in at the time of the invoices creation so that price changes won't affect past invoices