Query Supplier.SupplierGLAccountId

by SEP | Oct 4, 2022 | Query

select [DBId], count(*) from [Supplier] where [SupplierGLAccountId] = 0 or [SupplierGLAccountId] is null group by [DBId]

Query Client.ClientGLAccountId

by SEP | Oct 4, 2022 | Query

Select [DBId], count(*) from [Client] where [ClientGLAccountId] = 0 or [ClientGLAccountId] is null Group by [DBId]

Query: Select person that should be match in Blacklist

by Frédéric Lamain | Jul 13, 2022 | Query

Select distinct [BlacklistedAlias].[FirstName] + ‘ ‘ + [BlacklistedAlias].[LastName]From [BlacklistedAlias] Inner Join [Blacklisted] On [BlacklistedAlias].[BlacklistedId] = [Blacklisted].[Id]Where [Blacklisted].[TableNumber] = 17 And...

Query: Select invalid GLYEBalance

by SEP | Jul 4, 2022 | Query

Select [Org].[DBId] as [ResDBId], [Org].[GLAccountId] as [ResGLAccountId], [Org].[CurrencyId] as [ResCurrencyId], [Org].[Type] as [ResType], [Dest].[CyStartBalance] as [ResCyStartBalance], [Org].[CyEndBalance] as [ResCyEndBalance], [Org].[Value] as [ResOptionValue]...

Query: Compare initial balance and Y/E Closing

by Frédéric Lamain | Jun 28, 2022 | Query

Select [GLAccountCur].[DBId], [GLAccount].[Number], [GLAccountCur].[GLAccountId], [GLAccountCur].[CurrencyId], [GLAccountCur].[Amount], [ResGLYEBalance].[StartBalance] from ([GLAccountCur] LEFT JOIN (Select [GLYEBalance].[DBId], [GLYEBalance].[GLAccountId],...

Query: Select InvoiceT total different from GLMovement total

by SEP | Feb 22, 2022 | Query

Select [ResInvoiceT].[DBId], [ResInvoiceT].[Number], [ResInvoiceT].[Id], [ResInvoiceT].[Type], [ResGLMovement].*, [ResInvoiceT].[Total] from (Select [GLMovement].[DBId], [GLMovement].[GLPeriodId], [GLMovement].[EntryNumber], [GLMovement].[InvoiceTId], Sum(Round(Case...