Skip to Content
0
Former Member
Jun 03, 2011 at 05:14 AM

Query error

94 Views

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