SQL Code converting into JDE code

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

Considering this post in conjunction with your recent post requesting help with date formats, I think what you need is training (contact And Klee from JDE Tips), or at the very least reading a manual or two on JDE development (available from the Oracle support website).
 
IF F0911.GLICUT = "K, M, W"
DO CUSTOM SECTION (Print F0414) (which is based on a BSVW matching your select statement)
ELSE
IF F0911.GLICUT = "RB"
DO CUSTOM SECTION (Print F03B13) (which is based on a BSVW matching THAT select statement)
ENDIF
etc

However, I agree w/Peter that some training would help a great deal.
 
Back
Top