How to set the default for the Part S/N Format to be Alphanumeric?

ERP 10
1

Hello,

My boss was asking if it is possible to set the Part S/N Format to default to Alphanumeric?

Right now it defaults to Numeric only.

image
image620×527 11.1 KB

Also to Change it for existing parts that start with ‘XPR’?

Any help is appreciated!!!

Thanks,

Shawn

2

Hi Shawn,

For changing the existing parts that start with XPR to alternate setup, I recommend either DMT if you have it, an updateable query if you know how to do that, or search for all parts that start with XPR and then fix them manually. I do not believer there is any other system method for fixing a set of parts with new SN format.

To get the default of Alphanumeric, I ran a trace and it looks like your method is:
ChangePartSNBaseDataType

How about writing a preprocess directive on the method that sets Part.SNBaseDataType to CHARACTER only if the SNBaseDataType field is currently blank?

Nancy