Check if General Ledger Account Number is unique

To proceed with this check execute the following queries according to your database type:

• Access database:
  Select * from [GLAccount] where[Number] in
(Select [Number] from [GLAccount] Group by [Number] having count(*) > >1)
  order by [Number], [Id]

  
• SQL Server database:
  Select * from [GLAccount] where convert(varchar, [DBId]) + '-' + [Number] in
(Select convert(varchar, [DBId]) + '-' + [Number]
from [GLAccount]
Group by convert(varchar, [DBId]) + '-' + [Number] having count(*) > 1)
order by [DBId], [Number], [Id]