cancel
Showing results for 
Search instead for 
Did you mean: 

FMS Item Code from OITM UDF in Sales Quotation

kedalenechong
Participant
0 Kudos
117

Hi All

I managed to write this FMS Query to auto Select T0.ItemCode from OITM where T0.U_A_CatNo =$[$38.U_A_CatNo.0] and able to search Item Number after typing BT Catalogue UDF but once I TAB to next field BT Catalogue UDF value disappeared.  Please advise is there any step I missed out or is this a FMS limitation search on Item Master Data UDF in Sales Quotation?

 

Select T0.ItemCode from OITM where T0.U_A_CatNo =$[$38.U_A_CatNo.0]

 

 

kedalenechong_2-1719290601015.png

 

kedalenechong_3-1719290677547.png

kedalenechong_5-1719290911539.png

 

Kedalene Chong

 

View Entire Topic
Felipe_Lima
Explorer
0 Kudos

Hi @kedalenechong ,

If I got that right, you're trying to trigger an FMS in the ItemCode field based on a UDF previously populated. I suppose this is not achievable as the Item No. (ItemCode) is the Primary Key of any document at the line level, which means that the first data to pass to a line must be the Item No.

Any field you fill in before informing the Item Code will be cleaned out once the PK is passed.

I hope it makes sense.

Regards,
Felipe