Images in Item Master Data should come in Sales Order

[former_member573912]

I want to upload images in item master data . And it should display in SO row level ,if this is not possible i want to put some remarks in item master data against particular item and it should fetch automatically when posting SO in row level against each item.

Please answer this , in which field i have to keep the remarks in item master data it should fetch in SO also

[Abdul]

For images you have to upload filename with path on item master data and it will be shown on crystal layout of sales order not on screen.. For second option you create new udf on master data and put remarks there or you can put remarks in any free field like foreign name and deploy a FMS on sales order to fetch FMS will be like Select FrgnName from OITM where ItemCode = RDR1.ItemCode

[former_member573912]

Please provide the proper query its not working.

If I want to fetch the remarks from ,item master Remarks field or from Free Text of Item Master to row level of SO .What will be the query,if possible pls provide the template

[Abdul]

Use this for remarks in front of Active field. This query will not work in query generator you have to save it and deploy on desired field of SO then when you click on that field after selecting item it will show results.

Select ValidComm from OITM where ItemCode = $[RDR1.ItemCode]