on 06-03-2011 5:46 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
94 | |
11 | |
10 | |
6 | |
5 | |
5 | |
4 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.