Query Value

[Former Member]

Experts,

In order recommendation, there is a field called unit price, in one add on i need that unit price to get captured. but

select T1.Price from OITT T0, ITM1 T1 where T0.Code = T1.ItemCode and T0.PriceList = T1.PriceList and T0.Code='A110000'

this query gives no value. Thought i can see unit price thre in order recomendation for the item A110000.

select T1.Price from ITM1 also giving no value. where from this value is coming

Please help

[Former Member]

Hi,

Check 2 results:

select T1.Price from ITM1 T1 where T1.ItemCode='A110000'

select T0.PriceList from OITT T0 where T0.Code='A110000'

What are they?

Thanks,

Gordon