I need to update about 300 existing PartNums that have lowercase letters in them to make them all uppercase. I already have a DD to handle new parts, but the CFO wants everything uniform.
I created a BAQ to filter down to only those PNs that have lowercase letters in them, then added it to a dashboard. My plan was a simple Paste-Update after converting the column to uppercase in Excel. However, it seems the system doesn’t view the change from lowercase to uppercase as enough of an ‘update’ to actually change the PN. The paste-update runs but all the PNs retain their lowercase status.
Is there a different way I should be doing this? Would DMT behave the same way? Should I do it directly in SQL (I know that’s not normally recommended)?
Thank you in advance for any guidance you can provide!
In my understanding there are two basic options here.
Deal with it. That is, either ignore it, or update your reports, and screens to display the PN as uppercase. I think this is what most people choose. If the part number is really an issue for a particular report or screen, then just update that report/customization.
Remove the part and readd it with the right case. This is not ideal as you lose traceability between parts before and after the update. You will have to pay attention to any quantity on hand. Adjust the quantity out and back in for each part. I really wouldn’t recommend this unless you have a darn good reason. Even then, I still would caution against this route.
If you are unsure and have the time to play, do a few days of testing in Pilot to make sure your changes happen the way you expect.