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