cancel
Showing results for 
Search instead for 
Did you mean: 

fms problem

Former Member
0 Kudos

hi kings

SELECT distinct T0.GrosProfit FROM ORDR T0 INNER JOIN RDR3 T1 ON T0.DocEntry = T1.DocEntry WHERE T0.DocNum =150119

the above query is working...when i put the $[ordr.docnum] that time its not working what is the problem

SELECT distinct T0.GrosProfit FROM ORDR T0 INNER JOIN RDR3 T1 ON T0.DocEntry = T1.DocEntry WHERE T0.DocNum =$[ordr.docnum]

Thanks & bet Regards

B.lakshmi Narayanan

Accepted Solutions (1)

Accepted Solutions (1)

vijay_kumar1
Contributor
0 Kudos

Hi Narayanan,

If you want to display the current gross profit value in the sales order header udf, the value

will be shown only when the document is added and press shift+ f 2 in the udf.

SELECT T0.[GrosProfit] FROM ORDR T0 WHERE T0.[DocNum] =$ ORDR.DocNum

Regards,

Vijay kumar

SAP Business One Forums Team

Answers (2)

Answers (2)

former_member583013
Active Contributor
0 Kudos

If the UDF is on the Order header level the you should use

SELECT distinct T0.GrosProfit FROM ORDR T0 INNER JOIN RDR3 T1 ON T0.DocEntry = T1.DocEntry 
WHERE T0.DocNum = $[$-8.0.Number]

Former Member
0 Kudos

its working to sales order document header level.....and its retrive the value 0

Former Member
0 Kudos

Please mention your Exact requirment in detail, so that we can propose solution.

Former Member
0 Kudos

hi

when sales order freight charges values i created the udf..The udf field get in gross profit values in current sales order

so only i try to put the fms..but when its i mention the docnum that time its working when i put $[ordr.docnum]

That time its through the error

Former Member
0 Kudos

Frieght Values and Sales Orders are two different forms.

FMS will not work with two different forms. FMS will work only for data within same form.

Hope you understood.