JD Edwards Account details by year

select

glan8 [Address Number],gldct [Do Ty],gldoc [Doc Number],glkco [Doc Co],

CONVERT

(CHAR(10),DATEADD(dy, cast(gldgj as varchar(10)) % 1000, DATEADD(yy, cast(gldgj as varchar(10)) / 1000,-1)),101) [G/L Date],

glvinv [Invoice Number]

,glexr Remarks,glexa Explanation ,-glaa/100 Amt,glu Units,glpo [Purchase Order],

gllt LedTy

from

jde_production.proddta.f0911 where glaid=[ShortAccountNo] and glfy=10