Hi,
I am looking for a way to create custom part numbers. I have a lot of custom products and the part numbers need to be created when my customer requests pricing. The way I would like to structure the part number is using a fixed abbreviations (CP for custom part) followed by the Julian date (Current formula is =TEXT(TODAY() ,"yy")&TEXT((TODAY() -DATEVALUE("1/1/"&TEXT(TODAY(),"yy"))+1),"000") ), finally I would like to add a two digit suffix that is created in chronological order (-01 followed by -02 ). Right now I am using concatenate to create the list but sometimes people are not marking a part number as being used and as a result I am getting duplicate part numbers which is causing a lot of confusion when an order is finally placed. What I would ideally like to have is a macro where my sales staff can click on a button and the next available number for the day will be selected. This way I can avoid any duplication of parts numbers.
I am looking for a way to create custom part numbers. I have a lot of custom products and the part numbers need to be created when my customer requests pricing. The way I would like to structure the part number is using a fixed abbreviations (CP for custom part) followed by the Julian date (Current formula is =TEXT(TODAY() ,"yy")&TEXT((TODAY() -DATEVALUE("1/1/"&TEXT(TODAY(),"yy"))+1),"000") ), finally I would like to add a two digit suffix that is created in chronological order (-01 followed by -02 ). Right now I am using concatenate to create the list but sometimes people are not marking a part number as being used and as a result I am getting duplicate part numbers which is causing a lot of confusion when an order is finally placed. What I would ideally like to have is a macro where my sales staff can click on a button and the next available number for the day will be selected. This way I can avoid any duplication of parts numbers.
