Pull item code based on UDF
Wondering if something like this is possible...
We have a UDF in Item Master Data that contains our "web site item code" an alternate itemcode we use for sales on our web site.
Is it possible to add a UDF (call it WebCode) to the row level of a Sales Order and create a formatted search that will:
As I type a "WebCode" into the UDF field of Sales Order and then tab off, it will populate the Item No. field with the ItemCode associated with the UDF contents of an Items Master Data.
I might not be explaining the concept correctly. Please let me know if I should clarify anything.
It would be possible but I would suggest that rather than creating another UDF on the Sales Order lines, just add a formatted search to the itemcode / itemname field and the user can press shift+F2 and enter the Web Item code and then the SAP's item code would automatically be fetched.
Again this is just a suggession and it you definetely want to use the UDF then we can still do it.
Let me know the UDF name on the ItemMaster and I shall help you with the SQL