Calling UsereDefined Field in Main Form
I have a user defined field which held color property of an item in Item Master Form.I want to call this property (color property) in sales order form with item's other attributes(like height ,width etc ) in row.Can it be possible ?
Former Member replied
It is definetely possible. You will need to have a UDF on the Marketing document rows. On this UDF you will set a formatted search
If your Item Master UDF is called U_Color the formatted search on the Sales Order row would be
SELECT T0.U_Color FROM [dbo\].[OITM\] T0 WHERE T0.ItemCode = $\[$38.1.0]
Set it to Auto Refresh on field ItemCode