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?
Solved
Implementing new pricing whitout affecting old invoices
Best answer by Hamlin_Krewson2
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.
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.
1 person likes this
+18It 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
We use a similar solution @TheTimeSavingCo
I am not tracking pricing but I am tracking animal weights at the time of certain events. So I have a look-up field to see the current weight and then an automation to make that a fixed value when a record is generated. This way, when the weight is updated in the future, it does not affect the fixed value but future records will contain this new value.
Thank you everyone for your valuable inputs ! Very grateful!
Reply
Most helpful members this week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.