prasannavt
Member
Hi friends,
I am working Report, the code in SQL, how to converting into Jde code.
Please find below Code.
If F0911.GLICUT = "K”,”M” or W"
Print F0414.RNRMK
( SELECT RNRMK FROM F0413, F0414, F0911
WHERE F0911.GLDCT=F0413.RMDCTM
AND F0911.GLDOC=F0413.RMDOCM
AND F0911.GLAID=F0413.RMGLBA
AND F0911.GLICU=F0413.RMICU
AND F0911.GLICUT=F0413.RMICUT
AND F0413.RMPYID=F0414.RNPYID )
Else
If F0911.GLICUT = “RB”
Print F03B13.RZCKNU
(SELECT RZCKNU FROM F03B13, F03B14, F0911
WHERE F0911.GLDCT=F03B14.RZDCT
AND F0911.GLDOC=F03B14.RZDOC
AND F0911.GLKCO=F03B14.RZKCO
AND F0911.GLICU=F03B14.RZICU
AND F0911.GLICUT=F03B14.RZICUT
AND F03B13.RYPYID=F03B14.RZPYID )
If Not Found
"*************************"
End If
Else
If F0911.GLICUT = “V”
Print F0911.GLEXR
Else
If F0911.GLICUT = “IB”
Help me how to write code in event rules.
I am working Report, the code in SQL, how to converting into Jde code.
Please find below Code.
If F0911.GLICUT = "K”,”M” or W"
Print F0414.RNRMK
( SELECT RNRMK FROM F0413, F0414, F0911
WHERE F0911.GLDCT=F0413.RMDCTM
AND F0911.GLDOC=F0413.RMDOCM
AND F0911.GLAID=F0413.RMGLBA
AND F0911.GLICU=F0413.RMICU
AND F0911.GLICUT=F0413.RMICUT
AND F0413.RMPYID=F0414.RNPYID )
Else
If F0911.GLICUT = “RB”
Print F03B13.RZCKNU
(SELECT RZCKNU FROM F03B13, F03B14, F0911
WHERE F0911.GLDCT=F03B14.RZDCT
AND F0911.GLDOC=F03B14.RZDOC
AND F0911.GLKCO=F03B14.RZKCO
AND F0911.GLICU=F03B14.RZICU
AND F0911.GLICUT=F03B14.RZICUT
AND F03B13.RYPYID=F03B14.RZPYID )
If Not Found
"*************************"
End If
Else
If F0911.GLICUT = “V”
Print F0911.GLEXR
Else
If F0911.GLICUT = “IB”
Help me how to write code in event rules.