cancel
Showing results for 
Search instead for 
Did you mean: 

How to Display Item Property Description

Former Member
0 Kudos
125

Hi

In Sales Quotation lines i want to display the name of the item property on selecting item . How this can be achieved.

Thanks

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Closed . Thanks Everyone

sanju_ms
Active Contributor
0 Kudos

Hi,

In item list menu screen, click on form settings and bring most of the fields that are available in the Item master.

Regards,

Sanju M S

Former Member
0 Kudos

Hi

What i want is there are 4 properties Property1,Property2,Property3,Property4 . 1 item will have 1 property out of thse. I want only that property for that item which is selected in that item . I want to store this property name in UDF.and then use it in printing.

Thanks

sanju_ms
Active Contributor
0 Kudos

Hi,

You can bring only one item property in PLD

Table name : OITG

Field name : ItmsGrpNam

Regards.

Sanju M S

Former Member
0 Kudos

Hi Sanju

Can u pls help me with query which fields are to be linked between2 tables.

Thanks

sanju_ms
Active Contributor
0 Kudos

Hi,

I just link between the item and the item properties.

i have renamed the item property as IT1, IT2 and IT3 continuously

just try this query :-

SELECT T0.[ItemCode] AS 'Item No.', T1.[ItmsGrpNam] AS 'Property Name' FROM [dbo].[OITM] T0 , [dbo].[OITG] T1 WHERE T1.[ItmsGrpNam] Like N'IP%'

Regards,

Sanju M S

Former Member
0 Kudos

Hi Sanju

In Sales Quotation rows i enter item no , after entering item no i want property name should be displayed.

I have defined properties

Paper Roll

Cotton Roll

Licosys Roll

Now if item is Cotton Roll only its Cotton Roll will be selected . In sales quotation i wanted if item is cotton roll then property cotton roll should be displayed . It is not mandatory if item property is cotton roll , item name will be also like that .

I am sorry if i am not able to explain correctly

Thanks

Former Member
0 Kudos

Hi Sanju

I think it is a complicated one , We need to create Store Procedure

Thanks

sanju_ms
Active Contributor
0 Kudos

Hi,

In standard you cannot do such operations.

Better to define a UDF, then update value as the item select.

regards,

Sanju M S

former_member204969
Active Contributor
0 Kudos

To get the description of the first set item property from the first 4 you can use this FMS on a row level UDF set autorefresh according to the Item No.:

declare @i integer
Set @i=
(Select Case when i.QryGroup1='Y' then 1
       else case when i.QryGroup2='Y' then 2
       else case when i.QryGroup3='Y' then 3
       else case when i.QryGroup4='Y' then 4
       else 0 end end end end
	From OITM i where i.ItemCode=$[$38.1.0])
Select g.ItmsGrpNam from OITG g where g.ItmsTypCod=@i

Former Member
0 Kudos

Hi

Thanks