on 01-12-2017 1:35 AM
Hello Experts
I have a question, i am not sure if it is possible
I have created a field called Product Category in the Item Master Data UDF
My question, would it be possible to display this Product Category as a column in the Bill of Materials window.
So in the Item master data, all products will be categorised, and in the BOM the product codes rows will show which category they belong
Can someone tell me if it's possible and how i can acheive it
Thank You
Regards
Rahul
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Rahul,
I think that is possible. You need to setup a new Fild in ITT1 (length belongs to your filed Category)
after that you receive a new colum in you BOM.
now you need a query setup as Formatted search (you have to change to your field-Name)
SELECT U_Category FROM OITM T0
where itemCode = $[$3.1.0]
save this as query in your query-manager
open a bom and go to new fileld in ITT1 (Category)
Press: SHIFT-CTRL-F2 to enter Setup and search your saved query.
now the info from OITM will filled in BOM
hope that helps
Markus
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
108 | |
12 | |
11 | |
6 | |
5 | |
4 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.