Am trying to come up with a query that will display either Account Name or BP Name instead of the OFFSET ACCOUNT (JDT1.ContraAct) code. Notice when one drills down the account balance of any account under Chart of Accounts, only the code appears under the Offset Account column.
I will appreciate if you help me improve on the query below. Thank you.
SELECT T0.[RefDate], T2.[AcctName],T0.[ContraAct], T0.[Debit], T0.[Credit] FROM [dbo].[JDT1] T0 INNER JOIN [dbo].[OACT] T2 ON T0.Account = T2.AcctCode WHERE T0.[RefDate]= '%0'