on 2008 Dec 05 6:42 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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]
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Please mention your Exact requirment in detail, so that we can propose solution.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
105 | |
8 | |
6 | |
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.