Autocreate item number within a number range

[Former Member]

A newbie question:

Can SBO auto generate an item number when the user adds a new item via the Item Master Data screen? Is it possible to define this number within a number range?

[Former Member]

another way to solve this is with a formatted search.

If your item numbers are only numbers, you can create a query to do the max(itembumber)+1 function and show that as the new item number.

I know some people have done the same even with item numbers like: A00001, B0001, and on.

Regards

Harold Gómez

[Former Member]

As Harold says, with formatted search you can do many nice things...

Also take a look at the <a href="http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_aa-az_3ied.asp">Trans-SQL reference</a> (if you are using SQL server as a database server), here you can find loads of information about the Trans-SQL language of SQL server...

[nicola_martella2]

Hi Lim.

SBO doesn't supply the series for Items object.

If you need so, you have to implement a function that realize this service and use a custom table to persist the information like as NNM1 table.

Ciao.

Nicola