on 07-28-2014 6:03 AM
hi.
i need a small fms query i am not able to do it.
what is my requirement is
i create one Udf field which is amount type at sales order rows.
and in item master i enter some values at factor1 under sales data.
when ever i pick the item at sales order row level..
i need a calculation like
row level i enter like this
itemcode manual price(udffield)
001 25
001 is having factor1 value at item master is 5
then i need calculation like
select ((t2.SalFactor1 *100/100)*(t1.U_Manpric)) as ManualPrice from ordr t0 inner join rdr1 t1 on t0.docentry = t1.docentry inner join oitm t2 on t2.itemcode = t1.itemcode where t2.ItemCode ='00201010001'
i need above calculation
i tried
select ((t2.SalFactor1 *100/100)*($[$t1.U_Manpric.0.0])) as ManualPrice from ordr t0 inner join rdr1 t1 on t0.docentry = t1.docentry inner join oitm t2 on t2.itemcode = t1.itemcode where t2.ItemCode ='00201010001'
but not working
Any information plz update me.
Hi Srinivas,
Check below FMS.
select ((t2.SalFactor1 *100/100)*($[rdr1.U_Manpric.Number])) from ordr t0
inner join rdr1 t1 on t0.docentry = t1.docentry
inner join oitm t2 on t2.itemcode = t1.itemcode
where t2.ItemCode = $[rdr1.ItemCode]
Hope this helps
--
--
Regards::::
Atul Chakraborty
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
hi.
thanks for your reply.
I changed your query to
select ((t2.SalFactor1 /100)*($[rdr1.U_Manpric.Number])) from ordr t0
inner join rdr1 t1 on t0.docentry = t1.docentry
inner join oitm t2 on t2.itemcode = t1.itemcode
where t2.ItemCode = $[rdr1.ItemCode]
i remove *100 i need percentage
in some rows the value is not reflecting
may i now why.
hi.
Kenady t
thanks for your reply.
if i press picker it is showing nothing i mean no error is comming
values is 0.0 is coming.
if i press that line i mean i just put the cursor on the line empty line if i open the query at user defined query
no data was found coming..
may i know why it is comming
if i see the item master it is having factor 1
why it is comming i dont know.
i am checking diff diff scenario
i have some questins
1) is the item should have instock
i was thought earlier this is problem
but some items are having stock but still above problem is comming
2) if the item is belongs to service , is above will work.
i think it should work.
but in that point also i am checking.
plz update me what's wrong..
Hi,
Try this:
select ((t2.SalFactor1 /100)*($[rdr1.U_Manpric])) from ordr t0
inner join rdr1 t1 on t0.docentry = t1.docentry
inner join oitm t2 on t2.itemcode = t1.itemcode
where t2.ItemCode = $[rdr1.ItemCode]
Thanks & Regards,
Nagarajan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi
your request is not so clear .
1.you expect the manualprice to be 25 and the factor is 5 so is the price should be 5*25 ?
2. where the manualprice came from ? is .U_Manpric came from the item ?
shachar
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Srinivas..
Try This
Select $[rdr1.SalFactor1 ]* $[rdr1.U_Manpric] from rdr1 t1
inner join oitm t2 on t2.itemcode = t1.itemcode
Regards
Kennedy
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
89 | |
7 | |
7 | |
4 | |
4 | |
3 | |
3 | |
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.