Newbies Ben Moore Posted September 8, 2016 Newbies Posted September 8, 2016 Often we have to revise estimates for a customer, and they may come back and order against an estimate that is not the most recent. I am trying to find the best way to tie all the estimates together with the same Estimate or Job #, and increment a revision #. So far I've created a Job# field, and a Revision number field, but having trouble getting the revision number and job number to increment correctly when I have a new estimate vs a revision. Any suggestions?
Jonathan Hogle Posted September 9, 2016 Posted September 9, 2016 Ben, There are a few details to hammer out before giving exact advise. The rub is that all our internal relationships are built around the "Estimate ID" field, and you would need to either rewire the entire system, or create a display ID. Both of these can be labor intensive. For some more information, please email me directly at [email protected] so we can discuss further details. Thanks, Jonathan Hogle
Newbies Ben Moore Posted September 28, 2016 Author Newbies Posted September 28, 2016 I ended up creating "Estimate Prefix" independent of the "Estimate_ID" field. This is an autogenerated serial number. When I create a revision, the prefix is copied and the serial number is reset -1, so the next NEW estimate is still in order. I did the same thing with the "Revision_#" field I created.
Recommended Posts
This topic is 3237 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now