How to group with a query?

alex6789

How do you group lines (i.e. purchase lines) based on fields such as location code, posting group using a query? These lines would be grouped later when the document is posted and the grouping would be split into the separate documents

alex6789

Solution found, its linked with filtering