darrenchadwick
New Member
- Joined
- Dec 8, 2005
- Messages
- 2
i own a childrens clothes shop and every 6 months i need to generate around 7000 individual stock codes. These are up to 13 digit alphanumerics in the format
AAA600018mon
TIM20013yr
ABC71237yr
is there an add in that will automate this given that there are certain items i need to control
first 3 digits - 3 letters representing brand
next 1 number - represents year
next 3 numbers - repr stock item from 000 to 999
last digits - represent size ie 3 months, 3 years
darren chadwick
AAA600018mon
TIM20013yr
ABC71237yr
is there an add in that will automate this given that there are certain items i need to control
first 3 digits - 3 letters representing brand
next 1 number - represents year
next 3 numbers - repr stock item from 000 to 999
last digits - represent size ie 3 months, 3 years
darren chadwick