Baq- How to use subquery as column

Epicor ERP 10
1

Dear experts, Please suggest how to use subquery as column in baq refer to below sql statement

SELECT FA.AssetNum ‘Asset Code’,
FA.TagNum ‘Bar Code’,
FA.AssetDescription ‘Particulars’,
FG.Description ‘FA Group’,
FA.Location ‘Location’,
FA.AcquiredDate ‘Doc Date’,
FA.CommissionedDate ‘Effective Date’,
FM.Description ‘Depreciation Method’,
FD.AssetLife ‘FA Life’,
FD.AnnualDepRate ‘Rate (%)’,
FA.DocCurrentCostValue ‘Capital Cost’,
(SELECT IsNull(Sum(DocDepreciation),0) FROM Erp.FATran Where AssetNum = FA.AssetNum AND FiscalYear = 2019) ‘Depreciation 2019’,
(SELECT IsNull(Sum(DocDepreciation),0) FROM Erp.FATran Where AssetNum = FA.AssetNum AND FiscalYear < 2019) ‘Acc Dep Dec 18’
FROM Erp.FAsset FA
INNER JOIN Erp.FAssetDtl FD ON FA.Company = FD.Company AND FA.AssetNum = FD.AssetNum
INNER JOIN Erp.FAGroup FG ON FG.Company = FA.Company AND FG.GroupCode = FA.GroupCode
INNER JOIN Erp.FAMethod FM ON FD.Company = FM.Company AND FD.AssetMethod = FM.AssetMethod

2

Just have to build an Inner SubQuery with the wizard. You could also call a scalar function from the Calculated Field Editor (not needed in your case --> just keep in mind it is possible).