cancel
Showing results for 
Search instead for 
Did you mean: 

Query listing Item and linked Accounts (For all 3 GLMethods)

former_member268870
Participant
0 Kudos

Experts,

I need to create a query that lists Item details from OITM and then the linked Inventory, Revenue and COGS account. Because the Items can be classified as GLMethod @Item, @ItemGroup & @Warehouse I'm having difficulty with the links between OITM and the related OITB, OITW and OACT tables.

When I use the Query generator the links seems to be wrong, as I get no data.

I need the following data:

SELECT T0.[ItemCode], T0.[ItemName], T0.[FrgnName], T1.[ItmsGrpNam], t0.[UserText], T0.[CreateDate] 
---Linked Inventory account, Linked Revenue Account, Linked COGS account
FROM OITM T0  INNER JOIN OITB T1 ON T0.ItmsGrpCod = T1.ItmsGrpCod

Accepted Solutions (0)

Answers (0)