AnsweredAssumed Answered

invoice unit price auto-enter

Question asked by peety on Feb 26, 2019
Latest reply on Feb 26, 2019 by davidhead

I am using the filemaker invoice template for an automotive repair shop and  would like the unit price to be automatically be entered, I could set it to auto-enter a value for example $79.95 but the issue I see with that is lets say next year we have a price increase to $84.95 and I change the auto-enter value all the previous invoice totals will change.

I need to figure out a way I can change unit price for periods of time for example from 1/1/2019 to 1/1/2020 unit price = 79.95 then from 1/1/2021 to 1/1/2024 = 84.95

I was successful doing this in my current invoice database with filemaker pro 5 it worked fine with one price increase once I tried to compound a second it messed ever thing up did not work.

So I am starting from scratch with filemaker pro 14 advanced this time would like to do it correctly.

Thank You

Peter

Outcomes