Hi,

Query objects should allow generating in AL same queries can be done in SQL.

I found that is not possible to make a count of the district.

Here an example of the query I wrote in SQL:

Select [Customer No_], count(distinct([Currency Code])) as CurrenciesUsed from
[CRONUS UK Ltd_$Cust_ Ledger Entry]
where [Open] = 1
group by [Customer No_]