This website is not affiliated with, sponsored by, or approved by SAP AG.

Item Group

All postings related to Business One only

Moderators: Snowy, thx4allthefish

Item Group

Postby Niktosko » Tue Oct 23, 2012 5:11 am

Hi, I am creating a query like this:
SELECT T0.[ItmsGrpCod], SUM(T0.[OnHand]*T0.[AvgPrice]) AS StockValue FROM OITM T0 GROUP BY T0.[ItmsGrpCod] ORDER BY T0.[ItmsGrpCod]

In the result of the query I get the Item Group values as codes (numbers). But I need them as Group Names.

If I check the System Information of this field in Item Master Data, it is called ItmsGrpCod, but it shows text values.

Thanks.
Niktosko
 
Posts: 5
Joined: Tue Oct 23, 2012 2:48 am

Re: Item Group

Postby Niktosko » Tue Oct 23, 2012 8:02 am

Ok. Solved :). You can LOCK.

SELECT T1.[ItmsGrpNam], SUM(T0.[OnHand]*T0.[AvgPrice]) AS StockValue FROM OITM T0 INNER JOIN OITB T1 ON T0.ItmsGrpCod = T1.ItmsGrpCod GROUP BY T1.[ItmsGrpNam] ORDER BY T1.[ItmsGrpNam]
Niktosko
 
Posts: 5
Joined: Tue Oct 23, 2012 2:48 am


Return to Business One

Who is online

Users browsing this forum: No registered users and 1 guest





loading...


This website is not affiliated with, sponsored by, or approved by SAP AG.