There might be an easy SmartList for this but we just build views in SQL. I'm not sure what type of back-end system access you have so you might need the assistance of IT but here's the query you'll need to pull it.
SELECT
FA.ACCTGRPINDEX as GROUPINDEX,
FA.ACCTGRPID as GROUPID,
FA.ACCTGRPDESC as GROUPDESC,
ISNULL(GL.ACTNUMST,'') as DEPRECIATION_EXPENSE,
ISNULL(GL2.ACTNUMST,'') as DEPRECIATION_RESERVE,
ISNULL(GL3.ACTNUMST,'') as PRIOR_YEAR_DEPRECIATION,
ISNULL(GL4.ACTNUMST,'') as ASSET_COST,
ISNULL(GL5.ACTNUMST,'') as PROCEEDS,
ISNULL(GL6.ACTNUMST, '') as RECOGNIZED_GL,
ISNULL(GL7.ACTNUMST, '') as NON_RECOGNIZED_GL,
ISNULL(GL8.ACTNUMST, '') as CLEARING
FROM FA41300 FA
left join GL00105 GL on GL.ACTINDX = FA.DEPREXPACCTINDX
left join GL00105 GL2 on GL2.ACTINDX = FA.DEPRRESVACCTINDX
left join GL00105 GL3 on GL3.ACTINDX = FA.PRIORYRDEPRACCTINDX
left join GL00105 GL4 on GL4.ACTINDX = FA.ASSETCOSTACCTINDX
left join GL00105 GL5 on GL5.ACTINDX = FA.PROCEEDSACCTINDX
left join GL00105 GL6 on GL6.ACTINDX = FA.RECGAINLOSSACCTINDX
left join GL00105 GL7 on GL7.ACTINDX = FA.NONRECGAINLOSSACCTINDX
left join GL00105 GL8 on GL8.ACTINDX = FA.CLEARINGACCTINDX
