on 03-21-2019 5:21 PM
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
User | Count |
---|---|
86 | |
7 | |
6 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.