Query: Item linked account when the GLMethod is ItemLevel.

[former_member268870]

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

[former_member268870]

Is it true that there is no Link between OITM and OACT for Item Level GL determinationed Items?

Here is what I have found on the Forum: