actually i want combine two item groups..ur query is working..but my problem is combine two item groups..
for example keyboard is a item group and mouse is another item group...in keyboard so many company's like compaq, ibm,etc..whatever...and mouse also same...in two item groups have some list....
i want to combine two groups....i create accessories item group..keyboard and mouse groups to accessories...these are under come by accessories....
when we see in item no (in sales quotation) ,it shows accessories...when we press accessories, it shows keyboard and mouse, in that so many list is there....
In the current versions of B1 there is no support for grouping hierarchy. The idea has been suggested to SAP, but it remains to be seen if they will implement it.
Right now your only choice is user fields and user tables:
1. Create a user table for each level of grouping. In your case for example Group Level 1 (which will contain accessories ) and Group Level 2 (which will contain Keyboards and Mice ).
2. Add a user field to the Group Level 2 table, and connect it to the Group Level 1 table
3. With this userfield you can determine that Keyboards and Mice belong to Accessories
4. Add userfields to OITM for each group level.
At any rate, you won't be able to use this grouping in the standard reports in the B1 client. You will have to develop for example Crystal reports for that purpose.