Search found 5 matches

by Niktosko
Tue Oct 23, 2012 8:02 am
Forum: Business One
Topic: Item Group
Replies: 1
Views: 3106

Re: Item Group

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]
by Niktosko
Tue Oct 23, 2012 7:48 am
Forum: Business One
Topic: Help with Query
Replies: 3
Views: 3764

Re: Help with Query

Yea, this was really simple. Thanks. We can LOCK the post.
by Niktosko
Tue Oct 23, 2012 5:11 am
Forum: Business One
Topic: Item Group
Replies: 1
Views: 3106

Item Group

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 In...
by Niktosko
Tue Oct 23, 2012 5:06 am
Forum: Business One
Topic: Help with Query
Replies: 3
Views: 3764

Re: Help with Query

Ok. I still miss some explanation, why this was not working for me. But found now my solution to get the result:

SELECT T0.[ItmsGrpCod], SUM(T0.[OnHand]*T0.[AvgPrice]) AS StockValue FROM OITM T0 GROUP BY T0.[ItmsGrpCod] ORDER BY T0.[ItmsGrpCod]
by Niktosko
Tue Oct 23, 2012 3:09 am
Forum: Business One
Topic: Help with Query
Replies: 3
Views: 3764

Help with Query

Hi, I am trying to make a query which will list all my items grouped by the item group and want to see the sum of value on stock (for each item group). I have been trying in the query generator for a while but I am still not able to get those sum in it. What is please wrong on this? SELECT T0.[ItemC...