Skip to Content
author's profile photo Former Member
Former Member

I need a Small FMS query.

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.



Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

4 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jul 28, 2014 at 06:10 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Kennedy T

      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..

      nodata.png (92.2 kB)
  • Posted on Jul 28, 2014 at 05:13 AM

    Hi Srinivas..

    Try This

    Select $[rdr1.SalFactor1 ]* $[rdr1.U_Manpric] from rdr1 t1

    inner join oitm t2 on t2.itemcode = t1.itemcode

    Regards

    Kennedy

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 28, 2014 at 05:26 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jul 29, 2014 at 01:24 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.