Query: Select GLAccGLCaption with missing ClientType

Select * from [GLAccGLCaption] LEFT JOIN [ClientType] ON ([GLAccGLCaption].[TableId] = [ClientType].[Id] and [GLAccGLCaption].[DBId] = [ClientType].[DBId]) where [GLAccGLCaption].[TableName] = ‘ClientType’ and [ClientType].[Id] Is Null Select * from...

Query: Verify GLYEBalance

Select [GLMovement].[DBId] as [ResDBId], [GLMovement].[GLPeriodId] as [ResGLPeriodId], [GLMovement].[GLAccountId] as [ResGLAccountId], [GLMovement].[CurrencyId] as [ResCurrencyId], Round(Sum(Case When [GLMovement].[CD] = ‘D’ Then [GLMovement].[Amount] Else...

Query: Check accounts in options

Select * from [Options] where convert(varchar, [Options].[DBId]) + ‘-‘ + [Options].[Variable] + ‘-‘ + [Options].[OrgTable] + ‘-‘ + [Options].[OrgTable] + ‘-‘ + convert(varchar, [Options].[FieldId]) in (Select...

Query: Accounts being used after account end date

Select [GLAccount].[DBId], [GLAccount].[Number] + ‘, ‘ + [GLAccount].[Name], count([GLMovement].[EntryNumber]) from [GLMovement] INNER JOIN [GLAccount] On ([GLMovement].[GLAccountId] = [GLAccount].[Id] and [GLMovement].[DBId] = [GLAccount].[DBId]) where...

Query RelationType

Select * from (Select [DBId], [Id], [Label], [Inverselabel] from [RelationType]) as [Res1] INNER JOIN (Select [DBId], [Id], [Label], [Inverselabel] from [RelationType]) as [Res2] ON ([Res1].[DBId] = [Res2].[DBId] and [Res1].[Label] = [Res2].[Inverselabel] and Not...