Query: Item linked account when the GLMethod is ItemLevel.

Experts,

I need to provide a list of Items (Which have the GL Method of Item Level) and the corresponding Inventory, Revenue and COGS accounts.

When using the Query Generator I get no results in the Account column, here is the query that I used:

SELECT T0.[ItemCode], T0.[ItemName], T0.[GLMethod], T0.[IncomeAcct], T1.[AcctName] 

FROM OITM T0  LEFT OUTER JOIN OACT T1 ON T0.IncomeAcct = T1.AcctCode