Skip to Content
0
Former Member
Feb 13, 2012 at 08:25 AM

Offset Account - Query

211 Views

Hi all,

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'

Regards,

Henry