cancel
Showing results for 
Search instead for 
Did you mean: 

Formatted search to auto generate Item No.

Former Member
0 Kudos

Hi,

Customer is using 2007A PL47. They had requirement to auto generate Item No based on UDF created in Item Master Data(OITM). The stock code structure is as follow:

Item No=EP(hardcode 2 char)+U_ProdRange U_ProdGroupU_ProdFamily+user defined text

The keystroke steps are:

1. Key in item description

2. Select drop down list for U_ProdRange in OITM

3. Select drop down list for U_ProdGroup in OITM

4. Select drop down list for U_ProdFamily in OITM

5. Formatted search to generate Item No based on 2,3, 4

6. User keys in user defined text in Item No

7. Fill in other relevant fields in Item Master Data

8. Add Item Master Data

May I know how to write the query in formatted search?

Regards

Thomas

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi,

As far as I know, your requirements may not be achievable because a new Item No. needs to be based on the existing Number. Not the one based on your selection on the fly. Item No. is the key of the item master table, it has to be the first field to be created for your new record.

Thanks,

Gordon

Former Member
0 Kudos

Hi,

I had got solution.

Try this Select TOP 1 'EP' +$[OITM.U_ProdRange] +$[OITM.U_Prodgroup] +$[OITM.U_ProdFamily]

Regards

Thomas